1 PACKAGE OE_BULK_VALUE_TO_ID AUTHID CURRENT_USER AS
2 /* $Header: OEBSVIDS.pls 120.1 2006/05/15 05:30:28 mbhoumik noship $ */
3
4 ---------------------------------------------------------------------
5 -- FUNCTION Get_Contact_ID
6 -- Used to retrieve contact ID based on contact name and
7 -- contact organization. E.g. for ship_to_contact_id, p_site_use_id
8 -- should be ship_to_org_id
9 ---------------------------------------------------------------------
10
11 FUNCTION Get_Contact_ID
12 (p_contact IN VARCHAR2
13 ,p_site_use_id IN NUMBER
14 )
15 RETURN NUMBER;
16
17 --{ Bug 5054618
18 -- Function to get End customer site use id
19 FUNCTION END_CUSTOMER_SITE
20 ( p_end_customer_site_address1 IN VARCHAR2
21 , p_end_customer_site_address2 IN VARCHAR2
22 , p_end_customer_site_address3 IN VARCHAR2
23 , p_end_customer_site_address4 IN VARCHAR2
24 , p_end_customer_site_location IN VARCHAR2
25 , p_end_customer_site_org IN VARCHAR2
26 , p_end_customer_id IN NUMBER
27 , p_end_customer_site_city IN VARCHAR2 DEFAULT NULL
28 , p_end_customer_site_state IN VARCHAR2 DEFAULT NULL
29 , p_end_customer_site_postalcode IN VARCHAR2 DEFAULT NULL
30 , p_end_customer_site_country IN VARCHAR2 DEFAULT NULL
31 , p_end_customer_site_use_code IN VARCHAR2 DEFAULT NULL
32 ) RETURN NUMBER;
33
34 -- Function to get end customer contact id
35 FUNCTION GET_END_CUSTOMER_CONTACT_ID
36 ( p_end_customer_contact IN VARCHAR2
37 , p_end_customer_id IN NUMBER
38 ) RETURN NUMBER;
39 -- Bug 5054618}
40
41 ---------------------------------------------------------------------
42 -- PROCEDURE Headers
43 --
44 -- Value to ID conversions on header interface table for orders in
45 -- this batch.
46 -- It sets error_flag to 'Y' and appends ATTRIBUTE_STATUS column with a
47 -- number identifying each attribute that fails value to ID conversion.
48 ---------------------------------------------------------------------
49
50 PROCEDURE Headers(p_batch_id IN NUMBER);
51
52
53 ---------------------------------------------------------------------
54 -- PROCEDURE Lines
55 --
56 -- Value to ID conversions on lines interface table.
57 -- It sets error_flag to 'Y' and appends ATTRIBUTE_STATUS column with a
58 -- number identifying each attribute that fails value to ID conversion.
59 ---------------------------------------------------------------------
60
61 PROCEDURE Lines(p_batch_id IN NUMBER);
62
63
64 ---------------------------------------------------------------------
65 -- PROCEDURE Adjustments
66 --
67 -- Value to ID conversions on adjustments interface table.
68 -- This procedure also does pre-processing/entity validation for
69 -- adjustments.
70 ---------------------------------------------------------------------
71
72 PROCEDURE Adjustments(p_batch_id IN NUMBER);
73
74
75 ---------------------------------------------------------------------
76 -- PROCEDURE Insert_Error_Messages
77 --
78 -- This API uses ATTRIBUTE_STATUS column on headers and lines interface
79 -- tables to insert error messages for value to ID conversion failures.
80 ---------------------------------------------------------------------
81
82 PROCEDURE Insert_Error_Messages(p_batch_id IN NUMBER);
83
84
85 END OE_BULK_VALUE_TO_ID;