DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL dependencies on FND_PROFILE

Line 652: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

648: END IF; --Java Engine Installed
649: -- pattern
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,

Line 679: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

675: THEN
676: -- NULL;
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,

Line 716: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

712: END IF; --Java Engine Installed
713: -- pattern
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,

Line 796: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

792: THEN
793: -- NULL;
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,

Line 829: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

825: where currency_header_id = p_PRICE_LIST_rec.currency_header_id;
826: end if;
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,

Line 914: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

910: END IF; --Java Engine Installed
911: -- pattern
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,

Line 984: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

980: THEN
981: -- NULL;
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,

Line 1037: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

1033: END IF; --Java Engine Installed
1034: -- pattern
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,

Line 1624: l_source_system_code := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');

1620: x_result VARCHAR2(1);
1621:
1622: BEGIN
1623: /*
1624: l_source_system_code := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1625:
1626: IF l_source_system_code is null then
1627:
1628: l_source_system_code := 'QP';