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: --bug14758481
109: --and l_MODIFIER_LIST_rec.global_flag = 'N'

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

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

Line 134: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

Line 135: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE

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

Line 178: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

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

Line 179: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

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

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

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

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

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

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

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

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

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

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

Line 356: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 373: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 398: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 411: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

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

Line 421: l_control_rec QP_GLOBALS.Control_Rec_Type;

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

Line 455: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 459: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,

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

Line 477: l_control_rec := QP_GLOBALS.Init_Control_Rec

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

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

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

Line 497: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

Line 498: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

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

Line 532: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

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

Line 533: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

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

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

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

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

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

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

Line 710: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 713: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 715: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,

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

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

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

Line 773: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 775: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 777: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

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

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

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

Line 885: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 887: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 889: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

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

Line 898: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 901: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 903: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,

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

Line 932: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 937: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 942: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 947: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 965: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 970: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 975: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 980: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 1005: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1010: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1015: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 1020: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

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

Line 1066: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

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

Line 1074: l_control_rec QP_GLOBALS.Control_Rec_Type;

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

Line 1103: l_control_rec := QP_GLOBALS.Init_Control_Rec

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

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

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

Line 1124: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

Line 1125: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

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

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

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

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

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

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

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

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

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

Line 1328: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1333: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1338: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1356: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1361: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1366: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1391: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1396: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1401: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1449: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

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

Line 1468: l_control_rec QP_GLOBALS.Control_Rec_Type;

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

Line 1498: l_control_rec := QP_GLOBALS.Init_Control_Rec

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

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

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

Line 1520: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

Line 1521: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE

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

Line 1558: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

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

Line 1559: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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

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

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

Line 1594: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

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

Line 1600: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICING_ATTR

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

Line 1602: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

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

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

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

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

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

Line 1772: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

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

Line 1775: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

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

Line 1777: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD

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

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

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

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

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

Line 1843: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

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

Line 1848: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1853: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1858: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1876: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

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

Line 1881: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1886: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1891: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1916: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

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

Line 1921: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1926: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

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

Line 1931: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 1994: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

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

Line 1995: QP_GLOBALS.G_MISS_CONTROL_REC

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

Line 2026: l_control_rec QP_GLOBALS.Control_Rec_Type;

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

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

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

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

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

Line 2139: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIER_LIST)

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

Line 2144: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST

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

Line 2165: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

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

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

2193:
2194: -- Perform MODIFIERS group requests.
2195:
2196: IF p_control_rec.process AND
2197: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2198: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2199: THEN
2200: oe_debug_pub.add('here1');
2201: --NULL;

Line 2198: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)

2194: -- Perform MODIFIERS group requests.
2195:
2196: IF p_control_rec.process AND
2197: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2198: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2199: THEN
2200: oe_debug_pub.add('here1');
2201: --NULL;
2202:

Line 2205: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

2201: --NULL;
2202:
2203: -- FOR QUALIFICATION_IND
2204: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2205: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2206: ,p_delete => FND_API.G_TRUE
2207: ,x_return_status => l_return_status
2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2225: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

2221:
2222: oe_debug_pub.add('here2');
2223: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2224:
2225: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2226: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2227: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2228: THEN
2229:

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

2249: -- Perform QUALIFIERS group requests.
2250:
2251: oe_debug_pub.add('here4');
2252: IF p_control_rec.process AND
2253: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2254: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2255: THEN
2256:
2257: oe_debug_pub.add('here5');

Line 2254: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

2250:
2251: oe_debug_pub.add('here4');
2252: IF p_control_rec.process AND
2253: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2254: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2255: THEN
2256:
2257: oe_debug_pub.add('here5');
2258: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP

Line 2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS

2256:
2257: oe_debug_pub.add('here5');
2258: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2259: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2261: ,p_delete => FND_API.G_TRUE
2262: ,x_return_status => l_return_status
2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2281: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

2277:
2278: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2279:
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2282: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2284: THEN
2285:

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

2328: oe_debug_pub.add('after pricing attrhere6');
2329: -- Perform PRICING_ATTR group requests.
2330:
2331: IF p_control_rec.process AND
2332: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2333: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2334: THEN
2335:
2336:

Line 2333: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)

2329: -- Perform PRICING_ATTR group requests.
2330:
2331: IF p_control_rec.process AND
2332: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2333: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2334: THEN
2335:
2336:
2337: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2338: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

2334: THEN
2335:
2336:
2337: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2338: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2339: ,p_delete => FND_API.G_TRUE
2340: ,x_return_status => l_return_status
2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2356: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2352: oe_debug_pub.add('before last if');
2353: -- Step 6. Perform Object group logic
2354:
2355: IF p_control_rec.process AND
2356: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2357: THEN
2358: -- FOR QUALIFICATION_IND
2359: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2360: (

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

2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*
2369: oe_debug_pub.add('calling process_request');
2370: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2371: x_return_status=>l_return_status);
2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:

Line 2398: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2394: AND (l_qp_status = 'S' OR l_MODIFIER_LIST_rec.gsa_indicator = 'Y')) THEN
2395:
2396:
2397: IF p_control_rec.process AND
2398: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2399: THEN
2400: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');
2401: -- FOR Duplicate Modifier Lines
2402: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests

Line 2499: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

2495:
2496: -- Create blanket header qualifier
2497:
2498: IF ( p_control_rec.write_to_db --Bug#3309455
2499: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2500: AND x_MODIFIER_LIST_rec.list_source_code = 'BSO'
2501: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2502: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2503: )

Line 2526: , p_operation => QP_GLOBALS.G_OPR_CREATE

2522: QP_Qualifier_Rules_PVT.Create_Blanket_Qualifier
2523: ( p_list_header_id => x_MODIFIER_LIST_rec.list_header_id
2524: , p_old_list_header_id => x_MODIFIER_LIST_rec.list_header_id
2525: , p_blanket_id => to_number(x_MODIFIER_LIST_rec.orig_system_header_ref)
2526: , p_operation => QP_GLOBALS.G_OPR_CREATE
2527: , x_return_status => l_return_status
2528: );
2529:
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2683: SAVEPOINT Lock_Modifiers_PVT;
2684:
2685: -- Lock MODIFIER_LIST
2686:
2687: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
2688:
2689: QP_Modifier_List_Util.Lock_Row
2690: ( p_MODIFIER_LIST_rec => p_MODIFIER_LIST_rec
2691: , x_MODIFIER_LIST_rec => x_MODIFIER_LIST_rec

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

2704: -- Lock MODIFIERS
2705:
2706: FOR I IN 1..p_MODIFIERS_tbl.COUNT LOOP
2707:
2708: IF p_MODIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2709:
2710: QP_Modifiers_Util.Lock_Row
2711: ( p_MODIFIERS_rec => p_MODIFIERS_tbl(I)
2712: , x_MODIFIERS_rec => l_MODIFIERS_rec

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

2728: -- Lock QUALIFIERS
2729:
2730: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2731:
2732: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2733:
2734: QP_Qualifiers_Util.Lock_Row
2735: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2736: , x_QUALIFIERS_rec => l_QUALIFIERS_rec

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

2752: -- Lock PRICING_ATTR
2753:
2754: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2755:
2756: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2757:
2758: QP_Pricing_Attr_Util.Lock_Row
2759: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2760: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec