DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_DELAYED_REQUESTS_PVT

Line 877: qp_delayed_requests_PVT.log_request(

873:
874: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
875: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
876: THEN
877: qp_delayed_requests_PVT.log_request(
878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
879: p_entity_id => p_MODIFIERS_rec.list_line_id,
880: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
881: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 979: qp_delayed_requests_PVT.log_request(

975: */
976: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
977: THEN
978: NULL;
979: qp_delayed_requests_PVT.log_request(
980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
981: p_entity_id => p_MODIFIERS_rec.list_line_id,
982: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
983: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 987: qp_delayed_requests_PVT.log_request(

983: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
985: x_return_status => l_return_status);
986:
987: qp_delayed_requests_PVT.log_request(
988: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
989: p_entity_id => p_modifiers_rec.list_line_id,
990: p_param1 => p_modifiers_rec.list_header_id,
991: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 999: qp_delayed_requests_pvt.log_request(

995:
996: --hw
997: -- log the changed lines API delayed request for phase change;
998: if QP_PERF_PVT.enabled = 'Y' then
999: qp_delayed_requests_pvt.log_request(
1000: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_entity_id => p_MODIFIERS_rec.list_line_id,
1002: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1003: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1082: qp_delayed_requests_PVT.log_request(

1078: --qualification_ind has to be updated in delayed request only once, this is duplication to avoid performance problem
1079: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1080: THEN
1081: /*
1082: qp_delayed_requests_PVT.log_request(
1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1084: p_entity_id => p_MODIFIERS_rec.list_header_id,
1085: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1086: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,

Line 1096: qp_delayed_requests_PVT.log_request(

1092:
1093: /* 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
1094: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1095: THEN
1096: qp_delayed_requests_PVT.log_request(
1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1098: p_entity_id => p_MODIFIERS_rec.list_line_id,
1099: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1100: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1114: qp_delayed_requests_PVT.log_request

1110:
1111: --hvop
1112:
1113: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1114: qp_delayed_requests_PVT.log_request
1115: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1116: , p_entity_id => p_MODIFIERS_rec.list_line_id
1117: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1118: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

Line 1127: qp_delayed_requests_PVT.log_request

1123: --hvop
1124: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then
1125:
1126: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1127: qp_delayed_requests_PVT.log_request
1128: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1129: , p_entity_id => p_MODIFIERS_rec.list_line_id
1130: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1131: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

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

1136:
1137: else
1138: -- Fix For Bug No - 5251238 This is a latent issue
1139: begin
1140: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1141: , p_entity_id => p_MODIFIERS_rec.list_line_id
1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request

Line 1144: QP_delayed_requests_pvt.Delete_Request

1140: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1141: , p_entity_id => p_MODIFIERS_rec.list_line_id
1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request
1145: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1146: , p_entity_id => p_MODIFIERS_rec.list_line_id
1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1148: , x_return_status => l_return_status

Line 1162: qp_delayed_requests_PVT.log_request

1158:
1159: if p_MODIFIERS_rec.list_line_type_code = 'PBH' then
1160:
1161: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1162: qp_delayed_requests_PVT.log_request
1163: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1164: , p_entity_id => p_MODIFIERS_rec.list_line_id
1165: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1166: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id

Line 1196: qp_delayed_requests_PVT.log_request(

1192: -- 'LINE'/'LINEGROUP' or 'ORDER'
1193: oe_debug_pub.add('Logging a request G_CHECK_LINE_FOR_HEADER_QUAL for modifier level change');
1194: -- Bug 2419504, log this request only if attribute manager is installed
1195: IF qp_util.attrmgr_installed = 'Y' then
1196: qp_delayed_requests_PVT.log_request(
1197: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1198: p_entity_id => p_MODIFIERS_rec.list_header_id,
1199: p_request_unique_key1 => -1,
1200: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 1352: qp_delayed_requests_pvt.log_request(

1348: THEN
1349: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1350: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1351: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1352: qp_delayed_requests_pvt.log_request(
1353: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1354: p_entity_id => p_MODIFIERS_rec.list_header_id,
1355: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1356: p_request_unique_key2 => 'U',

Line 4696: qp_delayed_requests_PVT.log_request(

4692: if((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_CREATE)) or
4693: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and
4694: (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id))
4695: then
4696: qp_delayed_requests_PVT.log_request(
4697: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4698: p_entity_id => p_MODIFIERS_rec.list_header_id,
4699: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4700: p_param4 => l_call_from,

Line 4707: qp_delayed_requests_PVT.log_request(

4703: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4704: x_return_status => l_return_status);
4705:
4706: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4707: qp_delayed_requests_PVT.log_request(
4708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4709: p_entity_id => p_MODIFIERS_rec.list_header_id,
4710: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4711: p_param4 => l_call_from,

Line 4727: qp_delayed_requests_PVT.log_request(

4723: if (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id)
4724: then
4725: Log_Update_Phases_DL(p_MODIFIERS_rec => p_MODIFIERS_rec,
4726: x_return_status => l_return_status);
4727: qp_delayed_requests_PVT.log_request(
4728: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4729: p_entity_id => p_MODIFIERS_rec.list_header_id,
4730: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4731: p_param4 => l_call_from,

Line 4750: qp_delayed_requests_PVT.log_request(

4746: when no_data_found then
4747: l_count :=0;
4748: end;
4749: if l_count >0 then
4750: qp_delayed_requests_PVT.log_request(
4751: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4752: p_entity_id => p_MODIFIERS_rec.list_header_id,
4753: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4754: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 4774: qp_delayed_requests_PVT.log_request(

4770:
4771: oe_debug_pub.add('request to update G_UPDATE_MANUAL_MODIFIER_FLAG '||l_parent_line_type, 1);
4772: oe_debug_pub.add('Logging a request to update G_UPDATE_MANUAL_MODIFIER_FLAG ', 1);
4773:
4774: qp_delayed_requests_PVT.log_request(
4775: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4776: p_entity_id => p_MODIFIERS_rec.list_line_id,
4777: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4778: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 4819: qp_delayed_requests_PVT.log_request(

4815: from qp_pricing_phases
4816: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
4817:
4818: if l_manual_modifier_flag is null then
4819: qp_delayed_requests_PVT.log_request(
4820: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4821: p_entity_id => p_MODIFIERS_rec.list_header_id,
4822: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4823: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 4834: qp_delayed_requests_PVT.log_request(

4830: elsif l_manual_modifier_flag = 'A' then
4831: if( p_MODIFIERS_rec.automatic_flag = 'Y') then
4832: null;
4833: else
4834: qp_delayed_requests_PVT.log_request(
4835: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4836: p_entity_id => p_MODIFIERS_rec.list_header_id,
4837: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4838: p_param2 => p_MODIFIERS_rec.automatic_flag,

Line 4849: qp_delayed_requests_PVT.log_request(

4845: elsif l_manual_modifier_flag ='M' then
4846: if (p_MODIFIERS_rec.automatic_flag = 'N') then
4847: null;
4848: else
4849: qp_delayed_requests_PVT.log_request(
4850: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4851: p_entity_id => p_MODIFIERS_rec.list_header_id,
4852: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4853: p_param2 => p_MODIFIERS_rec.automatic_flag,