DBA Data[Home] [Help]

APPS.IEX_STATUS_RULE_PVT dependencies on IEX_STATUS_RULE_PUB

Line 13: P_Status_Rule_rec IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,

9:
10: PG_DEBUG NUMBER(2);
11:
12: Procedure Validate_Status_Rule(P_Init_Msg_List IN VARCHAR2,
13: P_Status_Rule_rec IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
14: X_Dup_Status OUT NOCOPY VARCHAR2,
15: X_Return_Status OUT NOCOPY VARCHAR2,
16: X_Msg_Count OUT NOCOPY NUMBER,
17: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 19: l_status_rule_rec IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;

15: X_Return_Status OUT NOCOPY VARCHAR2,
16: X_Msg_Count OUT NOCOPY NUMBER,
17: X_Msg_Data OUT NOCOPY VARCHAR2)
18: IS
19: l_status_rule_rec IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;
20:
21: BEGIN
22: -- Initialize message list IF p_init_msg_list is set to TRUE.
23: IF FND_API.to_Boolean( p_init_msg_list )

Line 179: P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,

175:
176: PROCEDURE Create_Status_Rule(p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: p_commit IN VARCHAR2,
179: P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
180: x_dup_status OUT NOCOPY VARCHAR2,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,

Line 196: l_STATUS_RULE_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;

192: l_return_status VARCHAR2(1);
193: l_msg_count NUMBER;
194: l_msg_data VARCHAR2(32767);
195: l_rowid Varchar2(50);
196: l_STATUS_RULE_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;
197: l_status_rule_id NUMBER ;
198:
199: BEGIN
200:

Line 340: P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,

336:
337: Procedure Update_Status_Rule(p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2,
339: p_commit IN VARCHAR2,
340: P_STATUS_RULE_REC IN IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
341: x_dup_status OUT NOCOPY VARCHAR2,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2)

Line 371: l_STATUS_RULE_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;

367: l_return_status VARCHAR2(1);
368: l_msg_count NUMBER;
369: l_msg_data VARCHAR2(32767);
370: l_rowid Varchar2(50);
371: l_STATUS_RULE_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;
372: l_status_rule_id NUMBER ;
373: l_STATUS_RULE_REF_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE ;
374:
375:

Line 373: l_STATUS_RULE_REF_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE ;

369: l_msg_data VARCHAR2(32767);
370: l_rowid Varchar2(50);
371: l_STATUS_RULE_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;
372: l_status_rule_id NUMBER ;
373: l_STATUS_RULE_REF_REC IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE ;
374:
375:
376: BEGIN
377:

Line 662: p_status_rule_line_REC IN IEX_STATUS_RULE_PUB.status_rule_line_REC_Type,

658:
659: Procedure Create_status_rule_line(p_api_version IN NUMBER,
660: p_init_msg_list IN VARCHAR2,
661: p_commit IN VARCHAR2,
662: p_status_rule_line_REC IN IEX_STATUS_RULE_PUB.status_rule_line_REC_Type,
663: x_return_status OUT NOCOPY VARCHAR2,
664: x_msg_count OUT NOCOPY NUMBER,
665: x_msg_data OUT NOCOPY VARCHAR2,
666: x_status_rule_line_id OUT NOCOPY NUMBER)

Line 680: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_REC;

676: l_return_status VARCHAR2(1);
677: l_msg_count NUMBER;
678: l_msg_data VARCHAR2(32767);
679: l_rowid Varchar2(50);
680: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_REC;
681:
682: BEGIN
683: -- Standard Start of API savepoint
684: SAVEPOINT CREATE_status_rule_line_PVT;

Line 789: p_status_rule_line_Rec IN IEX_STATUS_RULE_PUB.status_rule_line_REC_Type,

785:
786: Procedure Update_status_rule_line(p_api_version IN NUMBER,
787: p_init_msg_list IN VARCHAR2,
788: p_commit IN VARCHAR2,
789: p_status_rule_line_Rec IN IEX_STATUS_RULE_PUB.status_rule_line_REC_Type,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2)
793:

Line 818: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_rec;

814: l_return_status VARCHAR2(1);
815: l_msg_count NUMBER;
816: l_msg_data VARCHAR2(32767);
817: l_rowid Varchar2(50);
818: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_rec;
819: l_status_rule_line_REF_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE ;
820:
821:
822: BEGIN

Line 819: l_status_rule_line_REF_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE ;

815: l_msg_count NUMBER;
816: l_msg_data VARCHAR2(32767);
817: l_rowid Varchar2(50);
818: l_status_rule_line_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE := p_status_rule_line_rec;
819: l_status_rule_line_REF_REC IEX_STATUS_RULE_PUB.status_rule_line_REC_TYPE ;
820:
821:
822: BEGIN
823: