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 2653: FND_PROFILE.PUT('RESP_APPL_ID','0');

2649: BEGIN
2650:
2651: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2652:
2653: FND_PROFILE.PUT('RESP_APPL_ID','0');
2654: FND_PROFILE.PUT('RESP_ID','20419');
2655: FND_PROFILE.PUT('USER_ID','1001');
2656:
2657: -- Delete all the segments under the New Global Data Elements Context(if any)

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

2650:
2651: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2652:
2653: FND_PROFILE.PUT('RESP_APPL_ID','0');
2654: FND_PROFILE.PUT('RESP_ID','20419');
2655: FND_PROFILE.PUT('USER_ID','1001');
2656:
2657: -- Delete all the segments under the New Global Data Elements Context(if any)
2658:

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

2651: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2652:
2653: FND_PROFILE.PUT('RESP_APPL_ID','0');
2654: FND_PROFILE.PUT('RESP_ID','20419');
2655: FND_PROFILE.PUT('USER_ID','1001');
2656:
2657: -- Delete all the segments under the New Global Data Elements Context(if any)
2658:
2659: --dbms_output.put_line ('Before even starting the process');

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

4073: where ll.list_line_id = p_list_line_id
4074: and lh.list_header_id = ll.list_header_id;
4075: end if;
4076:
4077: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4078:
4079: IF qp_util.attrmgr_installed = 'Y' then
4080: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4081: if (((l_pte_code <> l_profile_pte_code) or

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

4076:
4077: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4078:
4079: IF qp_util.attrmgr_installed = 'Y' then
4080: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4081: if (((l_pte_code <> l_profile_pte_code) or
4082: (l_source_system_code <> l_profile_source_system_code)
4083: )
4084: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))

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

4170: BEGIN
4171:
4172: IF Attrmgr_Installed = 'Y' THEN
4173:
4174: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
4175:
4176: IF l_pte_code IS NULL THEN
4177: l_pte_code := 'ORDFUL';
4178: END IF;

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

4373:
4374: IF Attrmgr_Installed = 'Y' THEN
4375:
4376: --Get the PTE code
4377: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY', l_pte_code);
4378:
4379: IF l_pte_code IS NULL THEN
4380: l_pte_code := 'ORDFUL';
4381: END IF;

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

4644:
4645: IF Attrmgr_Installed = 'Y' THEN
4646:
4647: --Get PTE code from profile
4648: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
4649:
4650: IF l_pte_code IS NULL THEN
4651: l_pte_code := 'ORDFUL';
4652: END IF;

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

5027: if G_ORGANIZATION_ID is null then --above query did not return a value
5028: --because MO Default OU was not set or FSP is not set revert to QP profile
5029: */
5030: -- if G_ORGANIZATION_ID is null then
5031: l_inv_org_id := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5032:
5033: oe_debug_pub.add('inv_org_id from profile QP_ORGANIZATION_ID = '||l_inv_org_id);
5034: IF G_ORGANIZATION_ID IS NULL THEN
5035: G_ORGANIZATION_ID := l_inv_org_id;

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

5042: EXCEPTION
5043: when no_data_found then
5044: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5045: --fix for bug 4776045
5046: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5047: -- return G_ORGANIZATION_ID;
5048: return null;
5049:
5050: when others then

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

5049:
5050: when others then
5051: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5052: --fix for bug 4776045
5053: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5054: -- return G_ORGANIZATION_ID;
5055: return null;
5056:
5057: END Get_Item_Validation_Org;