1 PACKAGE GML_OM_MIG_VALIDATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMLOMVAS.pls 120.1.12000000.2 2007/02/05 19:12:46 plowe ship $ */
3 -- bug 5840624
4 g_line_id NUMBER DEFAULT 0;
5 g_order_id NUMBER DEFAULT 0;
6 -- DEFINE FUNCTIONS THAT DERIVE THE VALUES FOR OM'S HEADER TABLE
7 Function VALIDATE_ORDER_NO(p_order_no in varchar2, order_id in number) return boolean;
8 Function VALIDATE_PAYMENT_TERM(p_terms_code in varchar2, p_term_id out Nocopy number, order_id in number) return boolean; -- GSCC b4403407 NOCOPY
9 Function VALIDATE_CURR_CODE(currency in varchar2) Return boolean;
10 Procedure ORDER_TYPE_ID(p_order_type in number, p_org_id in number, p_order_type_id out Nocopy number, -- GSCC b4403407 NOCOPY
11 p_price_list_id out Nocopy number, order_id in number);
12 Procedure ORIG_SYS_DOCUMENT_REF(p_orgn_code in varchar, p_orig_sys_document_ref out Nocopy varchar2, p_order_no in varchar2);
13 Procedure PRICE_LIST_ID (billing_currency in varchar2, order_id number, price_list out Nocopy number);
14 Procedure SHIP_TO_CONTACT_ID(p_contact_id in number, p_org_id IN NUMBER, ship_to_contact_id out Nocopy number,
15 order_id in number);
16 Procedure SHIP_FROM_ORG_ID(p_from_whse in varchar2, ship_from_org_id out Nocopy number, order_id in number);
17 Procedure SHIP_TO_ORG_ID(p_shipcust_id in varchar2, ship_to_org_id out Nocopy number, order_id in number);
18 Procedure INVOICE_TO_ORG_ID(p_billcust_id in varchar2, bill_to_org_id out Nocopy number, order_id in number);
19 PROCEDURE deliver_to_org_id(p_soldtocust_id IN VARCHAR2, deliver_to_org_id OUT NOCOPY NUMBER, order_id IN NUMBER);
20 Procedure FOB_POINT_CODE(p_fob_code in varchar2, fob_code out Nocopy varchar2, order_id in number);
21
22 -- DEFINE PROCEDURES THAT DERIVE THE VALUES FOR OM'S HEADER TABLE
23 Procedure VALIDATE_CUSTOMER(p_cust_id in number, v_cust_id out Nocopy number, order_id in number); -- GSCC b4403407 NCOPY
24 Procedure VALIDATE_SALESREP(slsrep_code in varchar2, salesrep_number out Nocopy number, order_id in number);
25 PROCEDURE validate_shipper(p_shipper_code in varchar2, p_organization_id IN NUMBER,
26 freight_carrier_code out Nocopy varchar2, p_ship_method_code in varchar2,
27 shipping_method_code OUT NOCOPY VARCHAR2, order_id in number); -- GSCC b4403407 NCOPY
28
29 Procedure FETCH_FREIGHT_TERMS_CODE(p_frtbill_mthd in varchar2, p_freight_terms_code out Nocopy varchar2, order_id in number);
30 PROCEDURE hold_reason_code(p_holdreas_code IN VARCHAR2, order_id IN NUMBER, line_id IN NUMBER, hold_id OUT NOCOPY NUMBER);
31 PROCEDURE migrate_ship_methods;
32 PROCEDURE get_rate_type_code(p_order_id IN NUMBER, p_orgn_code IN VARCHAR2, p_billing_currency IN VARCHAR2,
33 x_rate_type OUT NOCOPY VARCHAR2);
34 Procedure ERROR_LOG(p_header_id in NUMBER, p_line_id in NUMBER, p_column_name in varchar2,
35 p_error_text in varchar2, p_sqlcode in number, p_sqlerr_text in varchar2);
36 PROCEDURE GET_ORG_ID(p_orgn_code IN VARCHAR2, p_order_id IN NUMBER, p_sob_id out NUMBER, p_org_id OUT NOCOPY NUMBER); -- GSCC b4403407 NOCOPY
37
38 END GML_OM_MIG_VALIDATE_PKG;
[Home] [Help]