[Home] [Help]
20: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_QP_QUAL_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12):='ozfvqpqb.pls';
22: g_bg_tbl qp_attr_mapping_pub.t_multirecord;
23: g_total NUMBER := 1 ;
24: g_rel_type VARCHAR2(30) := FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE');
25:
26:
27: FUNCTION check_exists(p_party_id NUMBER)
28: RETURN boolean IS
69: /*
70: CURSOR c_bg IS
71: select object_id
72: from hz_party_relationships
73: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
74: and subject_id=p_party_id;
75: */
76:
77: CURSOR c_bg IS
76:
77: CURSOR c_bg IS
78: SELECT r1.object_id
79: FROM hz_relationships r1
80: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
81: AND r1.subject_type = 'ORGANIZATION'
82: AND r1.subject_table_name = 'HZ_PARTIES'
83: AND r1.object_type = 'ORGANIZATION'
84: AND r1.object_table_name = 'HZ_PARTIES'
144: /*
145: CURSOR c_bg IS
146: select object_id
147: from hz_party_relationships
148: where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
149: and subject_id=p_party_id;
150: */
151:
152: CURSOR c_bg IS
151:
152: CURSOR c_bg IS
153: SELECT r1.object_id
154: FROM hz_relationships r1
155: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
156: AND r1.subject_type = 'ORGANIZATION'
157: AND r1.subject_table_name = 'HZ_PARTIES'
158: AND r1.object_type = 'ORGANIZATION'
159: AND r1.object_table_name = 'HZ_PARTIES'
216:
217: CURSOR c_bg IS
218: SELECT r1.object_id
219: FROM hz_relationships r1
220: WHERE r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
221: AND r1.subject_type = 'ORGANIZATION'
222: AND r1.subject_table_name = 'HZ_PARTIES'
223: AND r1.object_type = 'ORGANIZATION'
224: AND r1.object_table_name = 'HZ_PARTIES'