PACKAGE: APPS.ONT_ITM_PKG

Source

1 PACKAGE ONT_ITM_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXVITMS.pls 120.8 2011/03/25 09:39:56 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   add_hz_party_id               NUMBER(15),   --Bug 9583024
25   add_hz_party_number           VARCHAR2(30), --Bug 9583024
26   add_party_site_number         VARCHAR2(30), --Bug 9583024
27   add_contact_hz_party_id       NUMBER(15),   --Bug 9583024
28   add_contact_hz_party_number   VARCHAR2(30)  --Bug 9583024
29 );
30 
31 
32 
33 TYPE Address_table_type IS TABLE OF Address_rec_type
34 INDEX BY BINARY_INTEGER;
35 
36 Address_table Address_table_type;
37 
38 
39 
40 PROCEDURE Process_ITM_REQUEST (
41             p_line_rec                   IN  OE_Order_PUB.Line_Rec_Type,
42 x_return_status OUT NOCOPY VARCHAR2,
43 
44 x_result_out OUT NOCOPY VARCHAR2);
45 
46 PROCEDURE  Get_Address (
47 	    p_source_id    		 IN  NUMBER,
48 	    p_source_type   		 IN  VARCHAR2,
49 	    p_contact_id		 IN  NUMBER,
50 	    p_org_id_passed              IN  VARCHAR2, -- bug 9130718
51             x_party_name OUT NOCOPY VARCHAR2,
52             x_alternate_name OUT NOCOPY VARCHAR2, -- bug 4231894
53             x_address1 OUT NOCOPY VARCHAR2,
54 	    x_address2 OUT NOCOPY VARCHAR2,
55 	    x_address3 OUT NOCOPY VARCHAR2,
56 	    x_address4 OUT NOCOPY VARCHAR2,
57             x_city OUT NOCOPY VARCHAR2,
58             x_state OUT NOCOPY VARCHAR2,
59             x_country OUT NOCOPY VARCHAR2,
60             x_postal_code OUT NOCOPY VARCHAR2,
61             x_phone OUT NOCOPY VARCHAR2,
62             x_email OUT NOCOPY VARCHAR2,
63             x_fax OUT NOCOPY VARCHAR2,
64             x_url OUT NOCOPY VARCHAR2,
65             x_contact_person OUT NOCOPY VARCHAR2,
66             x_hz_party_id                OUT NOCOPY NUMBER,   --Bug 9583024
67             x_hz_party_number            OUT NOCOPY VARCHAR2, --Bug 9583024
68             x_party_site_number          OUT NOCOPY VARCHAR2, --Bug 9583024
69             x_contact_hz_party_id        OUT NOCOPY NUMBER,   --Bug 9583024
70             x_contact_hz_party_number    OUT NOCOPY VARCHAR2, --Bug 9583024
71             x_return_status              OUT NOCOPY VARCHAR2);
72 
73 
74 PROCEDURE Update_Process_Flag(
75 			p_header_id   IN  NUMBER, -- Bug 11797031
76                         p_line_id     IN  NUMBER
77                          );
78 
79 PROCEDURE Init_Address_Table;
80 
81 
82 PROCEDURE Create_Request(
83             p_master_organization_id     IN  NUMBER,
84             p_line_rec                   IN  OE_ORDER_PUB.line_rec_type,
85 x_return_status OUT NOCOPY VARCHAR2);
86 
87 
88 PROCEDURE WSH_ITM_ONT(
89             p_request_control_id         IN   NUMBER    default null,
90             p_request_set_id             IN   NUMBER    default null,
91             p_status_code                IN   VARCHAR2  default null);
92 
93 END ONT_ITM_PKG;