PACKAGE: APPS.ONT_ITM_PKG

Source

1 PACKAGE ONT_ITM_PKG AS
2 /* $Header: OEXVITMS.pls 120.2.12010000.3 2008/10/17 08:47:25 sahvivek ship $ */
3 
4 TYPE Address_rec_type IS  RECORD
5 (
6   add_source_type               VARCHAR2(30),
7   add_source_orgid              NUMBER,
8   add_contact_id                NUMBER,
9   add_party_name                VARCHAR2(360),
10   add_alternate_name            VARCHAR2(320), --bug 4231894
11   add_party_address1            VARCHAR2(2000),
12   add_party_address2            VARCHAR2(2000),
13   add_party_address3            VARCHAR2(2000),
14   add_party_address4            VARCHAR2(2000),
15   add_party_city                VARCHAR2(60),
16   add_party_state               VARCHAR2(60),
17   add_party_country             VARCHAR2(60),
18   add_party_postal_code         VARCHAR2(60),
19   add_party_phone               VARCHAR2(80),
20   add_party_email               VARCHAR2(2000),
21   add_party_fax                 VARCHAR2(80),
22   add_party_url                 VARCHAR2(2000),
23   add_party_contact_name        VARCHAR2(360)
24 );
25 
26 
27 
28 TYPE Address_table_type IS TABLE OF Address_rec_type
29 INDEX BY BINARY_INTEGER;
30 
31 Address_table Address_table_type;
32 
33 
34 
35 PROCEDURE Process_ITM_REQUEST (
36             p_line_rec                   IN  OE_Order_PUB.Line_Rec_Type,
37 x_return_status OUT NOCOPY VARCHAR2,
38 
39 x_result_out OUT NOCOPY VARCHAR2);
40 
41 
42 PROCEDURE  Get_Address (
43 	    p_source_id    		 IN  NUMBER,
44 	    p_source_type   		 IN  VARCHAR2,
45 	    p_contact_id		 IN  NUMBER,
46             x_party_name OUT NOCOPY VARCHAR2,
47             x_alternate_name OUT NOCOPY VARCHAR2, -- bug 4231894
48             x_address1 OUT NOCOPY VARCHAR2,
49 	    x_address2 OUT NOCOPY VARCHAR2,
50 	    x_address3 OUT NOCOPY VARCHAR2,
51 	    x_address4 OUT NOCOPY VARCHAR2,
52             x_city OUT NOCOPY VARCHAR2,
53             x_state OUT NOCOPY VARCHAR2,
54             x_country OUT NOCOPY VARCHAR2,
55             x_postal_code OUT NOCOPY VARCHAR2,
56             x_phone OUT NOCOPY VARCHAR2,
57             x_email OUT NOCOPY VARCHAR2,
58             x_fax OUT NOCOPY VARCHAR2,
59             x_url OUT NOCOPY VARCHAR2,
60             x_contact_person OUT NOCOPY VARCHAR2,
61             x_return_status OUT NOCOPY VARCHAR2);
62 
63 
64 PROCEDURE Update_Process_Flag(
65                         p_line_id     IN  NUMBER
66                          );
67 
68 PROCEDURE Init_Address_Table;
69 
70 
71 PROCEDURE Create_Request(
72             p_master_organization_id     IN  NUMBER,
73             p_line_rec                   IN  OE_ORDER_PUB.line_rec_type,
74 x_return_status OUT NOCOPY VARCHAR2);
75 
76 
77 PROCEDURE WSH_ITM_ONT(
78             p_request_control_id         IN   NUMBER    default null,
79             p_request_set_id             IN   NUMBER    default null,
80             p_status_code                IN   VARCHAR2  default null);
81 
82 END ONT_ITM_PKG;