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.JTF_RS_PARTY_MERGE_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 41: from jtf_rs_resource_extns

37: , creation_date
38: , last_updated_by
39: , last_update_date
40: , last_update_login
41: from jtf_rs_resource_extns
42: where source_id = l_source_id
43: and category IN ('PARTY','PARTNER') ;
44:
45: cursor to_party_cur(l_party_id number)

Line 48: from jtf_rs_resource_extns

44:
45: cursor to_party_cur(l_party_id number)
46: is
47: select resource_id
48: from jtf_rs_resource_extns
49: where category = 'PARTY'
50: and source_id = l_party_id;
51:
52: to_party_rec to_party_cur%rowtype;

Line 57: from jtf_rs_resource_extns

53:
54: cursor to_partner_cur(l_party_id number)
55: is
56: select resource_id
57: from jtf_rs_resource_extns
58: where category = 'PARTNER'
59: and source_id = l_party_id;
60:
61: to_partner_rec to_partner_cur%rowtype;

Line 124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')

120: -----End Debug Messages----------------
121:
122: x_return_status := fnd_api.g_ret_sts_success;
123:
124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
125: or (p_parent_entity_name <> 'HZ_PARTIES')
126: then
127: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
128: fnd_message.set_token('P_ENTITY',p_entity_name);

Line 205: update jtf_rs_resource_extns

201: fetch party_addr_cur into l_address_id;
202: close party_addr_cur;
203:
204: -- update from record with new source id
205: update jtf_rs_resource_extns
206: set source_id = p_to_fk_id,
207: address_id = l_address_id,
208: object_version_number = object_version_number + 1
209: where resource_id = cat_rec.resource_id;

Line 365: update jtf_rs_resource_extns

361: l_address_id := cat_rec.address_id;
362: end if;
363:
364: -- update from record with new source id
365: update jtf_rs_resource_extns
366: set source_id = p_to_fk_id,
367: address_id = l_address_id,
368: object_version_number = object_version_number + 1
369: where resource_id = cat_rec.resource_id;

Line 496: from jtf_rs_resource_extns

492: , creation_date
493: , last_updated_by
494: , last_update_date
495: , last_update_login
496: from jtf_rs_resource_extns
497: where address_id = l_address_id
498: and category = 'PARTNER';
499:
500: cursor to_cur(l_source_id number,

Line 504: from jtf_rs_resource_extns

500: cursor to_cur(l_source_id number,
501: l_address_id number)
502: is
503: select resource_id
504: from jtf_rs_resource_extns
505: where category = 'PARTNER'
506: and source_id = l_source_id
507: and address_id = l_address_id ;
508:

Line 547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')

543: -----End Debug Messages----------------
544:
545: x_return_status := fnd_api.g_ret_sts_success;
546:
547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
549: then
550: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
551: fnd_message.set_token('P_ENTITY',p_entity_name);

Line 624: update jtf_rs_resource_extns

620: END IF;
621: ----------------------------------------------------
622: else
623: --if another resource does not exist change the same resource to have the new address id
624: update jtf_rs_resource_extns
625: set address_id = p_to_fk_id,
626: object_version_number = object_version_number + 1
627: where resource_id = from_rec.resource_id;
628: -- x_to_id := p_from_id;

Line 716: from jtf_rs_resource_extns

712: select resource_id,
713: source_id,
714: address_id,
715: object_version_number
716: from jtf_rs_resource_extns
717: where contact_id = l_contact_id
718: and category IN ('PARTY','PARTNER') ;
719:
720: cursor cont_cur(l_party_id number,

Line 755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')

751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
753: -----End Debug Messages----------------
754:
755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
756: or (p_parent_entity_name <> 'HZ_ORG_CONTACTS')
757: then
758: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
759: fnd_message.set_token('P_ENTITY',p_entity_name);

Line 780: update jtf_rs_resource_extns

776: x_return_status := fnd_api.g_ret_sts_error;
777: RAISE fnd_api.g_exc_error;
778: else
779: */
780: update jtf_rs_resource_extns
781: set contact_id = p_to_fk_id,
782: object_version_number = object_version_number + 1
783: where resource_id = res_rec.resource_id;
784:

Line 1030: UPDATE JTF_RS_RESOURCE_EXTNS RES

1026: fetch party_cur into party_rec;
1027: if (party_cur%found)
1028: then
1029:
1030: UPDATE JTF_RS_RESOURCE_EXTNS RES
1031: SET RES.OBJECT_VERSION_NUMBER = res.object_version_number + 1 ,
1032: RES.LAST_UPDATE_DATE = sysdate,
1033: RES.LAST_UPDATED_BY = fnd_global.user_id,
1034: RES.SOURCE_NUMBER = party_rec.party_number ,

Line 1066: UPDATE JTF_RS_RESOURCE_EXTNS RES

1062: open par_cur;
1063: fetch par_cur into par_rec;
1064: if (par_cur%found)
1065: then
1066: UPDATE JTF_RS_RESOURCE_EXTNS RES
1067: SET RES.OBJECT_VERSION_NUMBER = res.object_version_number + 1 ,
1068: RES.LAST_UPDATE_DATE = sysdate,
1069: RES.LAST_UPDATED_BY = fnd_global.user_id,
1070: RES.SOURCE_NUMBER = par_rec.party_number ,

Line 1100: UPDATE JTF_RS_RESOURCE_EXTNS RES

1096: open par_address_cur;
1097: fetch par_address_cur into par_address_rec;
1098: if (par_address_cur%found)
1099: then
1100: UPDATE JTF_RS_RESOURCE_EXTNS RES
1101: SET RES.OBJECT_VERSION_NUMBER = res.object_version_number + 1 ,
1102: RES.LAST_UPDATE_DATE = sysdate,
1103: RES.LAST_UPDATED_BY = fnd_global.user_id,
1104: RES.SOURCE_NUMBER = par_address_rec.party_number ,

Line 1134: update jtf_rs_resource_extns_tl res

1130: end if; -- end of address_id check
1131:
1132: end if; -- end of category check
1133:
1134: update jtf_rs_resource_extns_tl res
1135: set resource_name
1136: = (select party_name
1137: from hz_parties
1138: where party_id = p_source_id)

Line 1181: from jtf_rs_resource_extns

1177: is
1178: select resource_id,
1179: source_id,
1180: object_version_number
1181: from jtf_rs_resource_extns
1182: where support_site_id = c_support_site_id;
1183:
1184: --cursor support_site_cur(c_support_site_id number)
1185: --is

Line 1218: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')

1214: l_date := sysdate;
1215: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1216: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1217:
1218: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
1220: then
1221: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
1222: fnd_message.set_token('P_ENTITY',p_entity_name);

Line 1237: update jtf_rs_resource_extns

1233: -- FND_MSG_PUB.add;
1234: -- x_return_status := fnd_api.g_ret_sts_error;
1235: -- RAISE fnd_api.g_exc_error;
1236: -- else
1237: update jtf_rs_resource_extns
1238: set support_site_id = p_to_fk_id,
1239: object_version_number = object_version_number + 1
1240: where resource_id = res_rec.resource_id;
1241: