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_MODIFIERS_PVT dependencies on QP_GLOBALS

Line 76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

72: -- Modifier_List
73:
74: PROCEDURE Modifier_List
75: ( p_validation_level IN NUMBER
76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

Line 84: l_control_rec QP_GLOBALS.Control_Rec_Type;

80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
81: )
82: IS
83: l_return_status VARCHAR2(1);
84: l_control_rec QP_GLOBALS.Control_Rec_Type;
85: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
88: BEGIN

Line 95: l_control_rec := QP_GLOBALS.Init_Control_Rec

91: --dbms_output.put_line('BEGIN modifier list in Private');
92:
93: -- Load API control record
94:
95: l_control_rec := QP_GLOBALS.Init_Control_Rec
96: ( p_operation => l_MODIFIER_LIST_rec.operation
97: , p_control_rec => p_control_rec
98: );
99:

Line 105: if l_MODIFIER_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)

101:
102: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --added for moac for BSA --fix for bug 4748511
105: if l_MODIFIER_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)
106: and l_control_rec.called_from_ui = 'N'
107: and l_MODIFIER_LIST_rec.list_source_code IS NOT NULL
108: and l_MODIFIER_LIST_rec.global_flag = 'N'
109: and nvl(QP_SECURITY.security_on, 'N') = 'N' then

Line 118: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

114: -- Prepare record.
115:
116: oe_debug_pub.add('Operation'||l_MODIFIER_LIST_rec.operation);
117: --dbms_output.put_line('Operation'||l_MODIFIER_LIST_rec.operation);
118: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
119:
120: oe_debug_pub.add('Private 01');
121: --dbms_output.put_line('Private 01');
122: l_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;

Line 131: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

127: QP_Modifier_List_Util.Convert_Miss_To_Null (l_old_MODIFIER_LIST_rec);
128:
129: oe_debug_pub.add('Private 02');
130: --dbms_output.put_line('Private 02');
131: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
132: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
133: THEN
134: OE_Debug_Pub.add('update on header');
135: --dbms_output.put_line('update on header');

Line 132: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE

128:
129: oe_debug_pub.add('Private 02');
130: --dbms_output.put_line('Private 02');
131: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
132: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
133: THEN
134: OE_Debug_Pub.add('update on header');
135: --dbms_output.put_line('update on header');
136: l_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;

Line 175: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

171: oe_debug_pub.add('Private 03');
172:
173: --dbms_output.put_line('just before if');
174:
175: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
176: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
177: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
178:
179: oe_debug_pub.add('in Private 03');

Line 176: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

172:
173: --dbms_output.put_line('just before if');
174:
175: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
176: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
177: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
178:
179: oe_debug_pub.add('in Private 03');
180: IF l_control_rec.default_attributes

Line 177: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

173: --dbms_output.put_line('just before if');
174:
175: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
176: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
177: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
178:
179: oe_debug_pub.add('in Private 03');
180: IF l_control_rec.default_attributes
181: OR l_control_rec.change_attributes

Line 260: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

256: -- Entity level validation.
257:
258: IF l_control_rec.validate_entity THEN
259:
260: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
261:
262: QP_Validate_Modifier_List.Entity_Delete
263: ( x_return_status => l_return_status
264: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 293: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

289:
290: oe_debug_pub.add('Private 07');
291: IF l_control_rec.write_to_db THEN
292:
293: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
294:
295: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_MODIFIER');
296: OE_MSG_PUB.Add;
297:

Line 312: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

308: l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
309: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
310: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
311:
312: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
313:
314: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);
315: QP_Modifier_List_Util.Update_Row (l_MODIFIER_LIST_rec);
316:

Line 317: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

313:
314: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);
315: QP_Modifier_List_Util.Update_Row (l_MODIFIER_LIST_rec);
316:
317: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
318:
319: l_MODIFIER_LIST_rec.creation_date := SYSDATE;
320: l_MODIFIER_LIST_rec.created_by := FND_GLOBAL.USER_ID;
321:

Line 353: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

349: -- mkarya If process_modifiers has been called from public package, then ONLY call
350: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
351: if l_control_rec.called_from_ui = 'N' then
352: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
353: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
354: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
355: x_return_status => l_return_status );
356: end if;
357:

Line 370: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

366: -- mkarya If process_modifiers has been called from public package, then ONLY call
367: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
368: if l_control_rec.called_from_ui = 'N' then
369: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
370: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
371: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
372: x_return_status => l_return_status );
373: end if;
374:

Line 395: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

391: -- mkarya If process_modifiers has been called from public package, then ONLY call
392: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
393: if l_control_rec.called_from_ui = 'N' then
394: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
395: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
396: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
397: x_return_status => l_return_status );
398: end if;
399:

Line 408: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

404: -- Modifierss
405:
406: PROCEDURE Modifierss
407: ( p_validation_level IN NUMBER
408: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
409: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
410: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
411: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
412: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

Line 418: l_control_rec QP_GLOBALS.Control_Rec_Type;

414: IS
415: l_return_status VARCHAR2(1);
416: l_rltd_modifiers_s NUMBER;
417: l_to_rltd_modifier_id NUMBER;
418: l_control_rec QP_GLOBALS.Control_Rec_Type;
419: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
420: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
421: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
422: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 452: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

448: or (l_MODIFIERS_rec.rltd_modifier_grp_type = 'BENEFIT'
449: and l_MODIFIERS_rec.list_line_type_code = 'DIS'))) then
450:
451: qp_delayed_requests_pvt.log_request(
452: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
453: p_entity_id => l_MODIFIERS_rec.list_line_id,
454: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
455: p_requesting_entity_id => l_MODIFIERS_rec.list_line_id,
456: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,

Line 454: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

450:
451: qp_delayed_requests_pvt.log_request(
452: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
453: p_entity_id => l_MODIFIERS_rec.list_line_id,
454: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
455: p_requesting_entity_id => l_MODIFIERS_rec.list_line_id,
456: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,
457: p_param1 => l_MODIFIERS_rec.pricing_phase_id,
458: p_param2 => l_MODIFIERS_rec.list_header_id,

Line 456: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,

452: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
453: p_entity_id => l_MODIFIERS_rec.list_line_id,
454: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
455: p_requesting_entity_id => l_MODIFIERS_rec.list_line_id,
456: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,
457: p_param1 => l_MODIFIERS_rec.pricing_phase_id,
458: p_param2 => l_MODIFIERS_rec.list_header_id,
459: x_return_status => l_return_status);
460:

Line 474: l_control_rec := QP_GLOBALS.Init_Control_Rec

470: END IF;
471:
472: -- Load API control record
473:
474: l_control_rec := QP_GLOBALS.Init_Control_Rec
475: ( p_operation => l_MODIFIERS_rec.operation
476: , p_control_rec => p_control_rec
477: );
478:

Line 485: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

481: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: -- Prepare record.
484:
485: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
486:
487: l_MODIFIERS_rec.db_flag := FND_API.G_FALSE;
488:
489: -- Set missing old record elements to NULL.

Line 494: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

490:
491: l_old_MODIFIERS_rec :=
492: QP_Modifiers_Util.Convert_Miss_To_Null (l_old_MODIFIERS_rec);
493:
494: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
495: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
496: THEN
497:
498: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;

Line 495: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

491: l_old_MODIFIERS_rec :=
492: QP_Modifiers_Util.Convert_Miss_To_Null (l_old_MODIFIERS_rec);
493:
494: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
495: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
496: THEN
497:
498: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
499:

Line 529: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

525: END IF;
526:
527: -- Attribute level validation.
528:
529: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
530: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
531: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
532:
533: IF l_control_rec.default_attributes

Line 530: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

526:
527: -- Attribute level validation.
528:
529: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
530: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
531: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
532:
533: IF l_control_rec.default_attributes
534: OR l_control_rec.change_attributes

Line 531: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

527: -- Attribute level validation.
528:
529: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
530: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
531: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
532:
533: IF l_control_rec.default_attributes
534: OR l_control_rec.change_attributes
535: THEN

Line 606: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

602: oe_debug_pub.add('after apply from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
603: --dbms_output.put_line('here 3');
604: IF l_control_rec.validate_entity THEN
605:
606: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
607:
608: QP_Validate_Modifiers.Entity_Delete
609: ( x_return_status => l_return_status
610: , p_MODIFIERS_rec => l_MODIFIERS_rec

Line 686: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

682: --dbms_output.put_line('here 4');
683: oe_debug_pub.add('after step 4 from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
684: IF l_control_rec.write_to_db THEN
685:
686: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
687:
688: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
689: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
690: AND l_MODIFIERS_rec.list_line_type_code <> 'PMR'

Line 707: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

703: );
704:
705: --- Code for delete ends here. Log delayed service request here.
706: qp_delayed_requests_PVT.log_request(
707: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
708: p_param1 => l_modifiers_rec.list_header_id,
709: p_entity_id => l_modifiers_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => l_modifiers_rec.list_line_id,

Line 710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

706: qp_delayed_requests_PVT.log_request(
707: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
708: p_param1 => l_modifiers_rec.list_header_id,
709: p_entity_id => l_modifiers_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => l_modifiers_rec.list_line_id,
712: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
713: x_return_status => l_return_status);
714:

Line 712: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,

708: p_param1 => l_modifiers_rec.list_header_id,
709: p_entity_id => l_modifiers_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => l_modifiers_rec.list_line_id,
712: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
713: x_return_status => l_return_status);
714:
715: END IF;
716:

Line 726: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

722: l_MODIFIERS_rec.last_update_date := SYSDATE;
723: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
724: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
725:
726: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
727:
728: QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);
729:
730: -- julin (3411436): updating qp_rltd_modifiers

Line 770: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

766: , null
767: );
768:
769: qp_delayed_requests_PVT.log_request(
770: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
771: p_entity_id => l_modifiers_rec.list_line_id,
772: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
773: p_requesting_entity_id => l_modifiers_rec.list_line_id,
774: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 772: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

768:
769: qp_delayed_requests_PVT.log_request(
770: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
771: p_entity_id => l_modifiers_rec.list_line_id,
772: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
773: p_requesting_entity_id => l_modifiers_rec.list_line_id,
774: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
775: x_return_status => l_return_status);
776:

Line 774: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

770: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
771: p_entity_id => l_modifiers_rec.list_line_id,
772: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
773: p_requesting_entity_id => l_modifiers_rec.list_line_id,
774: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
775: x_return_status => l_return_status);
776:
777: END IF;
778:

Line 779: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

775: x_return_status => l_return_status);
776:
777: END IF;
778:
779: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
780:
781: l_MODIFIERS_rec.creation_date := SYSDATE;
782: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
783:

Line 882: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

878: , null
879: );
880:
881: qp_delayed_requests_PVT.log_request(
882: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
883: p_entity_id => l_modifiers_rec.list_line_id,
884: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
885: p_requesting_entity_id => l_modifiers_rec.list_line_id,
886: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 884: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

880:
881: qp_delayed_requests_PVT.log_request(
882: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
883: p_entity_id => l_modifiers_rec.list_line_id,
884: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
885: p_requesting_entity_id => l_modifiers_rec.list_line_id,
886: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
887: x_return_status => l_return_status);
888:

Line 886: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

882: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
883: p_entity_id => l_modifiers_rec.list_line_id,
884: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
885: p_requesting_entity_id => l_modifiers_rec.list_line_id,
886: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
887: x_return_status => l_return_status);
888:
889: END IF; -- related lines
890:

Line 895: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

891: END IF; -- G_OPR_CREATE
892: --- Code for update an create ends here. Log delayed servuce request here.
893:
894: qp_delayed_requests_PVT.log_request(
895: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
896: p_entity_id => l_modifiers_rec.list_line_id,
897: p_param1 => l_modifiers_rec.list_header_id,
898: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
899: p_requesting_entity_id => l_modifiers_rec.list_line_id,

Line 898: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

894: qp_delayed_requests_PVT.log_request(
895: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
896: p_entity_id => l_modifiers_rec.list_line_id,
897: p_param1 => l_modifiers_rec.list_header_id,
898: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
899: p_requesting_entity_id => l_modifiers_rec.list_line_id,
900: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
901: x_return_status => l_return_status);
902:

Line 900: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,

896: p_entity_id => l_modifiers_rec.list_line_id,
897: p_param1 => l_modifiers_rec.list_header_id,
898: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
899: p_requesting_entity_id => l_modifiers_rec.list_line_id,
900: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
901: x_return_status => l_return_status);
902:
903: END IF;
904:

Line 929: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

925: -- mkarya If process_modifiers has been called from public package, then ONLY call
926: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
927: if l_control_rec.called_from_ui = 'N' then
928: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
929: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
930: p_entity_id => l_MODIFIERS_rec.list_line_id,
931: x_return_status => l_return_status );
932:
933: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 934: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

930: p_entity_id => l_MODIFIERS_rec.list_line_id,
931: x_return_status => l_return_status );
932:
933: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
934: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
935: p_entity_id => l_MODIFIERS_rec.list_line_id,
936: x_return_status => l_return_status );
937:
938: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 939: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

935: p_entity_id => l_MODIFIERS_rec.list_line_id,
936: x_return_status => l_return_status );
937:
938: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
939: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
940: p_entity_id => l_MODIFIERS_rec.list_header_id,
941: x_return_status => l_return_status );
942:
943: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 944: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

940: p_entity_id => l_MODIFIERS_rec.list_header_id,
941: x_return_status => l_return_status );
942:
943: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
944: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
945: p_entity_id => l_MODIFIERS_rec.list_line_id,
946: x_return_status => l_return_status );
947: end if;
948:

Line 962: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

958: -- mkarya If process_modifiers has been called from public package, then ONLY call
959: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
960: if l_control_rec.called_from_ui = 'N' then
961: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
962: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
963: p_entity_id => l_MODIFIERS_rec.list_line_id,
964: x_return_status => l_return_status );
965:
966: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 967: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

963: p_entity_id => l_MODIFIERS_rec.list_line_id,
964: x_return_status => l_return_status );
965:
966: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
967: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
968: p_entity_id => l_MODIFIERS_rec.list_line_id,
969: x_return_status => l_return_status );
970:
971: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 972: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

968: p_entity_id => l_MODIFIERS_rec.list_line_id,
969: x_return_status => l_return_status );
970:
971: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
972: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
973: p_entity_id => l_MODIFIERS_rec.list_header_id,
974: x_return_status => l_return_status );
975:
976: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 977: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

973: p_entity_id => l_MODIFIERS_rec.list_header_id,
974: x_return_status => l_return_status );
975:
976: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
977: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
978: p_entity_id => l_MODIFIERS_rec.list_line_id,
979: x_return_status => l_return_status );
980: end if;
981:

Line 1002: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

998: -- mkarya If process_modifiers has been called from public package, then ONLY call
999: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1000: if l_control_rec.called_from_ui = 'N' then
1001: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1002: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1003: p_entity_id => l_MODIFIERS_rec.list_line_id,
1004: x_return_status => l_return_status );
1005:
1006: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1007: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1003: p_entity_id => l_MODIFIERS_rec.list_line_id,
1004: x_return_status => l_return_status );
1005:
1006: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1007: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1008: p_entity_id => l_MODIFIERS_rec.list_line_id,
1009: x_return_status => l_return_status );
1010:
1011: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1012: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

1008: p_entity_id => l_MODIFIERS_rec.list_line_id,
1009: x_return_status => l_return_status );
1010:
1011: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1012: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1013: p_entity_id => l_MODIFIERS_rec.list_header_id,
1014: x_return_status => l_return_status );
1015:
1016: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1017: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

1013: p_entity_id => l_MODIFIERS_rec.list_header_id,
1014: x_return_status => l_return_status );
1015:
1016: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1017: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1018: p_entity_id => l_MODIFIERS_rec.list_line_id,
1019: x_return_status => l_return_status );
1020: end if;
1021:

Line 1063: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1059: -- Qualifierss
1060:
1061: PROCEDURE Qualifierss
1062: ( p_validation_level IN NUMBER
1063: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1064: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1065: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1066: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1067: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 1071: l_control_rec QP_GLOBALS.Control_Rec_Type;

1067: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
1068: )
1069: IS
1070: l_return_status VARCHAR2(1);
1071: l_control_rec QP_GLOBALS.Control_Rec_Type;
1072: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1073: l_p_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1074: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1075: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 1100: l_control_rec := QP_GLOBALS.Init_Control_Rec

1096: END IF;
1097:
1098: -- Load API control record
1099:
1100: l_control_rec := QP_GLOBALS.Init_Control_Rec
1101: ( p_operation => l_QUALIFIERS_rec.operation
1102: , p_control_rec => p_control_rec
1103: );
1104:

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

1107: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1108:
1109: -- Prepare record.
1110:
1111: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1112:
1113: oe_debug_pub.add('test01');
1114: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
1115:

Line 1121: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1117:
1118: l_old_QUALIFIERS_rec :=
1119: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
1120:
1121: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1122: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
1123: THEN
1124:
1125: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

Line 1122: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

1118: l_old_QUALIFIERS_rec :=
1119: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
1120:
1121: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1122: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
1123: THEN
1124:
1125: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1126:

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

1225: -- Entity level validation.
1226:
1227: IF l_control_rec.validate_entity THEN
1228:
1229: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1230:
1231: QP_Validate_Qualifiers.Entity_Delete
1232: ( x_return_status => l_return_status
1233: , p_QUALIFIERS_rec => l_QUALIFIERS_rec

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

1269: -- Step 4. Write to DB
1270:
1271: IF l_control_rec.write_to_db THEN
1272:
1273: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1274:
1275: QP_Qualifiers_Util.Delete_Row
1276: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
1277: );

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

1283: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1284: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
1285: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1286:
1287: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1288:
1289: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1290:
1291: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

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

1287: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1288:
1289: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1290:
1291: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1292:
1293: l_QUALIFIERS_rec.creation_date := SYSDATE;
1294: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1295:

Line 1325: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1321: -- mkarya If process_modifiers has been called from public package, then ONLY call
1322: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1323: if l_control_rec.called_from_ui = 'N' then
1324: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1325: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1326: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1327: x_return_status => l_return_status );
1328:
1329: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1330: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1326: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1327: x_return_status => l_return_status );
1328:
1329: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1330: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1331: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1332: x_return_status => l_return_status );
1333:
1334: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1335: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1331: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1332: x_return_status => l_return_status );
1333:
1334: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1335: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1336: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1337: x_return_status => l_return_status );
1338: end if;
1339:

Line 1353: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1349: -- mkarya If process_modifiers has been called from public package, then ONLY call
1350: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1351: if l_control_rec.called_from_ui = 'N' then
1352: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1353: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1354: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1355: x_return_status => l_return_status );
1356:
1357: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1358: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1354: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1355: x_return_status => l_return_status );
1356:
1357: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1358: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1359: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1360: x_return_status => l_return_status );
1361:
1362: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1363: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1359: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1360: x_return_status => l_return_status );
1361:
1362: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1363: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1364: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1365: x_return_status => l_return_status );
1366: end if;
1367:

Line 1388: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1384: -- mkarya If process_modifiers has been called from public package, then ONLY call
1385: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1386: if l_control_rec.called_from_ui = 'N' then
1387: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1388: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1389: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1390: x_return_status => l_return_status );
1391:
1392: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1393: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1389: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1390: x_return_status => l_return_status );
1391:
1392: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1393: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1394: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1395: x_return_status => l_return_status );
1396:
1397: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1398: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1394: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1395: x_return_status => l_return_status );
1396:
1397: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1398: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1399: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1400: x_return_status => l_return_status );
1401: end if;
1402:

Line 1446: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1442: -- Pricing_Attrs
1443:
1444: PROCEDURE Pricing_Attrs
1445: ( p_validation_level IN NUMBER
1446: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1447: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1448: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1449: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1450: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

Line 1465: l_control_rec QP_GLOBALS.Control_Rec_Type;

1461: --- end of additions by svdeshmu
1462:
1463:
1464: l_return_status VARCHAR2(1);
1465: l_control_rec QP_GLOBALS.Control_Rec_Type;
1466: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1467: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1468: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1469: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1495: l_control_rec := QP_GLOBALS.Init_Control_Rec

1491: END IF;
1492:
1493: -- Load API control record
1494:
1495: l_control_rec := QP_GLOBALS.Init_Control_Rec
1496: ( p_operation => l_PRICING_ATTR_rec.operation
1497: , p_control_rec => p_control_rec
1498: );
1499:

Line 1508: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1504: -- Prepare record.
1505:
1506: oe_debug_pub.add('oper = '|| l_PRICING_ATTR_rec.operation );
1507:
1508: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1509:
1510: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
1511:
1512: -- Set missing old record elements to NULL.

Line 1517: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1513:
1514: l_old_PRICING_ATTR_rec :=
1515: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1516:
1517: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1518: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1519: THEN
1520:
1521: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

Line 1518: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE

1514: l_old_PRICING_ATTR_rec :=
1515: QP_Pricing_Attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1516:
1517: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1518: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1519: THEN
1520:
1521: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1522:

Line 1555: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

1551:
1552: -- Attribute level validation.
1553:
1554: oe_debug_pub.add('2222');
1555: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1556: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1557: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1558:
1559:

Line 1556: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1552: -- Attribute level validation.
1553:
1554: oe_debug_pub.add('2222');
1555: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1556: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1557: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1558:
1559:
1560: --- added by svdeshmu

Line 1557: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1553:
1554: oe_debug_pub.add('2222');
1555: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1556: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1557: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1558:
1559:
1560: --- added by svdeshmu
1561:

Line 1591: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

1587: l_continuous_price_break_flag := NULL;
1588: END;
1589:
1590: qp_delayed_requests_PVT.log_request
1591: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1592: , p_entity_id => l_PRICING_ATTR_REC.list_line_id
1593: , p_param1 =>l_parent_list_line_id
1594: , p_param2 => l_continuous_price_break_flag
1595: --Added the param to call the validation

Line 1597: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICING_ATTR

1593: , p_param1 =>l_parent_list_line_id
1594: , p_param2 => l_continuous_price_break_flag
1595: --Added the param to call the validation
1596: --function depending upon the break type
1597: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICING_ATTR
1598: , p_requesting_entity_id => l_PRICING_ATTR_REC.list_line_id
1599: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1600: , x_return_status => l_return_status);
1601:

Line 1599: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

1595: --Added the param to call the validation
1596: --function depending upon the break type
1597: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICING_ATTR
1598: , p_requesting_entity_id => l_PRICING_ATTR_REC.list_line_id
1599: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1600: , x_return_status => l_return_status);
1601:
1602: END IF;
1603: -- end of additions by svdeshmu

Line 1676: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1672:
1673: oe_debug_pub.add('5555');
1674: IF l_control_rec.validate_entity THEN
1675:
1676: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1677:
1678: QP_Validate_Pricing_Attr.Entity_Delete
1679: ( x_return_status => l_return_status
1680: , p_PRICING_ATTR_rec => l_PRICING_ATTR_rec

Line 1717: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1713:
1714: oe_debug_pub.add('6666');
1715: IF l_control_rec.write_to_db THEN
1716:
1717: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1718:
1719: --added by svdeshmu
1720:
1721:

Line 1769: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1765:
1766: oe_debug_pub.add('calling log request for ob from private ');
1767: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1768: qp_delayed_requests_PVT.log_request
1769: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1770: , p_entity_id => l_parent_list_line_id
1771: , p_param1 =>l_list_line_type_code
1772: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_requesting_entity_id => l_parent_list_line_id

Line 1772: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

1768: qp_delayed_requests_PVT.log_request
1769: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1770: , p_entity_id => l_parent_list_line_id
1771: , p_param1 =>l_list_line_type_code
1772: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_requesting_entity_id => l_parent_list_line_id
1774: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1775: , x_return_status => l_return_status
1776: );

Line 1774: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD

1770: , p_entity_id => l_parent_list_line_id
1771: , p_param1 =>l_list_line_type_code
1772: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_requesting_entity_id => l_parent_list_line_id
1774: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1775: , x_return_status => l_return_status
1776: );
1777: END IF;
1778:

Line 1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1793: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1794: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1795: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1796:
1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1798:
1799: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
1800:
1801: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1801: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1798:
1799: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
1800:
1801: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1802:
1803: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1804: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1805: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');

Line 1840: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1836: -- mkarya If process_modifiers has been called from public package, then ONLY call
1837: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1838: if l_control_rec.called_from_ui = 'N' then
1839: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1840: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1841: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1842: x_return_status => l_return_status );
1843:
1844: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1845: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1841: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1842: x_return_status => l_return_status );
1843:
1844: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1845: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1846: p_entity_id => l_parent_list_line_id,
1847: x_return_status => l_return_status );
1848:
1849: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1850: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1846: p_entity_id => l_parent_list_line_id,
1847: x_return_status => l_return_status );
1848:
1849: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1850: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1851: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1852: x_return_status => l_return_status );
1853:
1854: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1855: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1851: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1852: x_return_status => l_return_status );
1853:
1854: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1855: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1856: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1857: x_return_status => l_return_status );
1858: end if;
1859:

Line 1873: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1869: -- mkarya If process_modifiers has been called from public package, then ONLY call
1870: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1871: if l_control_rec.called_from_ui = 'N' then
1872: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1873: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1874: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1875: x_return_status => l_return_status );
1876:
1877: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1878: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1874: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1875: x_return_status => l_return_status );
1876:
1877: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1878: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1879: p_entity_id => l_parent_list_line_id,
1880: x_return_status => l_return_status );
1881:
1882: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1883: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1879: p_entity_id => l_parent_list_line_id,
1880: x_return_status => l_return_status );
1881:
1882: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1883: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1884: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1885: x_return_status => l_return_status );
1886:
1887: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1888: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1884: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1885: x_return_status => l_return_status );
1886:
1887: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1888: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1889: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1890: x_return_status => l_return_status );
1891: end if;
1892:

Line 1913: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1909: -- mkarya If process_modifiers has been called from public package, then ONLY call
1910: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1911: if l_control_rec.called_from_ui = 'N' then
1912: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1913: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1914: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1915: x_return_status => l_return_status );
1916:
1917: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1918: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1914: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1915: x_return_status => l_return_status );
1916:
1917: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1918: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1919: p_entity_id => l_parent_list_line_id,
1920: x_return_status => l_return_status );
1921:
1922: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1923: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1919: p_entity_id => l_parent_list_line_id,
1920: x_return_status => l_return_status );
1921:
1922: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1923: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1924: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1925: x_return_status => l_return_status );
1926:
1927: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1928: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1924: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1925: x_return_status => l_return_status );
1926:
1927: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1928: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1929: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1930: x_return_status => l_return_status );
1931: end if;
1932:

Line 1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

1987: ( p_api_version_number IN NUMBER
1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1992: QP_GLOBALS.G_MISS_CONTROL_REC
1993: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1994: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1995: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1992: QP_GLOBALS.G_MISS_CONTROL_REC

1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1992: QP_GLOBALS.G_MISS_CONTROL_REC
1993: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1994: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1995: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1996: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

Line 2023: l_control_rec QP_GLOBALS.Control_Rec_Type;

2019: l_list_type_code VARCHAR2(30);
2020: l_api_name CONSTANT VARCHAR2(30):= 'Process_Modifiers';
2021: l_return_status VARCHAR2(1);
2022: l_qp_status VARCHAR2(1);
2023: l_control_rec QP_GLOBALS.Control_Rec_Type;
2024: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2025: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2026: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2027: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

Line 2086: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

2082: RAISE FND_API.G_EXC_ERROR;
2083:
2084: END IF;
2085:
2086: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
2087: -- Check the security privilege
2088: IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
2089: p_instance_type => QP_Security.G_MODIFIER_OBJECT,
2090: p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id) = 'F'

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

2131:
2132: -- Perform MODIFIER_LIST group requests.
2133:
2134: IF p_control_rec.process AND
2135: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2136: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIER_LIST)
2137: THEN
2138:
2139: -- FOR QUALIFICATION_IND

Line 2136: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIER_LIST)

2132: -- Perform MODIFIER_LIST group requests.
2133:
2134: IF p_control_rec.process AND
2135: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2136: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIER_LIST)
2137: THEN
2138:
2139: -- FOR QUALIFICATION_IND
2140: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2141: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST

2137: THEN
2138:
2139: -- FOR QUALIFICATION_IND
2140: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2141: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
2142: ,p_delete => FND_API.G_TRUE
2143: ,x_return_status => l_return_status
2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2162: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

2158: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP
2159:
2160: l_MODIFIERS_rec := l_MODIFIERS_tbl(I);
2161:
2162: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2163: AND (l_MODIFIERS_rec.list_header_id IS NULL OR
2164: l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2165: THEN
2166:

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

2186:
2187: -- Perform MODIFIERS group requests.
2188:
2189: IF p_control_rec.process AND
2190: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2191: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2192: THEN
2193: oe_debug_pub.add('here1');
2194: --NULL;

Line 2191: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)

2187: -- Perform MODIFIERS group requests.
2188:
2189: IF p_control_rec.process AND
2190: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2191: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2192: THEN
2193: oe_debug_pub.add('here1');
2194: --NULL;
2195:

Line 2198: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

2194: --NULL;
2195:
2196: -- FOR QUALIFICATION_IND
2197: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2198: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2199: ,p_delete => FND_API.G_TRUE
2200: ,x_return_status => l_return_status
2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2218: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

2214:
2215: oe_debug_pub.add('here2');
2216: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2217:
2218: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2219: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2220: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2221: THEN
2222:

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

2242: -- Perform QUALIFIERS group requests.
2243:
2244: oe_debug_pub.add('here4');
2245: IF p_control_rec.process AND
2246: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2247: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2248: THEN
2249:
2250: oe_debug_pub.add('here5');

Line 2247: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

2243:
2244: oe_debug_pub.add('here4');
2245: IF p_control_rec.process AND
2246: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2247: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2248: THEN
2249:
2250: oe_debug_pub.add('here5');
2251: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP

Line 2253: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS

2249:
2250: oe_debug_pub.add('here5');
2251: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2252: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2253: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2254: ,p_delete => FND_API.G_TRUE
2255: ,x_return_status => l_return_status
2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2274: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

2270:
2271: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2272:
2273: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2274: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2275: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2277: THEN
2278:

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

2321: oe_debug_pub.add('after pricing attrhere6');
2322: -- Perform PRICING_ATTR group requests.
2323:
2324: IF p_control_rec.process AND
2325: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2326: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2327: THEN
2328:
2329:

Line 2326: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)

2322: -- Perform PRICING_ATTR group requests.
2323:
2324: IF p_control_rec.process AND
2325: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2326: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2327: THEN
2328:
2329:
2330: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2331: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

2327: THEN
2328:
2329:
2330: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2331: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2332: ,p_delete => FND_API.G_TRUE
2333: ,x_return_status => l_return_status
2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2349: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2345: oe_debug_pub.add('before last if');
2346: -- Step 6. Perform Object group logic
2347:
2348: IF p_control_rec.process AND
2349: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2350: THEN
2351: -- FOR QUALIFICATION_IND
2352: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2353: (

Line 2363: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;
2361: /*
2362: oe_debug_pub.add('calling process_request');
2363: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2364: x_return_status=>l_return_status);
2365:
2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2367:

Line 2391: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2387: AND (l_qp_status = 'S' OR l_MODIFIER_LIST_rec.gsa_indicator = 'Y')) THEN
2388:
2389:
2390: IF p_control_rec.process AND
2391: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2392: THEN
2393: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');
2394: -- FOR Duplicate Modifier Lines
2395: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests

Line 2492: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

2488:
2489: -- Create blanket header qualifier
2490:
2491: IF ( p_control_rec.write_to_db --Bug#3309455
2492: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2493: AND x_MODIFIER_LIST_rec.list_source_code = 'BSO'
2494: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2495: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2496: )

Line 2519: , p_operation => QP_GLOBALS.G_OPR_CREATE

2515: QP_Qualifier_Rules_PVT.Create_Blanket_Qualifier
2516: ( p_list_header_id => x_MODIFIER_LIST_rec.list_header_id
2517: , p_old_list_header_id => x_MODIFIER_LIST_rec.list_header_id
2518: , p_blanket_id => to_number(x_MODIFIER_LIST_rec.orig_system_header_ref)
2519: , p_operation => QP_GLOBALS.G_OPR_CREATE
2520: , x_return_status => l_return_status
2521: );
2522:
2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2680: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

2676: SAVEPOINT Lock_Modifiers_PVT;
2677:
2678: -- Lock MODIFIER_LIST
2679:
2680: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
2681:
2682: QP_Modifier_List_Util.Lock_Row
2683: ( p_MODIFIER_LIST_rec => p_MODIFIER_LIST_rec
2684: , x_MODIFIER_LIST_rec => x_MODIFIER_LIST_rec

Line 2701: IF p_MODIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2697: -- Lock MODIFIERS
2698:
2699: FOR I IN 1..p_MODIFIERS_tbl.COUNT LOOP
2700:
2701: IF p_MODIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2702:
2703: QP_Modifiers_Util.Lock_Row
2704: ( p_MODIFIERS_rec => p_MODIFIERS_tbl(I)
2705: , x_MODIFIERS_rec => l_MODIFIERS_rec

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

2721: -- Lock QUALIFIERS
2722:
2723: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2724:
2725: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2726:
2727: QP_Qualifiers_Util.Lock_Row
2728: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2729: , x_QUALIFIERS_rec => l_QUALIFIERS_rec

Line 2749: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2745: -- Lock PRICING_ATTR
2746:
2747: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2748:
2749: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2750:
2751: QP_Pricing_Attr_Util.Lock_Row
2752: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2753: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec