DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_DELAYED_REQUESTS_PVT

Line 889: qp_delayed_requests_PVT.log_request(

885:
886: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
887: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
888: THEN
889: qp_delayed_requests_PVT.log_request(
890: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
891: p_entity_id => p_MODIFIERS_rec.list_line_id,
892: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
893: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 995: qp_delayed_requests_pvt.log_request(

991: -- jagan's PL/SQL pattern
992: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
993: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
994: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
995: qp_delayed_requests_pvt.log_request(
996: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
997: p_entity_id => p_MODIFIERS_rec.list_header_id,
998: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
999: p_request_unique_key2 => 'UD',

Line 1007: qp_delayed_requests_PVT.log_request(

1003: x_return_status => l_return_status);
1004: END IF;
1005: END IF;
1006: END IF;
1007: qp_delayed_requests_PVT.log_request(
1008: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1009: p_entity_id => p_MODIFIERS_rec.list_line_id,
1010: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1015: qp_delayed_requests_PVT.log_request(

1011: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1012: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1013: x_return_status => l_return_status);
1014:
1015: qp_delayed_requests_PVT.log_request(
1016: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1017: p_entity_id => p_modifiers_rec.list_line_id,
1018: p_param1 => p_modifiers_rec.list_header_id,
1019: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 1027: qp_delayed_requests_pvt.log_request(

1023:
1024: --hw
1025: -- log the changed lines API delayed request for phase change;
1026: if QP_PERF_PVT.enabled = 'Y' then
1027: qp_delayed_requests_pvt.log_request(
1028: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1029: p_entity_id => p_MODIFIERS_rec.list_line_id,
1030: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1031: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1110: qp_delayed_requests_PVT.log_request(

1106: --qualification_ind has to be updated in delayed request only once, this is duplication to avoid performance problem
1107: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1108: THEN
1109: /*
1110: qp_delayed_requests_PVT.log_request(
1111: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1112: p_entity_id => p_MODIFIERS_rec.list_header_id,
1113: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1114: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,

Line 1124: qp_delayed_requests_PVT.log_request(

1120:
1121: /* mkarya for bug 1874586. Commenting out here and restoring the code at the begining of the procedure Apply_Attribute_Changes so that qualification_ind delayed requests are logged as first request
1122: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1123: THEN
1124: qp_delayed_requests_PVT.log_request(
1125: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1126: p_entity_id => p_MODIFIERS_rec.list_line_id,
1127: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1128: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1142: qp_delayed_requests_PVT.log_request

1138:
1139: --hvop
1140:
1141: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1142: qp_delayed_requests_PVT.log_request
1143: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1144: , p_entity_id => p_MODIFIERS_rec.list_line_id
1145: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1146: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

Line 1155: qp_delayed_requests_PVT.log_request

1151: --hvop
1152: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then
1153:
1154: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1155: qp_delayed_requests_PVT.log_request
1156: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1157: , p_entity_id => p_MODIFIERS_rec.list_line_id
1158: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1159: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

Line 1168: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1164:
1165: else
1166: -- Fix For Bug No - 5251238 This is a latent issue
1167: begin
1168: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1169: , p_entity_id => p_MODIFIERS_rec.list_line_id
1170: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request

Line 1172: QP_delayed_requests_pvt.Delete_Request

1168: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1169: , p_entity_id => p_MODIFIERS_rec.list_line_id
1170: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request
1173: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1174: , p_entity_id => p_MODIFIERS_rec.list_line_id
1175: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1176: , x_return_status => l_return_status

Line 1190: qp_delayed_requests_PVT.log_request

1186:
1187: if p_MODIFIERS_rec.list_line_type_code = 'PBH' then
1188:
1189: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1190: qp_delayed_requests_PVT.log_request
1191: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1192: , p_entity_id => p_MODIFIERS_rec.list_line_id
1193: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1194: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id

Line 1224: qp_delayed_requests_PVT.log_request(

1220: -- 'LINE'/'LINEGROUP' or 'ORDER'
1221: oe_debug_pub.add('Logging a request G_CHECK_LINE_FOR_HEADER_QUAL for modifier level change');
1222: -- Bug 2419504, log this request only if attribute manager is installed
1223: IF qp_util.attrmgr_installed = 'Y' then
1224: qp_delayed_requests_PVT.log_request(
1225: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1226: p_entity_id => p_MODIFIERS_rec.list_header_id,
1227: p_request_unique_key1 => -1,
1228: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 1380: qp_delayed_requests_pvt.log_request(

1376: THEN
1377: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1378: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1379: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1380: qp_delayed_requests_pvt.log_request(
1381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1382: p_entity_id => p_MODIFIERS_rec.list_header_id,
1383: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1384: p_request_unique_key2 => 'U',

Line 1396: qp_delayed_requests_pvt.log_request(

1392: -- jagan's PL/SQL pattern
1393: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1394: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1395: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1396: qp_delayed_requests_pvt.log_request(
1397: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1398: p_entity_id => p_MODIFIERS_rec.list_header_id,
1399: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1400: p_request_unique_key2 => 'U',

Line 4862: qp_delayed_requests_pvt.log_request(

4858: -- jagan's PL/SQL pattern
4859: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
4860: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
4861: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
4862: qp_delayed_requests_pvt.log_request(
4863: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4864: p_entity_id => p_MODIFIERS_rec.list_header_id,
4865: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
4866: p_request_unique_key2 => 'I',

Line 4891: qp_delayed_requests_PVT.log_request(

4887: if((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_CREATE)) or
4888: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and
4889: (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id))
4890: then
4891: qp_delayed_requests_PVT.log_request(
4892: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4893: p_entity_id => p_MODIFIERS_rec.list_header_id,
4894: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4895: p_param4 => l_call_from,

Line 4902: qp_delayed_requests_PVT.log_request(

4898: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4899: x_return_status => l_return_status);
4900:
4901: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4902: qp_delayed_requests_PVT.log_request(
4903: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4904: p_entity_id => p_MODIFIERS_rec.list_header_id,
4905: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4906: p_param4 => l_call_from,

Line 4922: qp_delayed_requests_PVT.log_request(

4918: if (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id)
4919: then
4920: Log_Update_Phases_DL(p_MODIFIERS_rec => p_MODIFIERS_rec,
4921: x_return_status => l_return_status);
4922: qp_delayed_requests_PVT.log_request(
4923: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4924: p_entity_id => p_MODIFIERS_rec.list_header_id,
4925: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4926: p_param4 => l_call_from,

Line 4945: qp_delayed_requests_PVT.log_request(

4941: when no_data_found then
4942: l_count :=0;
4943: end;
4944: if l_count >0 then
4945: qp_delayed_requests_PVT.log_request(
4946: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4947: p_entity_id => p_MODIFIERS_rec.list_header_id,
4948: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4949: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 4969: qp_delayed_requests_PVT.log_request(

4965:
4966: oe_debug_pub.add('request to update G_UPDATE_MANUAL_MODIFIER_FLAG '||l_parent_line_type, 1);
4967: oe_debug_pub.add('Logging a request to update G_UPDATE_MANUAL_MODIFIER_FLAG ', 1);
4968:
4969: qp_delayed_requests_PVT.log_request(
4970: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4971: p_entity_id => p_MODIFIERS_rec.list_line_id,
4972: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4973: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 5014: qp_delayed_requests_PVT.log_request(

5010: from qp_pricing_phases
5011: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
5012:
5013: if l_manual_modifier_flag is null then
5014: qp_delayed_requests_PVT.log_request(
5015: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5016: p_entity_id => p_MODIFIERS_rec.list_header_id,
5017: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5018: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 5029: qp_delayed_requests_PVT.log_request(

5025: elsif l_manual_modifier_flag = 'A' then
5026: if( p_MODIFIERS_rec.automatic_flag = 'Y') then
5027: null;
5028: else
5029: qp_delayed_requests_PVT.log_request(
5030: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5031: p_entity_id => p_MODIFIERS_rec.list_header_id,
5032: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5033: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 5044: qp_delayed_requests_PVT.log_request(

5040: elsif l_manual_modifier_flag ='M' then
5041: if (p_MODIFIERS_rec.automatic_flag = 'N') then
5042: null;
5043: else
5044: qp_delayed_requests_PVT.log_request(
5045: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5046: p_entity_id => p_MODIFIERS_rec.list_header_id,
5047: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5048: p_param2 => p_MODIFIERS_rec.automatic_flag,