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.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_EXTRACT_ORIG_SYS_REF_BO_PVT

Line 155: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

151: fetch account_merge_details into x_account_merge_obj;
152: close account_merge_details;
153:
154: -- SSM for merge-to acct party obj
155: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
156: (p_init_msg_list => fnd_api.g_false,
157: p_owner_table_id => x_account_merge_obj.merge_to_acct_party_obj.party_id,
158: p_owner_table_name => 'HZ_PARTIES',
159: p_action_type => NULL,

Line 170: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: -- SSM for merge-from acct party obj
170: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
171: (p_init_msg_list => fnd_api.g_false,
172: p_owner_table_id => x_account_merge_obj.merge_from_acct_party_obj.party_id,
173: p_owner_table_name => 'HZ_PARTIES',
174: p_action_type => NULL,

Line 184: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

180: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183: -- SSM for merge to account obj
184: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
185: (p_init_msg_list => fnd_api.g_false,
186: p_owner_table_id => x_account_merge_obj.merge_to_account_obj.cust_acct_id,
187: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
188: p_action_type => NULL,

Line 200: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

196: END IF;
197:
198: FOR I in 1..x_account_merge_obj.merge_from_account_objs.count LOOP
199:
200: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
201: (p_init_msg_list => fnd_api.g_false,
202: p_owner_table_id => x_account_merge_obj.merge_from_account_objs(I).cust_acct_id,
203: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
204: p_action_type => NULL,

Line 1052: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1048: OPEN account_merge_details;
1049: FETCH account_merge_details into x_account_merge_v2_obj;
1050: CLOSE account_merge_details;
1051: -- SSM for merge-to acct party obj
1052: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1053: (p_init_msg_list => fnd_api.g_false,
1054: p_owner_table_id => x_account_merge_v2_obj.merge_to_acct_party_obj.party_id,
1055: p_owner_table_name => 'HZ_PARTIES',
1056: p_action_type => NULL,

Line 1067: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1066: -- SSM for merge-from acct party obj
1067: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1068: (p_init_msg_list => fnd_api.g_false,
1069: p_owner_table_id => x_account_merge_v2_obj.merge_from_acct_party_obj.party_id,
1070: p_owner_table_name => 'HZ_PARTIES',
1071: p_action_type => NULL,

Line 1081: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1077: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080: -- SSM for merge to account obj
1081: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1082: (p_init_msg_list => fnd_api.g_false,
1083: p_owner_table_id => x_account_merge_v2_obj.merge_to_account_obj.cust_acct_id,
1084: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1085: p_action_type => NULL,

Line 1097: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1093: END IF;
1094:
1095: FOR I in 1..x_account_merge_v2_obj.merge_from_account_objs.count LOOP
1096:
1097: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1098: (p_init_msg_list => fnd_api.g_false,
1099: p_owner_table_id => x_account_merge_v2_obj.merge_from_account_objs(I).cust_acct_id,
1100: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1101: p_action_type => NULL,

Line 1137: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1133: WHERE cust_account_profile_id = x_account_merge_v2_obj.customer_profile_objs(I).from_object_id;
1134:
1135: IF l_site_use_id IS NOT NULL THEN
1136:
1137: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1138: (p_init_msg_list => fnd_api.g_false,
1139: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).from_parent_object_id,
1140: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
1141: p_action_type => NULL,

Line 1151: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150:
1151: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1152: (p_init_msg_list => fnd_api.g_false,
1153: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).to_parent_object_id,
1154: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
1155: p_action_type => NULL,

Line 1166: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164:
1165: ELSE
1166: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1167: (p_init_msg_list => fnd_api.g_false,
1168: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).from_parent_object_id,
1169: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1170: p_action_type => NULL,

Line 1180: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1181: (p_init_msg_list => fnd_api.g_false,
1182: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).to_parent_object_id,
1183: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1184: p_action_type => NULL,

Line 1210: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1206: WHERE cust_acct_profile_amt_id = x_account_merge_v2_obj.cust_profile_amt_objs(I).from_object_id;
1207:
1208: IF l_site_use_id IS NOT NULL THEN
1209:
1210: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1211: (p_init_msg_list => fnd_api.g_false,
1212: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).from_parent_object_id,
1213: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
1214: p_action_type => NULL,

Line 1224: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223:
1224: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1225: (p_init_msg_list => fnd_api.g_false,
1226: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).to_parent_object_id,
1227: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
1228: p_action_type => NULL,

Line 1239: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1235: RAISE FND_API.G_EXC_ERROR;
1236: END IF;
1237:
1238: ELSE
1239: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1240: (p_init_msg_list => fnd_api.g_false,
1241: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).from_parent_object_id,
1242: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1243: p_action_type => NULL,

Line 1253: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1249: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:
1253: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1254: (p_init_msg_list => fnd_api.g_false,
1255: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).to_parent_object_id,
1256: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1257: p_action_type => NULL,

Line 1276: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1272: CLOSE get_account_roles;
1273:
1274: FOR I in 1..x_account_merge_v2_obj.acct_role_objs.count LOOP
1275:
1276: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1277: (p_init_msg_list => fnd_api.g_false,
1278: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).from_object_id,
1279: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1280: p_action_type => NULL,

Line 1290: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289:
1290: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1291: (p_init_msg_list => fnd_api.g_false,
1292: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).to_object_id,
1293: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1294: p_action_type => NULL,

Line 1312: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1308: WHERE cust_account_role_id = x_account_merge_v2_obj.acct_role_objs(I).from_object_id;
1309:
1310: IF l_site_use_id IS NOT NULL THEN
1311:
1312: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1313: (p_init_msg_list => fnd_api.g_false,
1314: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).from_parent_object_id,
1315: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
1316: p_action_type => NULL,

Line 1326: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325:
1326: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1327: (p_init_msg_list => fnd_api.g_false,
1328: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).to_parent_object_id,
1329: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
1330: p_action_type => NULL,

Line 1341: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1337: RAISE FND_API.G_EXC_ERROR;
1338: END IF;
1339:
1340: ELSE
1341: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1342: (p_init_msg_list => fnd_api.g_false,
1343: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).from_parent_object_id,
1344: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1345: p_action_type => NULL,

Line 1355: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:
1355: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1356: (p_init_msg_list => fnd_api.g_false,
1357: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).to_parent_object_id,
1358: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1359: p_action_type => NULL,

Line 1816: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1812: close party_merge_details1;
1813: END IF;
1814:
1815: -- SSM for party obj
1816: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1817: (p_init_msg_list => fnd_api.g_false,
1818: p_owner_table_id => x_party_merge_obj.merge_to_party_obj.party_id,
1819: p_owner_table_name => 'HZ_PARTIES',
1820: p_action_type => NULL,

Line 1832: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos

1828: END IF;
1829:
1830: FOR I in 1..x_party_merge_obj.merge_from_party_objs.count LOOP
1831:
1832: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1833: (p_init_msg_list => fnd_api.g_false,
1834: p_owner_table_id => x_party_merge_obj.merge_from_party_objs(I).party_id,
1835: p_owner_table_name => 'HZ_PARTIES',
1836: p_action_type => NULL,