[Home] [Help]
PACKAGE: APPS.IEX_PROMISES_BATCH_PUB
Source
1 PACKAGE IEX_PROMISES_BATCH_PUB AUTHID CURRENT_USER as
2 /* $Header: iexpyrbs.pls 120.1.12000000.2 2007/07/11 06:50:43 gnramasa ship $ */
3
4 TYPE REVERSE_APPL_REC IS RECORD(
5 PROMISE_DETAIL_ID NUMBER,
6 PROMISE_DATE DATE,
7 STATUS VARCHAR2(30),
8 PROMISE_AMOUNT NUMBER,
9 AMOUNT_DUE_REMAINING NUMBER,
10 AMOUNT_APPLIED NUMBER,
11 receivable_application_id NUMBER);
12
13 TYPE REVERSE_APPLS_TBL IS TABLE OF REVERSE_APPL_REC INDEX BY BINARY_INTEGER;
14
15 TYPE PROMISE_REC IS RECORD(
16 PROMISE_DETAIL_ID NUMBER,
17 CREATION_DATE DATE,
18 PROMISE_DATE DATE,
19 STATUS VARCHAR2(30),
20 STATE VARCHAR2(30),
21 PROMISE_AMOUNT NUMBER,
22 AMOUNT_DUE_REMAINING NUMBER,
23 DELINQUENCY_ID NUMBER,
24 CONTRACT_ID NUMBER,
25 PAYMENT_SCHEDULE_ID NUMBER,
26 CUST_ACCOUNT_ID NUMBER);
27
28 TYPE PROMISES_TBL IS TABLE OF PROMISE_REC INDEX BY BINARY_INTEGER;
29
30 TYPE APPL_REC IS RECORD(
31 receivable_application_id NUMBER,
32 ar_applied_amount NUMBER,
33 ar_remaining_amount NUMBER,
34 ar_apply_date DATE,
35 -- start bug 3635087 gnramasa 10/07/07
36 adjustment_id NUMBER,
37 ar_adjusted_amount NUMBER,
38 ar_adj_remaining_amount NUMBER,
39 ar_adjusted_date DATE,
40 -- End bug 3635087 gnramasa 10/07/07
41 pro_applied_amount NUMBER);
42
43 TYPE APPLS_TBL IS TABLE OF APPL_REC INDEX BY BINARY_INTEGER;
44
45 PROCEDURE IEX_PROMISES_CONCUR(
46 ERRBUF OUT NOCOPY VARCHAR2,
47 RETCODE OUT NOCOPY VARCHAR2,
48 P_ORG_ID IN NUMBER DEFAULT NULL); --Added for MOAC
49
50 PROCEDURE CLOSE_PROMISES(
51 P_API_VERSION IN NUMBER,
52 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2,
58 p_payments_tbl IN IEX_PAYMENTS_BATCH_PUB.CL_INV_TBL_TYPE);
59
60 PROCEDURE CLOSE_PROMISES(
61 P_API_VERSION IN NUMBER,
62 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2,
68 P_DELINQ_TBL IN IEX_UTILITIES.t_del_id);
69
70 PROCEDURE PROCESS_ALL_PROMISES(
71 P_API_VERSION IN NUMBER,
72 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76 X_MSG_COUNT OUT NOCOPY NUMBER,
77 X_MSG_DATA OUT NOCOPY VARCHAR2);
78
79 PROCEDURE PROCESS_REVERSALS(
80 P_API_VERSION IN NUMBER,
81 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
84 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2,
87 P_TYPE IN VARCHAR2);
88
89 PROCEDURE PROCESS_PROMISES(
90 P_API_VERSION IN NUMBER,
91 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95 X_MSG_COUNT OUT NOCOPY NUMBER,
96 X_MSG_DATA OUT NOCOPY VARCHAR2,
97 P_TYPE IN VARCHAR2);
98
99 PROCEDURE APPLY_PROMISES_FIFO(
100 P_API_VERSION IN NUMBER,
101 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
102 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
104 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105 X_MSG_COUNT OUT NOCOPY NUMBER,
106 X_MSG_DATA OUT NOCOPY VARCHAR2,
107 P_PROMISES_TBL IN OUT NOCOPY IEX_PROMISES_BATCH_PUB.PROMISES_TBL,
108 P_TYPE IN VARCHAR2);
109
110 PROCEDURE PROCESS_PROMISE_CALLBACKS(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2);
118
119 PROCEDURE REOPEN_PROMISES(
120 P_API_VERSION IN NUMBER,
121 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
124 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
125 X_MSG_COUNT OUT NOCOPY NUMBER,
126 X_MSG_DATA OUT NOCOPY VARCHAR2,
127 p_dels_tbl IN DBMS_SQL.NUMBER_TABLE /*table of delinquency ids*/);
128
129 END;