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 1288: -- Cursor to derive party information from hz_parties

1284: object_version_number
1285: from csi_ip_accounts
1286: where instance_party_id = p_instance_party_id;
1287:
1288: -- Cursor to derive party information from hz_parties
1289: Cursor c_hz_parties_info(p_party_id number) is
1290: Select party_type
1291: from hz_parties
1292: where party_id = p_party_id;

Line 1289: Cursor c_hz_parties_info(p_party_id number) is

1285: from csi_ip_accounts
1286: where instance_party_id = p_instance_party_id;
1287:
1288: -- Cursor to derive party information from hz_parties
1289: Cursor c_hz_parties_info(p_party_id number) is
1290: Select party_type
1291: from hz_parties
1292: where party_id = p_party_id;
1293:

Line 1291: from hz_parties

1287:
1288: -- Cursor to derive party information from hz_parties
1289: Cursor c_hz_parties_info(p_party_id number) is
1290: Select party_type
1291: from hz_parties
1292: where party_id = p_party_id;
1293:
1294: -- cursor to get the number of party relationships for the given criteria
1295: Cursor c_tca_rel_count(p_subject_id number, p_subject_type varchar2,

Line 1302: and subject_table_name = 'HZ_PARTIES'

1298: Select count(relationship_id)
1299: from hz_relationships
1300: where subject_id = p_subject_id
1301: and subject_type = p_subject_type
1302: and subject_table_name = 'HZ_PARTIES'
1303: and object_id = p_object_id
1304: and object_type = p_object_type
1305: and object_table_name = 'HZ_PARTIES'
1306: and relationship_code = p_relationship_code

Line 1305: and object_table_name = 'HZ_PARTIES'

1301: and subject_type = p_subject_type
1302: and subject_table_name = 'HZ_PARTIES'
1303: and object_id = p_object_id
1304: and object_type = p_object_type
1305: and object_table_name = 'HZ_PARTIES'
1306: and relationship_code = p_relationship_code
1307: and sysdate between nvl(start_date, sysdate-1)
1308: and nvl(end_date, sysdate+1);
1309:

Line 1338: Open c_hz_parties_info(p_current_owner_party_id);

1334: -- new owner, if desired
1335: if(p_create_tca_relation = fnd_api.g_true) then
1336:
1337: -- get info for original owner
1338: Open c_hz_parties_info(p_current_owner_party_id);
1339: Fetch c_hz_parties_info
1340: into l_current_owner_party_type;
1341: Close c_hz_parties_info;
1342:

Line 1339: Fetch c_hz_parties_info

1335: if(p_create_tca_relation = fnd_api.g_true) then
1336:
1337: -- get info for original owner
1338: Open c_hz_parties_info(p_current_owner_party_id);
1339: Fetch c_hz_parties_info
1340: into l_current_owner_party_type;
1341: Close c_hz_parties_info;
1342:
1343: -- get info for new owner

Line 1341: Close c_hz_parties_info;

1337: -- get info for original owner
1338: Open c_hz_parties_info(p_current_owner_party_id);
1339: Fetch c_hz_parties_info
1340: into l_current_owner_party_type;
1341: Close c_hz_parties_info;
1342:
1343: -- get info for new owner
1344: Open c_hz_parties_info(p_new_owner_party_id);
1345: Fetch c_hz_parties_info into l_new_owner_party_type;

Line 1344: Open c_hz_parties_info(p_new_owner_party_id);

1340: into l_current_owner_party_type;
1341: Close c_hz_parties_info;
1342:
1343: -- get info for new owner
1344: Open c_hz_parties_info(p_new_owner_party_id);
1345: Fetch c_hz_parties_info into l_new_owner_party_type;
1346: Close c_hz_parties_info;
1347:
1348: -- get relationship type and code from custom hook procedure

Line 1345: Fetch c_hz_parties_info into l_new_owner_party_type;

1341: Close c_hz_parties_info;
1342:
1343: -- get info for new owner
1344: Open c_hz_parties_info(p_new_owner_party_id);
1345: Fetch c_hz_parties_info into l_new_owner_party_type;
1346: Close c_hz_parties_info;
1347:
1348: -- get relationship type and code from custom hook procedure
1349: l_tca_rel_in_params.instance_id := p_instance_id;

Line 1346: Close c_hz_parties_info;

1342:
1343: -- get info for new owner
1344: Open c_hz_parties_info(p_new_owner_party_id);
1345: Fetch c_hz_parties_info into l_new_owner_party_type;
1346: Close c_hz_parties_info;
1347:
1348: -- get relationship type and code from custom hook procedure
1349: l_tca_rel_in_params.instance_id := p_instance_id;
1350: l_tca_rel_in_params.new_owner_party_id := p_new_owner_party_id;

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

1358: RAISE FND_API.G_EXC_ERROR;
1359: end if;
1360:
1361: -- populate the relationship rec before calling API
1362: -- Assumption: the owners will always be from hz_parties
1363: l_relationship_rec.subject_id := p_new_owner_party_id;
1364: l_relationship_rec.subject_type := l_new_owner_party_type;
1365: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1366: l_relationship_rec.object_id := p_current_owner_party_id;

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

1361: -- populate the relationship rec before calling API
1362: -- Assumption: the owners will always be from hz_parties
1363: l_relationship_rec.subject_id := p_new_owner_party_id;
1364: l_relationship_rec.subject_type := l_new_owner_party_type;
1365: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1366: l_relationship_rec.object_id := p_current_owner_party_id;
1367: l_relationship_rec.object_type := l_current_owner_party_type;
1368: l_relationship_rec.object_table_name := 'HZ_PARTIES';
1369: l_relationship_rec.relationship_code := l_tca_rel_out_params.relationship_code;

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

1364: l_relationship_rec.subject_type := l_new_owner_party_type;
1365: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
1366: l_relationship_rec.object_id := p_current_owner_party_id;
1367: l_relationship_rec.object_type := l_current_owner_party_type;
1368: l_relationship_rec.object_table_name := 'HZ_PARTIES';
1369: l_relationship_rec.relationship_code := l_tca_rel_out_params.relationship_code;
1370: l_relationship_rec.relationship_type := l_tca_rel_out_params.relationship_type;
1371: l_relationship_rec.start_date := SYSDATE;
1372: l_relationship_rec.created_by_module := 'CSDSR';

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

1423: l_instance_rec.object_version_number := l_object_version_number;
1424:
1425: l_party_tbl(1).instance_party_id := l_csiip_inst_party_id;
1426: l_party_tbl(1).instance_id := p_instance_id;
1427: l_party_tbl(1).party_source_table := 'HZ_PARTIES';
1428: l_party_tbl(1).party_id := p_new_owner_party_id;
1429: l_party_tbl(1).relationship_type_code := 'OWNER';
1430: l_party_tbl(1).contact_flag := 'N';
1431: l_party_tbl(1).object_version_number := l_csiip_obj_ver_num;

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

3767: l_party_tbl(1).party_id := p_sr_party_id;
3768: l_party_tbl(1).contact_flag := 'N';
3769: l_party_tbl(1).active_start_date := SYSDATE;
3770: l_party_tbl(1).relationship_type_code := p_relationship_type;
3771: l_party_tbl(1).party_source_table := 'HZ_PARTIES';
3772:
3773: l_txn_rec.transaction_id := NULL;
3774: l_txn_rec.transaction_date := SYSDATE;
3775: l_txn_rec.source_transaction_date := SYSDATE;