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.PV_SLSTEAM_MIGRTN_PVT dependencies on PV_ACCESS_MIGRATION_LOG

Line 77: INSERT INTO pv_access_migration_log

73: BEGIN
74:
75: /* Deleting records in as_accesses_all where partner_customer_id has partner's organization id */
76:
77: INSERT INTO pv_access_migration_log
78: (
79: access_migration_log_id
80: ,access_id
81: ,action

Line 91: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

87: ,lead_id
88: ,org_id
89: ,open_flag
90: )
91: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
92: z.access_id,
93: 'DELTE_CORRUPT_PF_PARTNER',
94: sysdate,
95: z.customer_id,

Line 146: FROM pv_access_migration_log

142: -- Deleting the corrupted preferred partners
143: -- ----------------------------------------------------------
144: DELETE FROM as_accesses_all
145: WHERE access_id IN ( SELECT access_id
146: FROM pv_access_migration_log
147: WHERE action = 'DELTE_CORRUPT_PF_PARTNER');
148: /*
149: *
150: * Logging the delete activity of corrupted partners

Line 153: INSERT INTO pv_access_migration_log

149: *
150: * Logging the delete activity of corrupted partners
151: */
152:
153: INSERT INTO pv_access_migration_log
154: (
155: access_migration_log_id
156: ,access_id
157: ,action

Line 168: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

164: ,lead_id
165: ,org_id
166: ,open_flag
167: )
168: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
169: access_id,
170: 'DELETE_CORRUPT_OPP_PARTNER',
171: sysdate,
172: customer_id,

Line 206: INSERT INTO pv_access_migration_log

202: AND a.lead_id IS NOT NULL
203: AND a.partner_cont_party_id IS NULL);
204:
205:
206: INSERT INTO pv_access_migration_log
207: (
208: access_migration_log_id
209: ,access_id
210: ,action

Line 221: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

217: ,sales_lead_id
218: ,org_id
219: ,open_flag
220: )
221: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
222: access_id,
223: 'DELETE_CORRUPT_LEAD_PARTNER',
224: sysdate,
225: customer_id,

Line 259: INSERT INTO pv_access_migration_log

255: AND a.sales_lead_id is not null
256: AND a.partner_cont_party_id IS NULL);
257:
258:
259: INSERT INTO pv_access_migration_log
260: (
261: access_migration_log_id
262: ,access_id
263: ,action

Line 273: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

269: ,partner_address_id
270: ,org_id
271: ,open_flag
272: )
273: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
274: access_id,
275: 'DELETE_CORRUPT_CUST_PARTNER',
276: sysdate,
277: customer_id,

Line 313: FROM pv_access_migration_log

309: -- Deleting the corrupted partners
310: -- ----------------------------------------------------------
311: DELETE FROM as_accesses_all
312: WHERE access_id IN ( SELECT access_id
313: FROM pv_access_migration_log
314: WHERE action IN ('DELETE_CORRUPT_CUST_PARTNER','DELETE_CORRUPT_LEAD_PARTNER','DELETE_CORRUPT_OPP_PARTNER'));
315: EXCEPTION
316: WHEN OTHERS THEN
317: printOutput('Database Error in deleting from logs : '||sqlerrm);

Line 326: DELETE FROM pv_access_migration_log;

322: PROCEDURE clean_log
323: IS
324:
325: BEGIN
326: DELETE FROM pv_access_migration_log;
327: EXCEPTION
328: WHEN OTHERS THEN
329: printOutput('Database Error in deleting from logs : '||sqlerrm);
330: g_ret_code := 2;

Line 343: INSERT INTO pv_access_migration_log

339: IS
340:
341: BEGIN
342: BEGIN
343: INSERT INTO pv_access_migration_log
344: (
345: access_migration_log_id
346: ,access_id
347: ,action

Line 370: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

366: ,created_by_tap_flag
367: ,prm_keep_flag
368: ,open_flag
369: )
370: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
371: as_accesses_s.nextval access_id,
372: 'INSERT_CUST_PARTY' action,
373: sysdate creation_date,
374: 'X' access_type ,

Line 498: FROM pv_access_migration_log

494: created_by_tap_flag,
495: prm_keep_flag,
496: open_flag,
497: NULL
498: FROM pv_access_migration_log
499: WHERE action = 'INSERT_CUST_PARTY';
500: EXCEPTION
501: WHEN OTHERS THEN
502: ROLLBACK;

Line 513: INSERT INTO pv_access_migration_log

509: IS
510:
511: BEGIN
512: BEGIN
513: INSERT INTO pv_access_migration_log
514: (
515: access_migration_log_id
516: ,access_id
517: ,action

Line 540: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

536: ,created_by_tap_flag
537: ,prm_keep_flag
538: ,open_flag
539: )
540: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
541: as_accesses_s.nextval access_id,
542: 'INSERT_LEAD_PARTY' action,
543: sysdate creation_date,
544: 'X' access_type ,

Line 669: FROM pv_access_migration_log

665: created_by_tap_flag,
666: prm_keep_flag,
667: open_flag,
668: NULL
669: FROM pv_access_migration_log
670: WHERE action = 'INSERT_LEAD_PARTY';
671: EXCEPTION
672: WHEN OTHERS THEN
673: ROLLBACK;

Line 690: INSERT INTO pv_access_migration_log

686: IS
687:
688: BEGIN
689: BEGIN
690: INSERT INTO pv_access_migration_log
691: (
692: access_migration_log_id
693: ,access_id
694: ,action

Line 717: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

713: ,created_by_tap_flag
714: ,prm_keep_flag
715: ,open_flag
716: )
717: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
718: as_accesses_s.nextval access_id,
719: 'INSERT_OPP_PARTY' action,
720: sysdate creation_date,
721: 'X' access_type ,

Line 861: FROM pv_access_migration_log

857: created_by_tap_flag,
858: prm_keep_flag,
859: open_flag,
860: NULL
861: FROM pv_access_migration_log
862: WHERE action = 'INSERT_OPP_PARTY';
863: EXCEPTION
864: WHEN OTHERS THEN
865: ROLLBACK;

Line 880: INSERT INTO pv_access_migration_log

876: IS
877: l_lead_id number;
878: BEGIN
879: BEGIN
880: INSERT INTO pv_access_migration_log
881: (
882: access_migration_log_id
883: ,access_id
884: ,action

Line 907: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

903: ,created_by_tap_flag
904: ,prm_keep_flag
905: ,open_flag
906: )
907: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
908: as_accesses_s.nextval access_id,
909: 'INSERT_OPP_PRFRD_PT' action,
910: sysdate creation_date,
911: 'X' access_type ,

Line 1024: FROM pv_access_migration_log

1020: created_by_tap_flag,
1021: prm_keep_flag,
1022: open_flag,
1023: NULL
1024: FROM pv_access_migration_log
1025: WHERE action = 'INSERT_OPP_PRFRD_PT';
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: ROLLBACK;

Line 1041: INSERT INTO pv_access_migration_log

1037: IS
1038: BEGIN
1039:
1040: BEGIN
1041: INSERT INTO pv_access_migration_log
1042: (
1043: access_migration_log_id
1044: ,access_id
1045: ,action

Line 1068: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

1064: ,created_by_tap_flag
1065: ,prm_keep_flag
1066: ,open_flag
1067: )
1068: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
1069: as_accesses_s.nextval access_id,
1070: 'INSERT_OPP_SAVED_PT' action,
1071: sysdate creation_date,
1072: 'X' access_type ,

Line 1176: FROM pv_access_migration_log

1172: created_by_tap_flag,
1173: prm_keep_flag,
1174: open_flag,
1175: NULL
1176: FROM pv_access_migration_log
1177: WHERE action = 'INSERT_OPP_SAVED_PT';
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: ROLLBACK;

Line 1191: INSERT INTO pv_access_migration_log

1187: IS
1188: BEGIN
1189:
1190: BEGIN
1191: INSERT INTO pv_access_migration_log
1192: (
1193: access_migration_log_id
1194: ,access_id
1195: ,action

Line 1218: SELECT pv_access_migration_log_s.nextval access_migration_log_id,

1214: ,created_by_tap_flag
1215: ,prm_keep_flag
1216: ,open_flag
1217: )
1218: SELECT pv_access_migration_log_s.nextval access_migration_log_id,
1219: as_accesses_s.nextval access_id,
1220: 'INSERT_OPP_ASSIGNED_PT' action,
1221: sysdate creation_date,
1222: 'X' access_type ,

Line 1323: FROM pv_access_migration_log

1319: created_by_tap_flag,
1320: prm_keep_flag,
1321: open_flag,
1322: NULL
1323: FROM pv_access_migration_log
1324: WHERE action = 'INSERT_OPP_ASSIGNED_PT';
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: ROLLBACK;

Line 1374: FROM pv_access_migration_log

1370: printOutput(RPAD(' ',120,' '));
1371: BEGIN
1372: SELECT count(action)
1373: INTO l_count
1374: FROM pv_access_migration_log
1375: WHERE action = 'DELTE_CORRUPT_PF_PARTNER';
1376:
1377: fnd_message.set_name('PV','PV_DEL_CRPT_PF_PT');
1378: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1388: from pv_access_migration_log a,

1384: ( select distinct asl.description entity,
1385: asl.lead_number entity_id,
1386: b.party_name ,
1387: a.salesforce_id
1388: from pv_access_migration_log a,
1389: hz_parties b,
1390: pv_partner_profiles pvpp ,
1391: as_leads_all asl
1392: where a.partner_customer_id = pvpp.partner_id

Line 1434: FROM pv_access_migration_log

1430: printOutput(RPAD(' ',120,' '));
1431: BEGIN
1432: SELECT count(action)
1433: INTO l_count
1434: FROM pv_access_migration_log
1435: WHERE action = 'DELETE_CORRUPT_CUST_PARTNER';
1436:
1437: fnd_message.set_name('PV','PV_DEL_CUR_CUST_ESLSTM');
1438: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1446: from pv_access_migration_log a,

1442: IF l_count > 0 THEN
1443: FOR x in
1444: ( select d.party_name entity, d.party_number entity_id,
1445: b.party_name , a.salesforce_id
1446: from pv_access_migration_log a,
1447: hz_parties b,
1448: pv_partner_profiles pvpp ,
1449: hz_parties d
1450: where a.partner_customer_id = pvpp.partner_party_id

Line 1494: FROM pv_access_migration_log

1490: BEGIN
1491:
1492: SELECT count(action)
1493: INTO l_count
1494: FROM pv_access_migration_log
1495: WHERE action = 'DELETE_CORRUPT_LEAD_PARTNER';
1496:
1497: fnd_message.set_name('PV','PV_DEL_PTR_LEAD_ESLSTM');
1498: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1506: from pv_access_migration_log a,

1502: IF l_count > 0 THEN
1503: FOR x in
1504: ( select asl.description entity, asl.lead_number entity_id,
1505: b.party_name , a.salesforce_id
1506: from pv_access_migration_log a,
1507: hz_parties b,
1508: pv_partner_profiles pvpp ,
1509: as_sales_leads asl
1510: where a.partner_customer_id = pvpp.partner_party_id

Line 1555: FROM pv_access_migration_log

1551:
1552: BEGIN
1553: SELECT count(action)
1554: INTO l_count
1555: FROM pv_access_migration_log
1556: WHERE action = 'DELETE_CORRUPT_OPP_PARTNER';
1557:
1558: fnd_message.set_name('PV','PV_DEL_PTR_OPP_ESLSTM');
1559: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1572: from pv_access_migration_log a,

1568: ( select distinct asl.description entity,
1569: asl.lead_number entity_id,
1570: b.party_name ,
1571: a.salesforce_id
1572: from pv_access_migration_log a,
1573: hz_parties b,
1574: pv_partner_profiles pvpp ,
1575: as_leads_all asl
1576: where a.partner_customer_id = pvpp.partner_party_id

Line 1621: FROM pv_access_migration_log

1617:
1618: BEGIN
1619: SELECT count(action)
1620: INTO l_count
1621: FROM pv_access_migration_log
1622: WHERE action = 'INSERT_CUST_PARTY';
1623:
1624: fnd_message.set_name('PV','PV_INS_PTR_CUST_ESLSTM');
1625: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1633: from pv_access_migration_log a,

1629: IF l_count > 0 THEN
1630: FOR x in
1631: ( select d.party_name entity, d.party_number entity_id,
1632: b.party_name , a.salesforce_id
1633: from pv_access_migration_log a,
1634: hz_parties b,
1635: pv_partner_profiles pvpp ,
1636: hz_parties d
1637: where a.partner_customer_id = pvpp.partner_id

Line 1681: FROM pv_access_migration_log

1677: BEGIN
1678:
1679: SELECT count(action)
1680: INTO l_count
1681: FROM pv_access_migration_log
1682: WHERE action = 'INSERT_LEAD_PARTY';
1683:
1684: fnd_message.set_name('PV','PV_INS_PTR_LEAD_ESLSTM');
1685: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1693: from pv_access_migration_log a,

1689: IF l_count > 0 THEN
1690: FOR x in
1691: ( select asl.description entity, asl.lead_number entity_id,
1692: b.party_name , a.salesforce_id
1693: from pv_access_migration_log a,
1694: hz_parties b,
1695: pv_partner_profiles pvpp ,
1696: as_sales_leads asl
1697: where a.partner_customer_id = pvpp.partner_id

Line 1742: FROM pv_access_migration_log

1738:
1739: BEGIN
1740: SELECT count(action)
1741: INTO l_count
1742: FROM pv_access_migration_log
1743: WHERE action IN ('INSERT_OPP_PARTY','INSERT_OPP_PRFRD_PT','INSERT_OPP_SAVED_PT','INSERT_OPP_ASSIGNED_PT');
1744:
1745: fnd_message.set_name('PV','PV_INS_PTR_OPP_ESLSTM');
1746: l_temp_msg := fnd_message.get ||' '||l_count;

Line 1759: from pv_access_migration_log a,

1755: ( select distinct asl.description entity,
1756: asl.lead_number entity_id,
1757: b.party_name ,
1758: a.salesforce_id
1759: from pv_access_migration_log a,
1760: hz_parties b,
1761: pv_partner_profiles pvpp ,
1762: as_leads_all asl
1763: where a.partner_customer_id = pvpp.partner_id