- f_cat_ins
string f_cat_ins
(
in string as_sid,
in string as_proj_1,
in string as_prod_cd_1,
in string as_size_code_1,
in string as_price_um_1,
in string as_pending_price_1,
in string as_unit_price_1,
in string as_rev_date_1,
in string as_charge_code_1,
in string as_class_1,
in string as_ord_point_1,
in string as_ord_qty_1,
in string as_minmax_1,
in string as_po_line_1,
in string as_lead_time_1,
in string as_rev_bulk_est_1,
in string as_orig_bulk_est_1,
in string as_cat_no_1,
in string as_unit_cost_1,
in string as_short_desc_1,
in string as_long_desc_1,
in string as_vendor_1,
in string as_alt_prod_cd_1,
in string as_supp_id_1,
in string as_mfg_1,
in string as_disci_cd_1,
in string as_bin_loc_1,
in string as_po_cost_1,
in string as_tag_no_1,
in string proj_std_pkg_qty_1,
in string proj_upc_code_1,
in string proj_submittal_no_1,
in string proj_approval_no_1,
in string proj_category_1,
in string proj_accounting_code_1,
in string proj_comm_app_no_1,
in string proj_weight_1,
in string proj_hscn_1,
in string proj_po_curr_code_1,
in string proj_po_cc_cost_1,
in string proj_met_price_1,
in string proj_met_lock_date_1,
in string proj_met_content_1,
in string proj_met_um_1,
in string proj_met_esc_flag_1,
in string proj_cable_mgmt_flag_1,
in string proj_cc_cost_rate_1,
in string proj_cc_cost_date_1,
in string proj_price_curr_code_1,
in string proj_cc_price_1,
in string proj_cc_price_rate_1,
in string proj_cc_price_date_1,
in string proj_dd_code_1,
in string proj_rebate_id_1,
in string proj_icn_flag_1,
in string proj_icn_no_1,
in string proj_direct_ship_flag_1,
in string proj_cost_group_1,
in string proj_po_line_cost_code_1,
in string proj_item_multiplier_1,
in string proj_mat_own_by_1,
in string proj_bin_loc_flag_1,
in string proj_in_main_warehouse_1,
in string proj_harmonized_code_1,
in string proj_c_of_o_1,
in string proj_eccn_1,
in string proj_sch_b_1,
in string proj_nmfc_1,
in string proj_mfc_1,
in string proj_haz_mat_code_1,
in string proj_dot_un_id_1,
in string proj_pack_instruction_1,
in string proj_packing_group_1,
in string proj_hazmat_class_1,
in string proj_proper_ship_name_1,
in string proj_tech_name_1
)
raises (CTS::PBUserException);
- f_cat_multi
string f_cat_multi
(
in string as_sid,
in string as_select,
in string as_search
)
raises (CTS::PBUserException);
- f_cat_new
string f_cat_new
(
in string as_sid
)
raises (CTS::PBUserException);
- f_cat_search
string f_cat_search
(
in string as_sid,
in string as_prod_code_1,
in string as_vendor_1,
in string as_size_1,
in string as_desc_1,
in string as_catalog_1,
in string as_supplier_1,
in string as_discipline_1,
in string as_altcode_1,
in string as_mfg_1,
in string as_bin_1,
in string as_category_1,
in string as_tag_no_1,
in string as_po_line_1,
in string as_long_desc,
in string as_row,
in string as_active,
in string as_currency,
in string as_description,
in string as_proj_icn_no,
in string as_key_word,
in string as_dd_discipline,
in string as_level1,
in string as_level2,
in string as_level3,
in string as_proj_po_line_cost_code,
in string as_in_main_warehouse,
in string as_class
)
raises (CTS::PBUserException);
- f_cat_search_sel
string f_cat_search_sel
(
in string as_sid
)
raises (CTS::PBUserException);
- f_cat_upd
string f_cat_upd
(
in string as_sid,
in string as_proj_1,
in string as_prod_cd_1,
in string as_size_code_1,
in string as_price_um_1,
in string as_unit_price_1,
in string as_previous_price_1,
in string as_rev_date_1,
in string as_charge_code_1,
in string as_class_1,
in string as_ord_point_1,
in string as_ord_qty_1,
in string as_minmax_1,
in string as_po_line_1,
in string as_lead_time_1,
in string as_rev_bulk_est_1,
in string as_orig_bulk_est_1,
in string as_cat_no_1,
in string as_unit_cost_1,
in string as_short_desc_1,
in string as_long_desc_1,
in string as_vendor_1,
in string as_pending_price_1,
in string as_alt_prod_cd_1,
in string as_supp_id_1,
in string as_mfg_1,
in string as_disci_cd_1,
in string as_bin_loc_1,
in string as_po_cost_1,
in string as_tag_no_1,
in string proj_std_pkg_qty_1,
in string proj_upc_code_1,
in string proj_submittal_no_1,
in string proj_approval_no_1,
in string proj_category_1,
in string as_active_1,
in string proj_accounting_code_1,
in string proj_comm_app_no_1,
in string proj_weight_1,
in string proj_hscn_1,
in string proj_po_curr_code_1,
in string proj_po_cc_cost_1,
in string proj_met_price_1,
in string proj_met_lock_date_1,
in string proj_met_content_1,
in string proj_met_um_1,
in string proj_met_esc_flag_1,
in string proj_cable_mgmt_flag_1,
in string proj_cc_cost_rate_1,
in string proj_cc_cost_date_1,
in string proj_price_curr_code_1,
in string proj_cc_price_1,
in string proj_cc_price_rate_1,
in string proj_cc_price_date_1,
in string proj_icn_no_1,
in string proj_icn_flag_1,
in string proj_dd_code_1,
in string proj_rebate_id_1,
in string proj_direct_ship_flag_1,
in string proj_cost_group_1,
in string proj_po_line_cost_code_1,
in string proj_item_multiplier_1,
in string proj_mat_own_by_1,
in string proj_bin_loc_flag_1,
in string proj_in_main_warehouse_1,
in string proj_harmonized_code_1,
in string proj_c_of_o_1,
in string proj_eccn_1,
in string proj_sch_b_1,
in string proj_nmfc_1,
in string proj_mfc_1,
in string proj_haz_mat_code_1,
in string proj_dot_un_id_1,
in string proj_pack_instruction_1,
in string proj_packing_group_1,
in string proj_hazmat_class_1,
in string proj_proper_ship_name_1,
in string proj_tech_name_1
)
raises (CTS::PBUserException);
- f_copy_cat
string f_copy_cat
(
in string as_sid,
in string as_proj,
in string as_column_list
)
raises (CTS::PBUserException);
- f_custinv_search
string f_custinv_search
(
in string as_sid,
in string as_prod,
in string as_cust_prod,
in string as_size,
in string as_class,
in string as_row
)
raises (CTS::PBUserException);
- f_em_search
string f_em_search
(
in string as_sid,
in string as_product_code,
in string as_vendor,
in string as_size_code,
in string as_short_desc,
in string as_row,
in string as_sel,
in string as_currency,
in string as_skip_zero_qoh,
in string as_price_currency
)
raises (CTS::PBUserException);
- f_em_upd
string f_em_upd
(
in string as_sid,
in string as_sel,
in string as_all_cols,
in string as_upd_cols
)
raises (CTS::PBUserException);
- f_exp_notes_dtl
string f_exp_notes_dtl
(
in string as_sid,
in string as_prod_cd
)
raises (CTS::PBUserException);
- f_exp_notes_upd
string f_exp_notes_upd
(
in string as_sid,
in string as_prod_cd,
in string as_notes
)
raises (CTS::PBUserException);
- f_gen_js
string f_gen_js
(
in string as_upd_cols,
in string as_sid
)
raises (CTS::PBUserException);
- f_inv_search
string f_inv_search
(
in string as_sid,
in string as_product_code,
in string as_vendor,
in string as_family_group,
in string as_short_desc,
in string as_row
)
raises (CTS::PBUserException);
- f_inv_vendor_popup
string f_inv_vendor_popup
(
in string as_sid,
in string as_colname
)
raises (CTS::PBUserException);
- f_inv_vendor_res
string f_inv_vendor_res
(
in string as_sid,
in string as_vendor,
in string as_name,
in string as_colname,
in string as_row
)
raises (CTS::PBUserException);
- f_ld_cat
string f_ld_cat
(
in string as_sid,
in string as_pg
)
raises (CTS::PBUserException);
- f_ld_pcat_drilldown
string f_ld_pcat_drilldown
(
in string as_sid,
in string as_colname
)
raises (CTS::PBUserException);
- f_ld_projcat_srch
string f_ld_projcat_srch
(
in string as_sid,
in string as_proj,
in string as_colname,
in string as_fields,
in string src_currency,
in string as_minmax
)
raises (CTS::PBUserException);
- f_ld_search
string f_ld_search
(
in string as_sid,
in string as_table,
in string as_colname,
in string as_fields,
in string as_project
)
raises (CTS::PBUserException);
- f_ld_ts_search
string f_ld_ts_search
(
in string as_sid,
in string as_colname,
in string as_fields
)
raises (CTS::PBUserException);
- f_pcat_drilldown_res
string f_pcat_drilldown_res
(
in string as_sid,
in string as_discipline,
in string as_dd_code,
in string as_level1,
in string as_level2,
in string as_level3,
in string as_key_word,
in string as_colname,
in string as_row,
in string as_level1x
)
raises (CTS::PBUserException);
- f_pcat_inv_drill_down_res
string f_pcat_inv_drill_down_res
(
in string as_sid,
in string as_discipline,
in string as_level1,
in string as_level2,
in string as_level3,
in string as_key_word,
in string as_dd_code,
in string as_colname,
in string as_row,
in string as_level1x
)
raises (CTS::PBUserException);
- f_pcat_pic
string f_pcat_pic
(
in string as_sid,
in string as_upc
)
raises (CTS::PBUserException);
- f_prod_doc
string f_prod_doc
(
in string as_sid,
in string as_prod_code_1,
in string as_supplier_1,
in string as_desc_1,
in string as_discipline_1,
in string as_vendor_1,
in string as_altcode_1,
in string as_size_1,
in string as_mfg_1,
in string as_catalog_1,
in string as_bin_1,
in string as_category_1,
in string as_tag_no_1,
in string as_po_line_1,
in string as_active,
in string as_currency,
in string as_long_desc,
in string as_row
)
raises (CTS::PBUserException);
- f_proj_cat_del
string f_proj_cat_del
(
in string as_sid,
in string as_code,
in string as_conf
)
raises (CTS::PBUserException);
- f_proj_cat_dtl
string f_proj_cat_dtl
(
in string as_sid,
in string as_code
)
raises (CTS::PBUserException);
- f_proj_cat_hist_list
string f_proj_cat_hist_list
(
in string as_sid,
in string as_prod
)
raises (CTS::PBUserException);
- f_proj_cat_hist_view
string f_proj_cat_hist_view
(
in string as_sid,
in string as_prod,
in string as_tran_date,
in string as_tran_time
)
raises (CTS::PBUserException);
- f_proj_offline_tran_ins
string f_proj_offline_tran_ins
(
in string as_sid,
in string as_select,
in string as_action,
in string qa_type_1,
in string qa_tran_type_1,
in string qa_adj_code_1,
in string qa_doc_no_1,
in string qa_ref_no_1
)
raises (CTS::PBUserException);
- f_proj_offline_tran_new
string f_proj_offline_tran_new
(
in string as_sid,
in string as_select,
in string as_action,
in string qa_type_1,
in string qa_tran_type_1,
in string qa_adj_code_1,
in string qa_doc_no_1,
in string qa_ref_no_1
)
raises (CTS::PBUserException);
- f_proj_offline_tran_upd
string f_proj_offline_tran_upd
(
in string as_sid,
in string as_select,
in string as_action,
in string qa_type_1,
in string qa_tran_type_1,
in string qa_adj_code_1,
in string qa_doc_no_1,
in string qa_ref_no_1
)
raises (CTS::PBUserException);
- f_projcat_analysis_rpt
string f_projcat_analysis_rpt
(
in string as_sid,
in string as_rep,
in string as_prod,
in string as_vendor,
in string as_active,
in string as_obsolete_only
)
raises (CTS::PBUserException);
- f_projcat_calc_pending_price
string f_projcat_calc_pending_price
(
in string as_sid,
in string as_conf,
in string as_prod,
in string as_vendor,
in string as_price_or_line_calc,
in string as_price_multi,
in string as_basis,
in string as_button,
in string as_line_basis
)
raises (CTS::PBUserException);
- f_projcat_res
string f_projcat_res
(
in string as_sid,
in string as_proj,
in string as_prod_code_1,
in string as_desc_1,
in string as_vendor_1,
in string as_row,
in string as_size_1,
in string as_catalog_1,
in string as_supplier_1,
in string as_discipline_1,
in string as_altcode_1,
in string as_mfg_1,
in string as_bin_1,
in string as_category_1,
in string as_colname,
in string as_fields,
in string src_currency,
in string as_minmax
)
raises (CTS::PBUserException);
- f_projcat_tradeserv_upd
string f_projcat_tradeserv_upd
(
in string as_sid,
in string as_code,
in string as_vendor,
in string as_upd_ts_only,
in string as_conf
)
raises (CTS::PBUserException);
- f_s_cust
string f_s_cust
(
in string as_sid,
in string as_table,
in string as_prod_code_1,
in string as_cust_1,
in string as_size_1,
in string as_class_1,
in string as_row,
in string as_colname,
in string as_fields,
in string as_key_word,
in string as_dd_discipline,
in string as_level1,
in string as_level2,
in string as_level3
)
raises (CTS::PBUserException);
- f_s_inv
string f_s_inv
(
in string as_sid,
in string as_table,
in string as_prod_code_1,
in string as_desc_1,
in string as_vendor_1,
in string as_family_1,
in string as_xref_1,
in string as_row,
in string as_colname,
in string as_fields
)
raises (CTS::PBUserException);
- f_s_proj
string f_s_proj
(
in string as_sid,
in string as_table,
in string as_colname,
in string as_fields,
in string as_prod_code_1,
in string as_desc_1,
in string as_vendor_1,
in string as_row,
in string as_size_1,
in string as_catalog_1,
in string as_supplier_1,
in string as_discipline_1,
in string as_altcode_1,
in string as_mfg_1,
in string as_bin_1,
in string as_category_1,
in string as_project,
in string as_key_word,
in string as_dd_discipline,
in string as_level1,
in string as_level2,
in string as_level3,
in string as_po_line_cost_code_1
)
raises (CTS::PBUserException);
- f_tradeserv_res
string f_tradeserv_res
(
in string as_sid,
in string as_upc_cd,
in string as_vendor,
in string as_desc,
in string as_row,
in string as_colname,
in string as_mfr_cat_num,
in string as_mfr_shortname,
in string as_fields
)
raises (CTS::PBUserException);
- f_tsi_specs
string f_tsi_specs
(
in string as_sid,
in string as_upc,
in string as_icn_flag,
in string as_icn_no,
in string as_submittal_no,
in string as_product_code,
in string as_column,
in string as_row,
in string as_menu
)
raises (CTS::PBUserException);