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_DELAYED_REQUESTS_PVT

Line 350: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

346: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
347:
348: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
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,

Line 352: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

348: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
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;

Line 367: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

363: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
364: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
365:
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,

Line 369: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

365:
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;

Line 392: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

388: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
389: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
390:
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,

Line 394: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

390:
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;

Line 451: qp_delayed_requests_pvt.log_request(

447: or l_MODIFIERS_rec.modifier_level_code = 'LINEGROUP'
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,

Line 706: qp_delayed_requests_PVT.log_request(

702: ( p_list_line_id => l_MODIFIERS_rec.list_line_id
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,

Line 769: qp_delayed_requests_PVT.log_request(

765: , null
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,

Line 881: qp_delayed_requests_PVT.log_request(

877: , null
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,

Line 894: qp_delayed_requests_PVT.log_request(

890:
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,

Line 926: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

922: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
923: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
924:
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,

Line 928: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

924:
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:

Line 933: 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
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:

Line 938: 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
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:

Line 943: 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
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;

Line 959: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

955: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
956: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
957:
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,

Line 961: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

957:
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:

Line 966: 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
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:

Line 971: 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
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:

Line 976: 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
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;

Line 999: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

995: );
996: END IF;
997:
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,

Line 1001: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

997:
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:

Line 1006: 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
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:

Line 1011: 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
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:

Line 1016: 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
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;

Line 1322: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1318: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1319: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1320:
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,

Line 1324: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1320:
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:

Line 1329: 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
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:

Line 1334: 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
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;

Line 1350: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1346: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1347: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1348:
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,

Line 1352: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1348:
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:

Line 1357: 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
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:

Line 1362: 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
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;

Line 1385: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1381: );
1382: END IF;
1383:
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,

Line 1387: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1383:
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:

Line 1392: 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
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:

Line 1397: 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
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;

Line 1590: qp_delayed_requests_PVT.log_request

1586: WHEN OTHERS THEN
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

Line 1768: qp_delayed_requests_PVT.log_request

1764: IF l_status = 'T' THEN
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

Line 1837: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1833:
1834: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1835: --dbms_output.put_line('manoj - pricing_attr- value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
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,

Line 1839: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1835: --dbms_output.put_line('manoj - pricing_attr- value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
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:

Line 1844: 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
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:

Line 1849: 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
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:

Line 1854: 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
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;

Line 1870: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1866: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1867: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1868:
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,

Line 1872: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1868:
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:

Line 1877: 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
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:

Line 1882: 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
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:

Line 1887: 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
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;

Line 1910: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1906: );
1907: END IF;
1908:
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,

Line 1912: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1908:
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:

Line 1917: 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
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:

Line 1922: 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
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:

Line 1927: 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
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;

Line 2140: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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
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: );

Line 2197: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

2193: oe_debug_pub.add('here1');
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: );

Line 2252: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

2248: THEN
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: );

Line 2330: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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
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: );

Line 2352: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests

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: (
2354: x_return_status => l_return_status
2355: );
2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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 2395: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests

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
2396: (
2397: x_return_status => l_return_status
2398: );
2399:

Line 2545: qp_delayed_requests_pvt.Clear_Request

2541: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2542: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2543: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2544: if p_control_rec.called_from_ui = 'N' then
2545: qp_delayed_requests_pvt.Clear_Request
2546: (x_return_status => l_return_status);
2547: end if;
2548:
2549: -- Get message count and data

Line 2562: qp_delayed_requests_pvt.Clear_Request

2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2559:
2560: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2561: if p_control_rec.called_from_ui = 'N' then
2562: qp_delayed_requests_pvt.Clear_Request
2563: (x_return_status => l_return_status);
2564: end if;
2565:
2566: -- Get message count and data

Line 2589: qp_delayed_requests_pvt.Clear_Request

2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2586:
2587: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2588: if p_control_rec.called_from_ui = 'N' then
2589: qp_delayed_requests_pvt.Clear_Request
2590: (x_return_status => l_return_status);
2591: end if;
2592:
2593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)