DBA Data[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;