[Home] [Help]
PACKAGE: APPS.IEX_OPEN_INTERFACE_PUB
Source
1 PACKAGE iex_open_interface_pub AUTHID CURRENT_USER AS
2 /* $Header: IEXPOPIS.pls 120.3 2004/12/16 15:20:56 jsanju ship $ */
3
4 subtype iohv_rec_type is iex_ioh_pvt.iohv_rec_type;
5 subtype oinv_rec_type is okl_open_int_pub.oinv_rec_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_OPEN_INTERFACE_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := 'IEX';
12
13 ---------------------------------------------------------------------------
14 -- GLOBAL EXCEPTION
15 ---------------------------------------------------------------------------
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17 ---------------------------------------------------------------------------
18
19 PROCEDURE report_all_credit_bureau(
20 errbuf OUT NOCOPY VARCHAR2,
21 retcode OUT NOCOPY NUMBER);
22
23 PROCEDURE insert_pending(
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 p_object1_id1 IN VARCHAR2,
27 p_object1_id2 IN VARCHAR2,
28 p_jtot_object1_code IN VARCHAR2,
29 p_action IN VARCHAR2,
30 p_status IN VARCHAR2,
31 p_comments IN VARCHAR2,
32 p_ext_agncy_id IN NUMBER,
33 p_review_date IN DATE,
34 p_recall_date IN DATE,
35 p_automatic_recall_flag IN VARCHAR2,
36 p_review_before_recall_flag IN VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40
41 PROCEDURE process_pending(
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER,
44 p_jtot_object1_code IN VARCHAR2,
45 p_case_number IN VARCHAR2);
46
47 PROCEDURE complete_report_cb(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 ,
50 p_interface_id IN NUMBER,
51 p_report_date IN DATE,
52 p_comments IN VARCHAR2 ,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 PROCEDURE complete_transfer(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 ,
60 p_interface_id IN NUMBER,
61 p_transfer_date IN DATE,
62 p_comments IN VARCHAR2 ,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 PROCEDURE recall_transfer(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
70 p_interface_id IN NUMBER,
71 p_recall_date IN DATE,
72 p_comments IN VARCHAR2 DEFAULT NULL,
73 p_ext_agncy_id IN NUMBER DEFAULT NULL,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77
78 PROCEDURE review_transfer(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 ,
81 p_oinv_rec IN oinv_rec_type,
82 p_iohv_rec IN iohv_rec_type,
83 x_oinv_rec OUT NOCOPY oinv_rec_type,
84 x_iohv_rec OUT NOCOPY iohv_rec_type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89 PROCEDURE notify_customer(
90 errbuf OUT NOCOPY VARCHAR2,
91 retcode OUT NOCOPY NUMBER,
92 p_jtot_object1_code IN VARCHAR2,
93 p_case_number IN VARCHAR2,
94 p_party_id IN NUMBER,
95 p_agent_id IN NUMBER,
96 p_content_id IN VARCHAR2,
97 p_from IN VARCHAR2,
98 p_subject IN VARCHAR2,
99 p_email IN VARCHAR2);
100
101 PROCEDURE notify_recall_external_agency(
102 errbuf OUT NOCOPY VARCHAR2,
103 retcode OUT NOCOPY NUMBER,
104 p_jtot_object1_code IN VARCHAR2,
105 p_case_number IN VARCHAR2,
106 p_ext_agncy_id IN NUMBER,
107 p_comments IN VARCHAR2);
108
109 PROCEDURE notify_external_agency(
110 errbuf OUT NOCOPY VARCHAR2,
111 retcode OUT NOCOPY NUMBER,
112 p_jtot_object1_code IN VARCHAR2,
113 p_case_number IN VARCHAR2,
114 p_ext_agncy_id IN NUMBER,
115 p_agent_id IN NUMBER,
116 p_content_id IN VARCHAR2,
117 p_from IN VARCHAR2,
118 p_subject IN VARCHAR2,
119 p_email IN VARCHAR2);
120
121 PROCEDURE recall_from_external_agency(
122 errbuf OUT NOCOPY VARCHAR2,
123 retcode OUT NOCOPY NUMBER,
124 p_jtot_object1_code IN VARCHAR2,
125 p_case_number IN VARCHAR2,
126 p_ext_agncy_id IN NUMBER,
127 p_comments IN VARCHAR2);
128
129 END iex_open_interface_pub;