APPS.OZF_QP_QUAL_PVT dependencies on FND_PROFILE

Line 27: g_rel_type VARCHAR2(30) := FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE');

23: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_QP_QUAL_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12):='ozfvqpqb.pls';
25: g_bg_tbl qp_attr_mapping_pub.t_multirecord;
26: g_total NUMBER := 1 ;
27: g_rel_type VARCHAR2(30) := FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE');
28:
29:
30: FUNCTION check_exists(p_party_id NUMBER)
31: RETURN boolean IS

Line 76: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')

72: /*
73: CURSOR c_bg IS
74: select object_id
75: from hz_party_relationships
76: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
77: and subject_id=p_party_id;
78: */
79:
80: CURSOR c_bg IS

Line 83: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')

79:
80: CURSOR c_bg IS
81: SELECT r1.object_id
82: FROM hz_relationships r1
83: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
84: AND r1.subject_type = 'ORGANIZATION'
85: AND r1.subject_table_name = 'HZ_PARTIES'
86: AND r1.object_type = 'ORGANIZATION'
87: AND r1.object_table_name = 'HZ_PARTIES'

Line 151: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')

147: /*
148: CURSOR c_bg IS
149: select object_id
150: from hz_party_relationships
151: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
152: and subject_id=p_party_id;
153: */
154:
155: CURSOR c_bg IS

Line 158: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')

154:
155: CURSOR c_bg IS
156: SELECT r1.object_id
157: FROM hz_relationships r1
158: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
159: AND r1.subject_type = 'ORGANIZATION'
160: AND r1.subject_table_name = 'HZ_PARTIES'
161: AND r1.object_type = 'ORGANIZATION'
162: AND r1.object_table_name = 'HZ_PARTIES'

Line 223: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')

219:
220: CURSOR c_bg IS
221: SELECT r1.object_id
222: FROM hz_relationships r1
223: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
224: AND r1.subject_type = 'ORGANIZATION'
225: AND r1.subject_table_name = 'HZ_PARTIES'
226: AND r1.object_type = 'ORGANIZATION'
227: AND r1.object_table_name = 'HZ_PARTIES'

Line 2024: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

2020: ELSE
2021: l_call_costing_api := true;
2022: END IF;
2023:
2024: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
2025:
2026: WHEN l_resale_table_type = 'IFACE' THEN
2027:
2028: /*If the pricing call is made for a IFACE order through conc. prog

Line 2063: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

2059: ELSE
2060: l_call_costing_api := true;
2061: END IF;
2062:
2063: l_inv_org_id := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
2064:
2065: ELSE
2066: /*If the pricing call is made for direct OM order then this code will be executed. */
2067: OPEN c_order_info(p_line_id);

Line 2079: l_column_name := FND_PROFILE.value('OZF_ITEM_COST_COLUMN');

2075: END IF;
2076:
2077: MO_GLOBAL.set_policy_context('S', l_organization_id);
2078:
2079: l_column_name := FND_PROFILE.value('OZF_ITEM_COST_COLUMN');
2080:
2081: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW ) THEN
2082: Fnd_Msg_Pub.Add_Exc_Msg( 'l_column_name', l_column_name);
2083: END IF;