DBA Data[Home] [Help]

APPS.IEX_STATUS_RULE_PUB dependencies on IEX_STATUS_RULE_PUB

Line 1: PACKAGE BODY IEX_STATUS_RULE_PUB AS

1: PACKAGE BODY IEX_STATUS_RULE_PUB AS
2: /* $Header: iexpcstb.pls 120.1 2006/05/30 17:25:42 scherkas noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STATUS_RULE_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STATUS_RULE_PUB';

1: PACKAGE BODY IEX_STATUS_RULE_PUB AS
2: /* $Header: iexpcstb.pls 120.1 2006/05/30 17:25:42 scherkas noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STATUS_RULE_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpcstb.pls';
7:
8:
9: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line 15: p_status_rule_rec IN iex_status_rule_pub.status_rule_rec_type,

11: Procedure Create_Status_Rule
12: (p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2,
14: p_commit IN VARCHAR2,
15: p_status_rule_rec IN iex_status_rule_pub.status_rule_rec_type,
16: x_dup_status OUT NOCOPY VARCHAR2,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,

Line 166: p_status_rule_tbl IN iex_status_rule_pub.status_rule_tbl_type,

162: Procedure Update_Status_Rule
163: (p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2,
165: p_commit IN VARCHAR2,
166: p_status_rule_tbl IN iex_status_rule_pub.status_rule_tbl_type,
167: x_dup_status OUT NOCOPY VARCHAR2,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2)

Line 177: l_status_rule_rec iex_status_rule_pub.status_rule_rec_type;

173: l_api_version_number CONSTANT NUMBER := 1.0;
174: l_return_status VARCHAR2(1);
175: l_msg_count NUMBER;
176: l_msg_data VARCHAR2(32767);
177: l_status_rule_rec iex_status_rule_pub.status_rule_rec_type;
178:
179: BEGIN
180:
181: -- Standard Start of API savepoint

Line 319: p_status_rule_id_tbl IN iex_status_rule_pub.status_rule_id_TBL_type,

315: Procedure Delete_Status_Rule
316: (p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2,
318: p_commit IN VARCHAR2,
319: p_status_rule_id_tbl IN iex_status_rule_pub.status_rule_id_TBL_type,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2)
323:

Line 467: p_status_rule_line_rec IN iex_status_rule_pub.status_rule_line_rec_type,

463: Procedure Create_Status_Rule_Line
464: ( p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2,
466: p_commit IN VARCHAR2,
467: p_status_rule_line_rec IN iex_status_rule_pub.status_rule_line_rec_type,
468: x_return_status OUT NOCOPY VARCHAR2,
469: x_msg_count OUT NOCOPY NUMBER,
470: x_msg_data OUT NOCOPY VARCHAR2)
471:

Line 478: l_status_rule_line_rec iex_status_rule_pub.status_rule_line_rec_type;

474: l_api_version_number CONSTANT NUMBER := 1.0;
475: l_return_status VARCHAR2(1);
476: l_msg_count NUMBER;
477: l_msg_data VARCHAR2(32767);
478: l_status_rule_line_rec iex_status_rule_pub.status_rule_line_rec_type;
479: x_status_rule_line_id NUMBER;
480:
481:
482: BEGIN

Line 588: p_status_rule_line_TBL IN iex_status_rule_pub.status_rule_line_tbl_type,

584: Procedure Update_Status_Rule_Line
585: ( p_api_version IN NUMBER,
586: p_init_msg_list IN VARCHAR2,
587: p_commit IN VARCHAR2,
588: p_status_rule_line_TBL IN iex_status_rule_pub.status_rule_line_tbl_type,
589: x_dup_status OUT NOCOPY VARCHAR2,
590: x_return_status OUT NOCOPY VARCHAR2,
591: x_msg_count OUT NOCOPY NUMBER,
592: x_msg_data OUT NOCOPY VARCHAR2)

Line 600: l_status_rule_line_REC iex_status_rule_pub.status_rule_line_rec_type;

596: l_api_version_number CONSTANT NUMBER := 1.0;
597: l_return_status VARCHAR2(1);
598: l_msg_count NUMBER;
599: l_msg_data VARCHAR2(32767);
600: l_status_rule_line_REC iex_status_rule_pub.status_rule_line_rec_type;
601:
602: BEGIN
603:
604: -- Standard Start of API savepoint

Line 710: p_status_rule_line_ID_TBL IN iex_status_rule_pub.status_rule_line_ID_TBL_type,

706: ( p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2,
708: p_commit IN VARCHAR2,
709: p_status_rule_id IN NUMBER,
710: p_status_rule_line_ID_TBL IN iex_status_rule_pub.status_rule_line_ID_TBL_type,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2)
714:

Line 822: END IEX_STATUS_RULE_PUB;

818: );
819:
820: END Delete_Status_Rule_Line;
821:
822: END IEX_STATUS_RULE_PUB;