9:
10: PROCEDURE Qualifier_Rules
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
14: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: , x_old_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
17: )
10: PROCEDURE Qualifier_Rules
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
14: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: , x_old_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
17: )
18: IS
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
14: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: , x_old_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
14: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
16: , x_old_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
22: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
23: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
24: BEGIN
25:
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
22: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
23: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
24: BEGIN
25:
26: oe_debug_pub.add('entering qualifier rules' );
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
22: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
23: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
24: BEGIN
25:
26: oe_debug_pub.add('entering qualifier rules' );
27: oe_debug_pub.add('operation is '||nvl(l_QUALIFIER_RULES_rec.operation,'null') );
331:
332: PROCEDURE Qualifierss
333: ( p_validation_level IN NUMBER
334: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
335: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
336: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
337: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
338: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
339: )
332: PROCEDURE Qualifierss
333: ( p_validation_level IN NUMBER
334: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
335: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
336: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
337: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
338: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
339: )
340: IS
333: ( p_validation_level IN NUMBER
334: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
335: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
336: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
337: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
338: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
339: )
340: IS
341: l_return_status VARCHAR2(1);
334: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
335: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
336: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
337: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
338: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
339: )
340: IS
341: l_return_status VARCHAR2(1);
342: l_control_rec QP_GLOBALS.Control_Rec_Type;
339: )
340: IS
341: l_return_status VARCHAR2(1);
342: l_control_rec QP_GLOBALS.Control_Rec_Type;
343: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
344: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
345: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
346: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
347: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
340: IS
341: l_return_status VARCHAR2(1);
342: l_control_rec QP_GLOBALS.Control_Rec_Type;
343: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
344: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
345: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
346: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
347: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
348: BEGIN
341: l_return_status VARCHAR2(1);
342: l_control_rec QP_GLOBALS.Control_Rec_Type;
343: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
344: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
345: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
346: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
347: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
348: BEGIN
349:
342: l_control_rec QP_GLOBALS.Control_Rec_Type;
343: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
344: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
345: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
346: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
347: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
348: BEGIN
349:
350: -- Init local table variables.
343: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
344: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
345: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
346: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
347: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
348: BEGIN
349:
350: -- Init local table variables.
351:
371:
372: IF l_old_QUALIFIERS_tbl.EXISTS(I) THEN
373: l_old_QUALIFIERS_rec := l_old_QUALIFIERS_tbl(I);
374: ELSE
375: l_old_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;
376: END IF;
377:
378: -- Load API control record
379:
770: QP_GLOBALS.G_MISS_CONTROL_REC
771: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
772: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
773: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
774: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
771: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
772: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
773: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
774: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
772: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
773: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
774: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
773: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
774: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
774: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
775: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
783: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
776: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
783: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
784: )
777: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
783: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
784: )
785: IS
778: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
783: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
784: )
785: IS
786: l_api_version_number CONSTANT NUMBER := 1.0;
779: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
780: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
781: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
782: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
783: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
784: )
785: IS
786: l_api_version_number CONSTANT NUMBER := 1.0;
787: l_api_name CONSTANT VARCHAR2(30):= 'Process_Qualifier_Rules';
786: l_api_version_number CONSTANT NUMBER := 1.0;
787: l_api_name CONSTANT VARCHAR2(30):= 'Process_Qualifier_Rules';
788: l_return_status VARCHAR2(1);
789: l_control_rec QP_GLOBALS.Control_Rec_Type;
790: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
787: l_api_name CONSTANT VARCHAR2(30):= 'Process_Qualifier_Rules';
788: l_return_status VARCHAR2(1);
789: l_control_rec QP_GLOBALS.Control_Rec_Type;
790: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
788: l_return_status VARCHAR2(1);
789: l_control_rec QP_GLOBALS.Control_Rec_Type;
790: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
789: l_control_rec QP_GLOBALS.Control_Rec_Type;
790: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
790: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
791: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
799: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
792: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
799: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
800:
793: l_p_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
799: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
800:
801: -- Blanket Agreement
794: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
799: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
800:
801: -- Blanket Agreement
802: l_list_header_id NUMBER;
795: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
796: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
797: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
798: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
799: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
800:
801: -- Blanket Agreement
802: l_list_header_id NUMBER;
803: qual_count NUMBER;
1140: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1141: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1142: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1143: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1144: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1141: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1142: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1143: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1144: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1149: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1142: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1143: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1144: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1149: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1150: )
1143: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1144: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1149: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1150: )
1151: IS
1144: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1149: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1150: )
1151: IS
1152: l_api_version_number CONSTANT NUMBER := 1.0;
1145: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
1146: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
1147: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
1148: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1149: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1150: )
1151: IS
1152: l_api_version_number CONSTANT NUMBER := 1.0;
1153: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Qualifier_Rules';
1151: IS
1152: l_api_version_number CONSTANT NUMBER := 1.0;
1153: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Qualifier_Rules';
1154: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1155: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1156: BEGIN
1157:
1158: -- Standard call to check for call compatibility
1159:
1311: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1312: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1313: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1314: , p_qualifier_rule_id IN NUMBER
1315: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1316: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1317: )
1318: IS
1319: l_api_version_number CONSTANT NUMBER := 1.0;
1312: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1313: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1314: , p_qualifier_rule_id IN NUMBER
1315: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
1316: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1317: )
1318: IS
1319: l_api_version_number CONSTANT NUMBER := 1.0;
1320: l_api_name CONSTANT VARCHAR2(30):= 'Get_Qualifier_Rules';
1317: )
1318: IS
1319: l_api_version_number CONSTANT NUMBER := 1.0;
1320: l_api_name CONSTANT VARCHAR2(30):= 'Get_Qualifier_Rules';
1321: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1322: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1323: BEGIN
1324:
1325: -- Standard call to check for call compatibility
1318: IS
1319: l_api_version_number CONSTANT NUMBER := 1.0;
1320: l_api_name CONSTANT VARCHAR2(30):= 'Get_Qualifier_Rules';
1321: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1322: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1323: BEGIN
1324:
1325: -- Standard call to check for call compatibility
1326:
1447: , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
1448: ) IS
1449:
1450:
1451: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1452: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1453: l_x_Qualifier_rule_id NUMBER;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1448: ) IS
1449:
1450:
1451: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1452: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1453: l_x_Qualifier_rule_id NUMBER;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1451: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1452: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1453: l_x_Qualifier_rule_id NUMBER;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1457: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1458: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1459: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1452: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1453: l_x_Qualifier_rule_id NUMBER;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1457: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1458: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1459: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1460: l_control_rec QP_GLOBALS.Control_Rec_Type;
1453: l_x_Qualifier_rule_id NUMBER;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1457: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1458: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1459: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1460: l_control_rec QP_GLOBALS.Control_Rec_Type;
1461: l_api_version_number CONSTANT NUMBER := 1.0;
1454:
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1457: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1458: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1459: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1460: l_control_rec QP_GLOBALS.Control_Rec_Type;
1461: l_api_version_number CONSTANT NUMBER := 1.0;
1462: l_api_name CONSTANT VARCHAR2(30):= 'Copy_Qualifier_Rule';
1455: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1456: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1457: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1458: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1459: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1460: l_control_rec QP_GLOBALS.Control_Rec_Type;
1461: l_api_version_number CONSTANT NUMBER := 1.0;
1462: l_api_name CONSTANT VARCHAR2(30):= 'Copy_Qualifier_Rule';
1463: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1617: )
1618: IS
1619: /* For creating qualifiers */
1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1618: IS
1619: /* For creating qualifiers */
1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1619: /* For creating qualifiers */
1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1620: l_price_list_type_code QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE;
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1628:
1621: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1622: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1623: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1624: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1628:
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1625: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1628:
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1630: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1631: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1632: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1633: l_x_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1626:
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1628:
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1630: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1631: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1632: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1633: l_x_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1634: l_return_status VARCHAR2(1);
1627: l_control_rec QP_GLOBALS.Control_Rec_Type;
1628:
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1630: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1631: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1632: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1633: l_x_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1634: l_return_status VARCHAR2(1);
1635: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
1628:
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1630: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1631: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1632: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1633: l_x_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1634: l_return_status VARCHAR2(1);
1635: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
1636: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1629: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type ;
1630: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1631: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type ;
1632: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type ;
1633: l_x_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1634: l_return_status VARCHAR2(1);
1635: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
1636: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1637: l_msg_count NUMBER;