eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QUALIFIER_RULES_PVT dependencies on QP_GLOBALS

Line 12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

8: -- Qualifier_Rules
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

Line 20: l_control_rec QP_GLOBALS.Control_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;
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

Line 31: l_control_rec := QP_GLOBALS.Init_Control_Rec

27: oe_debug_pub.add('operation is '||nvl(l_QUALIFIER_RULES_rec.operation,'null') );
28:
29: -- Load API control record
30:
31: l_control_rec := QP_GLOBALS.Init_Control_Rec
32: ( p_operation => l_QUALIFIER_RULES_rec.operation
33: , p_control_rec => p_control_rec
34: );
35:

Line 44: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

40: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: -- Prepare record.
43:
44: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
45:
46: l_QUALIFIER_RULES_rec.db_flag := FND_API.G_FALSE;
47:
48: -- Set missing old record elements to NULL.

Line 55: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE

51:
52: l_old_QUALIFIER_RULES_rec :=
53: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);
54:
55: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
56: OR l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE
57: THEN
58:
59: l_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;

Line 56: OR l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE

52: l_old_QUALIFIER_RULES_rec :=
53: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);
54:
55: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
56: OR l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE
57: THEN
58:
59: l_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;
60:

Line 94: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE OR

90: -- added on 30-nov-99 by svdeshmu to avoid generation of sequence
91: -- number for qualifier rule id when lines are added for existing
92: --qualifier rule
93:
94: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE OR
95: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE OR
96: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
97:
98: IF l_control_rec.default_attributes

Line 95: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE OR

91: -- number for qualifier rule id when lines are added for existing
92: --qualifier rule
93:
94: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE OR
95: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE OR
96: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
97:
98: IF l_control_rec.default_attributes
99: OR l_control_rec.change_attributes

Line 96: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

92: --qualifier rule
93:
94: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE OR
95: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE OR
96: l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
97:
98: IF l_control_rec.default_attributes
99: OR l_control_rec.change_attributes
100: THEN

Line 192: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

188: -- Entity level validation.
189:
190: IF l_control_rec.validate_entity THEN
191:
192: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
193:
194: QP_Validate_Qualifier_Rules.Entity_Delete
195: ( x_return_status => l_return_status
196: , p_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec

Line 223: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

219: -- Step 4. Write to DB
220:
221: IF l_control_rec.write_to_db THEN
222:
223: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
224:
225: QP_Qualifier_Rules_Util.Delete_Row
226: ( p_qualifier_rule_id => l_QUALIFIER_RULES_rec.qualifier_rule_id
227: );

Line 237: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

233: l_QUALIFIER_RULES_rec.last_update_date := SYSDATE;
234: l_QUALIFIER_RULES_rec.last_updated_by := FND_GLOBAL.USER_ID;
235: l_QUALIFIER_RULES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
236:
237: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
238:
239: QP_Qualifier_Rules_Util.Update_Row (l_QUALIFIER_RULES_rec);
240:
241: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 241: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

237: IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
238:
239: QP_Qualifier_Rules_Util.Update_Row (l_QUALIFIER_RULES_rec);
240:
241: ELSIF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
242:
243: l_QUALIFIER_RULES_rec.creation_date := SYSDATE;
244: l_QUALIFIER_RULES_rec.created_by := FND_GLOBAL.USER_ID;
245:

Line 278: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,

274: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
275: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
276: if l_control_rec.called_from_ui = 'N' then
277: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
278: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
279: p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
280: x_return_status => l_return_status);
281: end if;
282:

Line 296: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,

292: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
293: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
294: if l_control_rec.called_from_ui = 'N' then
295: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
296: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
297: p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
298: x_return_status => l_return_status);
299: end if;
300:

Line 321: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,

317: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
318: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
319: if l_control_rec.called_from_ui = 'N' then
320: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
321: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
322: p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
323: x_return_status => l_return_status);
324: end if;
325:

Line 334: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

330: -- Qualifierss
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

Line 342: l_control_rec QP_GLOBALS.Control_Rec_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;
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;

Line 388: l_control_rec := QP_GLOBALS.Init_Control_Rec

384: --dbms_output.put_line('operation is '|| l_QUALIFIERS_rec.operation);
385:
386:
387:
388: l_control_rec := QP_GLOBALS.Init_Control_Rec
389: ( p_operation => l_QUALIFIERS_rec.operation
390: , p_control_rec => p_control_rec
391: );
392:

Line 399: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

395: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: -- Prepare record.
398:
399: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
400:
401: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
402:
403: -- Set missing old record elements to NULL.

Line 415: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

411:
412: l_old_QUALIFIERS_rec :=
413: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
414:
415: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
416: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
417: THEN
418:
419: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

Line 416: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

412: l_old_QUALIFIERS_rec :=
413: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
414:
415: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
416: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
417: THEN
418:
419: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
420:

Line 537: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

533: IF l_control_rec.validate_entity THEN
534:
535: oe_debug_pub.add('checking entity validation condition ');
536: oe_debug_pub.add('operation is '|| l_QUALIFIERS_rec.operation);
537: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
538:
539: QP_Validate_Qualifiers.Entity_Delete
540: ( x_return_status => l_return_status
541: , p_QUALIFIERS_rec => l_QUALIFIERS_rec

Line 582: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

578: -- Step 4. Write to DB
579:
580: IF l_control_rec.write_to_db THEN
581:
582: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
583:
584: QP_Qualifiers_Util.Delete_Row
585: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
586: );

Line 596: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

592: l_QUALIFIERS_rec.last_update_date := SYSDATE;
593: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
597:
598: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
599:
600: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 600: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

596: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
597:
598: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
599:
600: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
601:
602: l_QUALIFIERS_rec.creation_date := SYSDATE;
603: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
604:

Line 637: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

633: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
634: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
635: if l_control_rec.called_from_ui = 'N' then
636: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
637: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
638: p_entity_id => l_QUALIFIERS_rec.list_header_id,
639: x_return_status => l_return_status);
640:
641: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 642: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

638: p_entity_id => l_QUALIFIERS_rec.list_header_id,
639: x_return_status => l_return_status);
640:
641: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
642: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
643: p_entity_id => l_QUALIFIERS_rec.list_line_id,
644: x_return_status => l_return_status);
645:
646: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 647: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

643: p_entity_id => l_QUALIFIERS_rec.list_line_id,
644: x_return_status => l_return_status);
645:
646: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
647: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
648: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
649: x_return_status => l_return_status);
650: end if;
651:

Line 662: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

658: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
659: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
660: if l_control_rec.called_from_ui = 'N' then
661: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
662: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
663: p_entity_id => l_QUALIFIERS_rec.list_header_id,
664: x_return_status => l_return_status);
665:
666: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 667: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

663: p_entity_id => l_QUALIFIERS_rec.list_header_id,
664: x_return_status => l_return_status);
665:
666: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
667: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
668: p_entity_id => l_QUALIFIERS_rec.list_line_id,
669: x_return_status => l_return_status);
670:
671: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 672: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

668: p_entity_id => l_QUALIFIERS_rec.list_line_id,
669: x_return_status => l_return_status);
670:
671: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
672: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
673: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
674: x_return_status => l_return_status);
675: end if;
676:

Line 697: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

693: -- mkarya If process_qualifier_rules has been called from public package, then ONLY
694: -- call qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
695: if l_control_rec.called_from_ui = 'N' then
696: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
697: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
698: p_entity_id => l_QUALIFIERS_rec.list_header_id,
699: x_return_status => l_return_status);
700:
701: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 702: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

698: p_entity_id => l_QUALIFIERS_rec.list_header_id,
699: x_return_status => l_return_status);
700:
701: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
702: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
703: p_entity_id => l_QUALIFIERS_rec.list_line_id,
704: x_return_status => l_return_status);
705:
706: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 707: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

703: p_entity_id => l_QUALIFIERS_rec.list_line_id,
704: x_return_status => l_return_status);
705:
706: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
707: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
708: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
709: x_return_status => l_return_status);
710: end if;
711:

Line 769: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

765: ( p_api_version_number IN NUMBER
766: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
767: , p_commit IN VARCHAR2 := FND_API.G_FALSE
768: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
769: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
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

Line 770: QP_GLOBALS.G_MISS_CONTROL_REC

766: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
767: , p_commit IN VARCHAR2 := FND_API.G_FALSE
768: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
769: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
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 :=

Line 789: l_control_rec QP_GLOBALS.Control_Rec_Type;

785: IS
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;

Line 856: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

852:
853: -- Perform QUALIFIER_RULES group requests.
854:
855: IF p_control_rec.process AND
856: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
857: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIER_RULES)
858: THEN
859:
860: NULL;

Line 857: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIER_RULES)

853: -- Perform QUALIFIER_RULES group requests.
854:
855: IF p_control_rec.process AND
856: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
857: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIER_RULES)
858: THEN
859:
860: NULL;
861:

Line 878: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);
875:
876:
877:
878: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
879: AND (l_QUALIFIERS_rec.qualifier_rule_id IS NULL OR
880: l_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM)
881: THEN
882:

Line 890: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND

886: END IF;
887:
888: -- Blanket Agreement
889:
890: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
891: l_QUALIFIERS_rec.qualifier_context = 'ORDER' AND
892: l_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
893: THEN
894: qual_count := 1;

Line 956: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

952: -- Perform QUALIFIERS group requests.
953: oe_debug_pub.add('before if delayed req for warn_same_qual_group');
954:
955: IF p_control_rec.process AND
956: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
957: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
958: THEN
959:
960: oe_debug_pub.add('before delayed req for warn_same_qual_group');

Line 957: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

953: oe_debug_pub.add('before if delayed req for warn_same_qual_group');
954:
955: IF p_control_rec.process AND
956: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
957: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
958: THEN
959:
960: oe_debug_pub.add('before delayed req for warn_same_qual_group');
961:

Line 967: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS

963: --warning message to be shown
964: --when a < 1 qualifier is created in same group with same
965: --context and attribute from a pricelist or modifier
966: QP_DELAYED_REQUESTS_PVT.Process_Request_for_entity
967: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
968: ,p_delete => FND_API.G_TRUE
969: ,x_return_status => l_return_status
970: );
971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 986: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

982: oe_debug_pub.add('before if delayed req for list_qual_ind'||p_control_rec.process_entity);
983: -- Step 6. Perform Object group logic
984:
985: IF p_control_rec.process AND
986: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
987: THEN
988:
989: oe_debug_pub.add('before delayed req for list_qual_ind');
990: --code modified by spgopal for bug 1543456

Line 1182: IF p_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

1178: SAVEPOINT Lock_Qualifier_Rules_PVT;
1179:
1180: -- Lock QUALIFIER_RULES
1181:
1182: IF p_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
1183:
1184: QP_Qualifier_Rules_Util.Lock_Row
1185: ( p_QUALIFIER_RULES_rec => p_QUALIFIER_RULES_rec
1186: , x_QUALIFIER_RULES_rec => x_QUALIFIER_RULES_rec

Line 1203: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

1199: -- Lock QUALIFIERS
1200:
1201: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
1202:
1203: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
1204:
1205: QP_Qualifiers_Util.Lock_Row
1206: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
1207: , x_QUALIFIERS_rec => l_QUALIFIERS_rec

Line 1460: l_control_rec QP_GLOBALS.Control_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;
1464:

Line 1505: l_QUALIFIER_RULES_rec.operation:=QP_GLOBALS.G_OPR_CREATE;

1501: --description
1502:
1503:
1504:
1505: l_QUALIFIER_RULES_rec.operation:=QP_GLOBALS.G_OPR_CREATE;
1506: l_QUALIFIER_RULES_rec.name:= p_to_qualifier_rule;
1507: l_QUALIFIER_RULES_rec.description:= p_to_description;
1508:
1509:

Line 1521: l_QUALIFIERS_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

1517: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(i);
1518:
1519: --dbms_output.put_line('id :' ||l_QUALIFIERS_rec.qualifier_id);
1520: --dbms_output.put_line('rule id :' ||l_QUALIFIERS_rec.qualifier_rule_id);
1521: l_QUALIFIERS_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1522: l_QUALIFIERS_tbl(i).qualifier_id :=FND_API.G_MISS_NUM;
1523: l_QUALIFIERS_tbl(i).qualifier_rule_id :=FND_API.G_MISS_NUM;
1524:
1525: END LOOP;

Line 1627: l_control_rec QP_GLOBALS.Control_Rec_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 ;
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 ;

Line 1649: if p_operation = QP_GLOBALS.G_OPR_CREATE then

1645:
1646: IF p_list_header_id IS NOT NULL OR
1647: p_list_header_id <> FND_API.G_MISS_NUM THEN
1648:
1649: if p_operation = QP_GLOBALS.G_OPR_CREATE then
1650:
1651: oe_debug_pub.add('in if create : '||p_operation);
1652:
1653: l_qualifiers_rec.list_header_id := p_list_header_id;

Line 1659: l_qualifiers_rec.operation := QP_GLOBALS.G_OPR_CREATE;

1655: l_qualifiers_rec.qualifier_context := 'ORDER';
1656: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
1657: l_qualifiers_rec.qualifier_grouping_no := p_blanket_id;
1658:
1659: l_qualifiers_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1660: l_qualifiers_tbl(1) := l_qualifiers_rec;
1661:
1662: l_control_rec.called_from_ui := 'Y';
1663:

Line 1718: l_qualifiers_rec.operation := QP_GLOBALS.G_OPR_CREATE;

1714: l_qualifiers_rec.qualifier_context := 'ORDER';
1715: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
1716: l_qualifiers_rec.qualifier_grouping_no := p_blanket_id;
1717:
1718: l_qualifiers_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1719: l_qualifiers_tbl(1) := l_qualifiers_rec;
1720:
1721: else
1722: oe_debug_pub.add('in else count'||to_char(l_qual_count));