eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIRS_UTIL dependencies on HZ_PARTIES

Line 1281: -- Cursor to derive party information from hz_parties

1277: object_version_number
1278: from csi_ip_accounts
1279: where instance_party_id = p_instance_party_id;
1280:
1281: -- Cursor to derive party information from hz_parties
1282: Cursor c_hz_parties_info(p_party_id number) is
1283: Select party_type
1284: from hz_parties
1285: where party_id = p_party_id;

Line 1282: Cursor c_hz_parties_info(p_party_id number) is

1278: from csi_ip_accounts
1279: where instance_party_id = p_instance_party_id;
1280:
1281: -- Cursor to derive party information from hz_parties
1282: Cursor c_hz_parties_info(p_party_id number) is
1283: Select party_type
1284: from hz_parties
1285: where party_id = p_party_id;
1286:

Line 1284: from hz_parties

1280:
1281: -- Cursor to derive party information from hz_parties
1282: Cursor c_hz_parties_info(p_party_id number) is
1283: Select party_type
1284: from hz_parties
1285: where party_id = p_party_id;
1286:
1287: -- cursor to get the number of party relationships for the given criteria
1288: Cursor c_tca_rel_count(p_subject_id number, p_subject_type varchar2,

Line 1295: and subject_table_name = 'HZ_PARTIES'

1291: Select count(relationship_id)
1292: from hz_relationships
1293: where subject_id = p_subject_id
1294: and subject_type = p_subject_type
1295: and subject_table_name = 'HZ_PARTIES'
1296: and object_id = p_object_id
1297: and object_type = p_object_type
1298: and object_table_name = 'HZ_PARTIES'
1299: and relationship_code = p_relationship_code

Line 1298: and object_table_name = 'HZ_PARTIES'

1294: and subject_type = p_subject_type
1295: and subject_table_name = 'HZ_PARTIES'
1296: and object_id = p_object_id
1297: and object_type = p_object_type
1298: and object_table_name = 'HZ_PARTIES'
1299: and relationship_code = p_relationship_code
1300: and sysdate between nvl(start_date, sysdate-1)
1301: and nvl(end_date, sysdate+1);
1302: BEGIN

Line 1320: Open c_hz_parties_info(p_current_owner_party_id);

1316: -- new owner, if desired
1317: if(p_create_tca_relation = fnd_api.g_true) then
1318:
1319: -- get info for original owner
1320: Open c_hz_parties_info(p_current_owner_party_id);
1321: Fetch c_hz_parties_info
1322: into l_current_owner_party_type;
1323: Close c_hz_parties_info;
1324:

Line 1321: Fetch c_hz_parties_info

1317: if(p_create_tca_relation = fnd_api.g_true) then
1318:
1319: -- get info for original owner
1320: Open c_hz_parties_info(p_current_owner_party_id);
1321: Fetch c_hz_parties_info
1322: into l_current_owner_party_type;
1323: Close c_hz_parties_info;
1324:
1325: -- get info for new owner

Line 1323: Close c_hz_parties_info;

1319: -- get info for original owner
1320: Open c_hz_parties_info(p_current_owner_party_id);
1321: Fetch c_hz_parties_info
1322: into l_current_owner_party_type;
1323: Close c_hz_parties_info;
1324:
1325: -- get info for new owner
1326: Open c_hz_parties_info(p_new_owner_party_id);
1327: Fetch c_hz_parties_info into l_new_owner_party_type;

Line 1326: Open c_hz_parties_info(p_new_owner_party_id);

1322: into l_current_owner_party_type;
1323: Close c_hz_parties_info;
1324:
1325: -- get info for new owner
1326: Open c_hz_parties_info(p_new_owner_party_id);
1327: Fetch c_hz_parties_info into l_new_owner_party_type;
1328: Close c_hz_parties_info;
1329:
1330: -- get relationship type and code from custom hook procedure

Line 1327: Fetch c_hz_parties_info into l_new_owner_party_type;

1323: Close c_hz_parties_info;
1324:
1325: -- get info for new owner
1326: Open c_hz_parties_info(p_new_owner_party_id);
1327: Fetch c_hz_parties_info into l_new_owner_party_type;
1328: Close c_hz_parties_info;
1329:
1330: -- get relationship type and code from custom hook procedure
1331: l_tca_rel_in_params.instance_id := p_instance_id;

Line 1328: Close c_hz_parties_info;

1324:
1325: -- get info for new owner
1326: Open c_hz_parties_info(p_new_owner_party_id);
1327: Fetch c_hz_parties_info into l_new_owner_party_type;
1328: Close c_hz_parties_info;
1329:
1330: -- get relationship type and code from custom hook procedure
1331: l_tca_rel_in_params.instance_id := p_instance_id;
1332: l_tca_rel_in_params.new_owner_party_id := p_new_owner_party_id;

Line 1344: -- Assumption: the owners will always be from hz_parties

1340: RAISE FND_API.G_EXC_ERROR;
1341: end if;
1342:
1343: -- populate the relationship rec before calling API
1344: -- Assumption: the owners will always be from hz_parties
1345: l_relationship_rec.subject_id := p_new_owner_party_id;
1346: l_relationship_rec.subject_type := l_new_owner_party_type;
1347: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1348: l_relationship_rec.object_id := p_current_owner_party_id;

Line 1347: l_relationship_rec.subject_table_name := 'HZ_PARTIES';

1343: -- populate the relationship rec before calling API
1344: -- Assumption: the owners will always be from hz_parties
1345: l_relationship_rec.subject_id := p_new_owner_party_id;
1346: l_relationship_rec.subject_type := l_new_owner_party_type;
1347: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1348: l_relationship_rec.object_id := p_current_owner_party_id;
1349: l_relationship_rec.object_type := l_current_owner_party_type;
1350: l_relationship_rec.object_table_name := 'HZ_PARTIES';
1351: l_relationship_rec.relationship_code := l_tca_rel_out_params.relationship_code;

Line 1350: l_relationship_rec.object_table_name := 'HZ_PARTIES';

1346: l_relationship_rec.subject_type := l_new_owner_party_type;
1347: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1348: l_relationship_rec.object_id := p_current_owner_party_id;
1349: l_relationship_rec.object_type := l_current_owner_party_type;
1350: l_relationship_rec.object_table_name := 'HZ_PARTIES';
1351: l_relationship_rec.relationship_code := l_tca_rel_out_params.relationship_code;
1352: l_relationship_rec.relationship_type := l_tca_rel_out_params.relationship_type;
1353: l_relationship_rec.start_date := SYSDATE;
1354: l_relationship_rec.created_by_module := 'CSDSR';

Line 1409: l_party_tbl(1).party_source_table := 'HZ_PARTIES';

1405: l_instance_rec.object_version_number := l_object_version_number;
1406:
1407: l_party_tbl(1).instance_party_id := l_csiip_inst_party_id;
1408: l_party_tbl(1).instance_id := p_instance_id;
1409: l_party_tbl(1).party_source_table := 'HZ_PARTIES';
1410: l_party_tbl(1).party_id := p_new_owner_party_id;
1411: l_party_tbl(1).relationship_type_code := 'OWNER';
1412: l_party_tbl(1).contact_flag := 'N';
1413: l_party_tbl(1).object_version_number := l_csiip_obj_ver_num;