[Home] [Help]
PACKAGE: APPS.IEX_TRX_GRID_PUB
Source
1 PACKAGE IEX_TRX_GRID_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexptrcs.pls 120.1 2010/12/24 09:26:39 snuthala noship $ */
3 /*#
4 * Set UNPAID_REASON_CODE to table IEX_DELINQUENCIES_ALL.
5 * @rep:scope internal
6 * @rep:product IEX
7 * @rep:displayname Set_Unpaid_Reason
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY IEX_DELINQUENCIES_ALL
11 */
12
13 /*#
14 * Set UNPAID_REASON_CODE to table IEX_DELINQUENCIES_ALL.
15 * @param p_api_version API Version Number
16 * @param p_init_msg_list Intialize Message Stack
17 * @param p_commit Commit flag
18 * @param p_validation_level Validation level
19 * @param x_return_status API return status
20 * @param x_msg_count Number of error messages
21 * @param x_msg_data Error message data
22 * @param p_del_ids Delinquency identifier
23 * @param p_unpaid_reason Unpaid_reason_code Possible values should comes from iex_lookups_v with lookup_type 'IEX_UNPAID_REASON'.
24 * @param x_rows_processed Number of rows updated
25 * @rep:scope internal
26 * @rep:displayname Set_Unpaid_Reason
27 * @rep:lifecycle active
28 * @rep:compatibility S
29 */
30
31 PROCEDURE Set_Unpaid_Reason
32 (p_api_version IN NUMBER := 1.0,
33 p_init_msg_list IN VARCHAR2 := 'T',
34 p_commit IN VARCHAR2,
35 p_validation_level IN NUMBER :=100,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_del_ids IN VARCHAR2,
40 p_unpaid_reason IN VARCHAR2,
41 x_rows_processed OUT NOCOPY NUMBER);
42
43 END;