DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT dependencies on QP_DELAYED_REQUESTS_PVT

Line 353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

Line 355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

Line 370: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

366: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
367: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
368:
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,

Line 372: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

Line 395: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

391: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
392: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
393:
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,

Line 397: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

Line 454: qp_delayed_requests_pvt.log_request(

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

Line 709: qp_delayed_requests_PVT.log_request(

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

Line 772: qp_delayed_requests_PVT.log_request(

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

Line 884: qp_delayed_requests_PVT.log_request(

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

Line 897: qp_delayed_requests_PVT.log_request(

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

Line 929: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

925: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
926: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
927:
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,

Line 931: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 962: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

958: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
959: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
960:
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,

Line 964: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 1002: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

998: );
999: END IF;
1000:
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,

Line 1004: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 1325: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1321: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1322: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1323:
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,

Line 1327: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

Line 1353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1349: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1350: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1351:
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,

Line 1355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

Line 1388: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1384: );
1385: END IF;
1386:
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,

Line 1390: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

Line 1593: qp_delayed_requests_PVT.log_request

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

Line 1771: qp_delayed_requests_PVT.log_request

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

Line 1840: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

Line 1842: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 1873: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1869: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1870: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1871:
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,

Line 1875: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 1913: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

1909: );
1910: END IF;
1911:
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,

Line 1915: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

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

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

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

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

Line 2143: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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

Line 2204: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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

Line 2259: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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

Line 2337: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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

Line 2359: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests

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: (
2361: x_return_status => l_return_status
2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

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
2403: (
2404: x_return_status => l_return_status
2405: );
2406:

Line 2552: qp_delayed_requests_pvt.Clear_Request

2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2549: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2550: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2551: if p_control_rec.called_from_ui = 'N' then
2552: qp_delayed_requests_pvt.Clear_Request
2553: (x_return_status => l_return_status);
2554: end if;
2555:
2556: -- Get message count and data

Line 2569: qp_delayed_requests_pvt.Clear_Request

2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2568: if p_control_rec.called_from_ui = 'N' then
2569: qp_delayed_requests_pvt.Clear_Request
2570: (x_return_status => l_return_status);
2571: end if;
2572:
2573: -- Get message count and data

Line 2596: qp_delayed_requests_pvt.Clear_Request

2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593:
2594: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2595: if p_control_rec.called_from_ui = 'N' then
2596: qp_delayed_requests_pvt.Clear_Request
2597: (x_return_status => l_return_status);
2598: end if;
2599:
2600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)