634: THEN
635: NULL;
636: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
637: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
638: qp_delayed_requests_pvt.log_request(
639: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
640: p_entity_id => p_PRICE_LIST_rec.list_header_id,
641: p_request_unique_key1 => NULL,
642: p_request_unique_key2 => 'UD',
650: -- jagan's PL/SQL pattern
651: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
652: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
653: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
654: qp_delayed_requests_pvt.log_request(
655: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
656: p_entity_id => p_PRICE_LIST_rec.list_header_id,
657: p_request_unique_key1 => NULL,
658: p_request_unique_key2 => 'UD',
677: -- jagan's PL/SQL pattern
678: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
679: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
680: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
681: qp_delayed_requests_pvt.log_request(
682: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
683: p_entity_id => p_PRICE_LIST_rec.list_header_id,
684: p_request_unique_key1 => NULL,
685: p_request_unique_key2 => 'UD',
698: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)
699: THEN
700: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
701: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
702: qp_delayed_requests_pvt.log_request(
703: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
704: p_entity_id => p_PRICE_LIST_rec.list_header_id,
705: p_request_unique_key1 => NULL,
706: p_request_unique_key2 => 'UD',
714: -- jagan's PL/SQL pattern
715: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
716: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
717: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
718: qp_delayed_requests_pvt.log_request(
719: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
720: p_entity_id => p_PRICE_LIST_rec.list_header_id,
721: p_request_unique_key1 => NULL,
722: p_request_unique_key2 => 'UD',
794: -- jagan's PL/SQL pattern
795: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
796: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
797: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
798: qp_delayed_requests_pvt.log_request(
799: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
800: p_entity_id => p_PRICE_LIST_rec.list_header_id,
801: p_request_unique_key1 => NULL,
802: p_request_unique_key2 => 'UD',
827: -- jagan's PL/SQL pattern
828: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
829: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
830: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
831: qp_delayed_requests_pvt.log_request(
832: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
833: p_entity_id => p_PRICE_LIST_rec.list_header_id,
834: p_request_unique_key1 => NULL,
835: p_request_unique_key2 => 'UD',
896: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)
897: THEN
898: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
899: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
900: qp_delayed_requests_pvt.log_request(
901: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
902: p_entity_id => p_PRICE_LIST_rec.list_header_id,
903: p_request_unique_key1 => NULL,
904: p_request_unique_key2 => 'UD',
912: -- jagan's PL/SQL pattern
913: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
914: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
915: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
916: qp_delayed_requests_pvt.log_request(
917: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
918: p_entity_id => p_PRICE_LIST_rec.list_header_id,
919: p_request_unique_key1 => NULL,
920: p_request_unique_key2 => 'UD',
982: -- jagan's PL/SQL pattern
983: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
984: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
985: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
986: qp_delayed_requests_pvt.log_request(
987: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
988: p_entity_id => p_PRICE_LIST_rec.list_header_id,
989: p_request_unique_key1 => NULL,
990: p_request_unique_key2 => 'UD',
1019: THEN
1020: NULL;
1021: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1022: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1023: qp_delayed_requests_pvt.log_request(
1024: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1025: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1026: p_request_unique_key1 => NULL,
1027: p_request_unique_key2 => 'UD',
1035: -- jagan's PL/SQL pattern
1036: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1037: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1038: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1039: qp_delayed_requests_pvt.log_request(
1040: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1041: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1042: p_request_unique_key1 => NULL,
1043: p_request_unique_key2 => 'UD',