DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on FND_PROFILE

Line 77: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),

73: l_is_valid BOOLEAN;
74: BEGIN
75: QP_UTIL.get_item_cat_info(
76: p_item_id,
77: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),
78: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),
79: l_item_name,
80: l_item_desc,
81: l_is_valid

Line 78: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),

74: BEGIN
75: QP_UTIL.get_item_cat_info(
76: p_item_id,
77: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),
78: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),
79: l_item_name,
80: l_item_desc,
81: l_is_valid
82: );

Line 198: l_check_active_flag := nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

194: l_check_active_flag VARCHAR2(1);
195:
196: BEGIN
197:
198: l_check_active_flag := nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
199:
200: IF l_check_active_flag = 'N' THEN
201: IF p_context_type='QUALIFIER' THEN
202: BEGIN

Line 481: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

477: AND a.pte_code = a_pte_code;
478:
479: BEGIN
480:
481: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
482:
483: IF l_pte_code IS NULL THEN
484: l_pte_code := 'ORDFUL';
485: END IF;

Line 1442: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

1438:
1439: BEGIN
1440:
1441: --Get the PTE code for the instance.
1442: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
1443:
1444: IF l_pte_code IS NULL THEN
1445: l_pte_code := 'ORDFUL';
1446: END IF;

Line 2640: FND_PROFILE.PUT('RESP_APPL_ID','0');

2636: BEGIN
2637:
2638: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2639:
2640: FND_PROFILE.PUT('RESP_APPL_ID','0');
2641: FND_PROFILE.PUT('RESP_ID','20419');
2642: FND_PROFILE.PUT('USER_ID','1001');
2643:
2644: -- Delete all the segments under the New Global Data Elements Context(if any)

Line 2641: FND_PROFILE.PUT('RESP_ID','20419');

2637:
2638: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2639:
2640: FND_PROFILE.PUT('RESP_APPL_ID','0');
2641: FND_PROFILE.PUT('RESP_ID','20419');
2642: FND_PROFILE.PUT('USER_ID','1001');
2643:
2644: -- Delete all the segments under the New Global Data Elements Context(if any)
2645:

Line 2642: FND_PROFILE.PUT('USER_ID','1001');

2638: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2639:
2640: FND_PROFILE.PUT('RESP_APPL_ID','0');
2641: FND_PROFILE.PUT('RESP_ID','20419');
2642: FND_PROFILE.PUT('USER_ID','1001');
2643:
2644: -- Delete all the segments under the New Global Data Elements Context(if any)
2645:
2646: --dbms_output.put_line ('Before even starting the process');

Line 4054: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);

4050: where ll.list_line_id = p_list_line_id
4051: and lh.list_header_id = ll.list_header_id;
4052: end if;
4053:
4054: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4055:
4056: IF qp_util.attrmgr_installed = 'Y' then
4057: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4058: if (((l_pte_code <> l_profile_pte_code) or

Line 4057: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);

4053:
4054: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4055:
4056: IF qp_util.attrmgr_installed = 'Y' then
4057: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4058: if (((l_pte_code <> l_profile_pte_code) or
4059: (l_source_system_code <> l_profile_source_system_code)
4060: )
4061: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))

Line 4151: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

4147: BEGIN
4148:
4149: IF Attrmgr_Installed = 'Y' THEN
4150:
4151: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
4152:
4153: IF l_pte_code IS NULL THEN
4154: l_pte_code := 'ORDFUL';
4155: END IF;

Line 4354: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);

4350:
4351: IF Attrmgr_Installed = 'Y' THEN
4352:
4353: --Get the PTE code
4354: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
4355:
4356: IF l_pte_code IS NULL THEN
4357: l_pte_code := 'ORDFUL';
4358: END IF;

Line 4625: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

4621:
4622: IF Attrmgr_Installed = 'Y' THEN
4623:
4624: --Get PTE code from profile
4625: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
4626:
4627: IF l_pte_code IS NULL THEN
4628: l_pte_code := 'ORDFUL';
4629: END IF;

Line 5008: l_inv_org_id := FND_PROFILE.Value('QP_ORGANIZATION_ID');

5004: if G_ORGANIZATION_ID is null then --above query did not return a value
5005: --because MO Default OU was not set or FSP is not set revert to QP profile
5006: */
5007: -- if G_ORGANIZATION_ID is null then
5008: l_inv_org_id := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5009:
5010: oe_debug_pub.add('inv_org_id from profile QP_ORGANIZATION_ID = '||l_inv_org_id);
5011: IF G_ORGANIZATION_ID IS NULL THEN
5012: G_ORGANIZATION_ID := l_inv_org_id;

Line 5023: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');

5019: EXCEPTION
5020: when no_data_found then
5021: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5022: --fix for bug 4776045
5023: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5024: -- return G_ORGANIZATION_ID;
5025: return null;
5026:
5027: when others then

Line 5030: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');

5026:
5027: when others then
5028: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5029: --fix for bug 4776045
5030: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5031: -- return G_ORGANIZATION_ID;
5032: return null;
5033:
5034: END Get_Item_Validation_Org;