1 PACKAGE OE_BULK_PROCESS_HEADER AUTHID CURRENT_USER As
2 /* $Header: OEBLHDRS.pls 120.1.12010000.2 2008/11/18 03:23:18 smusanna ship $ */
3
4
5 -----------------------------------------------------------------
6 -- DATA TYPES (RECORD/TABLE TYPES)
7 -----------------------------------------------------------------
8
9 -- Global Table to store Sequence Types, indexed by Order Type ID
10 TYPE SEQ_INFO_TBL IS TABLE OF VARCHAR2(01) INDEX BY BINARY_INTEGER;
11
12 G_SEQ_INFO_TBL SEQ_INFO_TBL;
13
14
15 ---------------------------------------------------------------------
16 -- PROCEDURES/FUNCTIONS
17 ---------------------------------------------------------------------
18
19 ---------------------------------------------------------------------
20 -- Functions for cross-attribute validations e.g. agreement - price
21 -- list, price list - currency, customer - sites, site - site contacts.
22 ---------------------------------------------------------------------
23
24 FUNCTION Valid_Tax_Exempt_Reason
25 (p_tax_exempt_reason_code VARCHAR2
26 )
27 RETURN BOOLEAN;
28
29
30 FUNCTION Validate_Agreement
31 (p_agreement_id IN NUMBER
32 ,p_pricing_date IN DATE
33 ,p_price_list_id IN NUMBER
34 ,p_sold_to_org_id IN NUMBER
35 )
36 RETURN BOOLEAN;
37
38 FUNCTION Validate_Price_List
39 (p_price_list_id IN NUMBER
40 ,p_curr_code IN VARCHAR2
41 ,p_pricing_date IN DATE
42 ,p_calculate_price IN VARCHAR2 DEFAULT 'Y'
43 )
44 RETURN BOOLEAN;
45
46 FUNCTION Validate_Bill_to(p_sold_to IN NUMBER,
47 p_bill_to IN NUMBER)
48 RETURN BOOLEAN;
49
50 FUNCTION Validate_Ship_to(p_sold_to IN NUMBER,
51 p_Ship_to IN NUMBER)
52 RETURN BOOLEAN;
53
54 --abghosh
55 FUNCTION Validate_Sold_to_site(p_sold_to IN NUMBER,
56 p_Sold_to_site_use_id IN NUMBER)
57 RETURN BOOLEAN;
58 --
59
60 FUNCTION Validate_Deliver_to(p_sold_to IN NUMBER,
61 p_deliver_to IN NUMBER)
62 RETURN BOOLEAN;
63
64 FUNCTION Validate_Site_Contact
65 (p_site_use_id IN NUMBER
66 ,p_contact_id IN NUMBER
67 )
68 RETURN BOOLEAN;
69
70 FUNCTION Get_Freight_Carrier
71 (p_shipping_method_code IN VARCHAR2
72 ,p_ship_from_org_id IN VARCHAR2
73 )
74 RETURN VARCHAR2;
75
76 -- End customer functions(Bug 5054618)
77 FUNCTION validate_end_customer(p_end_customer_id IN NUMBER)
78 RETURN BOOLEAN;
79 FUNCTION validate_end_customer_contact(p_end_customer_contact_id IN NUMBER)
80 RETURN BOOLEAN;
81 FUNCTION validate_END_CUSTOMER_SITE_USE ( p_end_customer_site_use_id IN NUMBER,
82 p_end_customer_id IN NUMBER)
83 RETURN BOOLEAN;
84 FUNCTION validate_IB_OWNER ( p_ib_owner IN VARCHAR2 )
85 RETURN BOOLEAN;
86 FUNCTION validate_IB_INST_LOC( p_ib_installed_at_location IN VARCHAR2 )
87 RETURN BOOLEAN;
88 FUNCTION validate_IB_CURRENT_LOCATION ( p_ib_current_location IN VARCHAR2 )
89 RETURN BOOLEAN;
90
91
92 ---------------------------------------------------------------------
93 -- PROCEDURE Entity
94 --
95 -- Main processing procedure used to process headers in a batch.
96 -- IN parameters -
97 -- p_header_rec : order headers in this batch
98 -- p_defaulting_mode : 'Y' if fixed defaulting is needed, 'N' if
99 -- defaulting is to be completely bypassed
100 -- OUT parameters -
101 -- x_header_scredit_rec : sales credits for headers processed
102 --
103 -- Processing steps include:
104 -- 1. Restricted defaulting on p_header_rec if defaulting_mode is 'Y'
105 -- 2. Populate all internal fields on p_header_rec
106 -- 3. All entity validations
107 -- 4. Other misc processing like holds evaluation, sales credits.
108 ---------------------------------------------------------------------
109
110 PROCEDURE Entity
111 ( p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
112 , x_header_scredit_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
113 , p_defaulting_mode IN VARCHAR2 DEFAULT 'N'
114 , p_process_configurations IN VARCHAR2 DEFAULT 'N'
115 , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
116 , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'
117 , p_validate_desc_flex IN VARCHAR2 DEFAULT 'Y'
118 );
119
120 END OE_BULK_PROCESS_HEADER;