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.AS_GAR_LEADS_PUB dependencies on AS_ACCESSES_ALL

Line 15: -- 2: Merge and insert records from winners into AS_ACCESSES_ALL_ALL

11: -- This package contains procedures to accomplish each of the following
12: -- tasks:
13: -- 1: Call the JTY API to process data from JTY trans tables and
14: -- populate JTY winners.
15: -- 2: Merge and insert records from winners into AS_ACCESSES_ALL_ALL
16: -- 3: Soft Delete unwanted records from AS_ACCESSES_ALL_ALL
17: -- 4: Lead Owner Assignment
18: --
19: ---------------------------------------------------------------------------

Line 16: -- 3: Soft Delete unwanted records from AS_ACCESSES_ALL_ALL

12: -- tasks:
13: -- 1: Call the JTY API to process data from JTY trans tables and
14: -- populate JTY winners.
15: -- 2: Merge and insert records from winners into AS_ACCESSES_ALL_ALL
16: -- 3: Soft Delete unwanted records from AS_ACCESSES_ALL_ALL
17: -- 4: Lead Owner Assignment
18: --
19: ---------------------------------------------------------------------------
20: /*-------------------------------------------------------------------------+

Line 737: FROM AS_ACCESSES_ALL_ALL A,

733: SELECT /*+ LEADING(WIN) USE_NL(A WIN) INDEX(A) */ A.sales_lead_id,
734: A.salesforce_id,
735: A.sales_group_id,
736: NVL(WIN.full_access_flag,'N')
737: FROM AS_ACCESSES_ALL_ALL A,
738: JTF_TAE_1001_LEAD_WINNERS WIN
739: WHERE A.lead_id is NULL
740: AND A.sales_lead_id is NOT NULL
741: AND A.delete_flag is NULL

Line 800: UPDATE AS_ACCESSES_ALL_ALL ACC

796: END IF;
797: WHILE l_attempts < 3 LOOP
798: BEGIN
799: FORALL i IN l_first .. l_last
800: UPDATE AS_ACCESSES_ALL_ALL ACC
801: SET object_version_number = NVL(object_version_number,0) + 1,
802: ACC.last_update_date = SYSDATE,
803: ACC.last_updated_by = p_terr_globals.user_id,
804: ACC.last_update_login = p_terr_globals.last_update_login,

Line 828: UPDATE AS_ACCESSES_ALL_ALL ACC

824: IF l_attempts = 3 THEN
825: FOR i IN l_first .. l_last
826: LOOP
827: BEGIN
828: UPDATE AS_ACCESSES_ALL_ALL ACC
829: SET object_version_number = NVL(object_version_number,0) + 1,
830: ACC.last_update_date = SYSDATE,
831: ACC.last_updated_by = p_terr_globals.user_id,
832: ACC.last_update_login = p_terr_globals.last_update_login,

Line 988: INSERT INTO AS_ACCESSES_ALL_ALL

984: END IF;
985: BEGIN
986: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' to '||l_last);
987: FORALL i IN l_first .. l_last
988: INSERT INTO AS_ACCESSES_ALL_ALL
989: ( access_id
990: ,access_type
991: ,salesforce_id
992: ,sales_group_id

Line 1047: FROM AS_ACCESSES_ALL_ALL AA

1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1044: WHERE L.sales_lead_id = l_sales_lead_id(i)
1045: AND L.status_code = STS.status_code
1046: AND NOT EXISTS ( SELECT 'X'
1047: FROM AS_ACCESSES_ALL_ALL AA
1048: WHERE AA.sales_lead_id IS NOT NULL
1049: AND AA.lead_id IS NULL
1050: AND AA.delete_flag IS NULL
1051: AND AA.sales_lead_id = l_sales_lead_id(i)

Line 1063: INSERT INTO AS_ACCESSES_ALL_ALL

1059: WHEN DUP_VAL_ON_INDEX THEN
1060: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1061: FOR i IN l_first .. l_last LOOP
1062: BEGIN
1063: INSERT INTO AS_ACCESSES_ALL_ALL
1064: ( access_id
1065: ,access_type
1066: ,salesforce_id
1067: ,sales_group_id

Line 1122: FROM AS_ACCESSES_ALL_ALL AA

1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1119: WHERE L.sales_lead_id = l_sales_lead_id(i)
1120: AND L.status_code = STS.status_code
1121: AND NOT EXISTS ( SELECT 'X'
1122: FROM AS_ACCESSES_ALL_ALL AA
1123: WHERE AA.sales_lead_id IS NOT NULL
1124: AND AA.lead_id IS NULL
1125: AND AA.delete_flag IS NULL
1126: AND AA.sales_lead_id = l_sales_lead_id(i)

Line 1287: FROM AS_ACCESSES_ALL_ALL A

1283: p_terr_globals.prog_id,
1284: SYSDATE
1285: FROM
1286: ( SELECT DISTINCT A.access_id acc_id
1287: FROM AS_ACCESSES_ALL_ALL A
1288: WHERE A.sales_lead_id=l_sales_lead_id(i)
1289: AND A.sales_group_id = l_sales_group_id(i)
1290: AND A.salesforce_id=l_salesforce_id(i)
1291: AND A.sales_lead_id is NOT NULL

Line 1338: FROM AS_ACCESSES_ALL_ALL A

1334: p_terr_globals.prog_id,
1335: SYSDATE
1336: FROM
1337: ( SELECT DISTINCT a.access_id acc_id
1338: FROM AS_ACCESSES_ALL_ALL A
1339: WHERE A.sales_lead_id=l_sales_lead_id(i)
1340: AND A.sales_group_id = l_sales_group_id(i)
1341: AND A.salesforce_id=l_salesforce_id(i)
1342: AND A.sales_lead_id is NOT NULL

Line 1502: UPDATE AS_ACCESSES_ALL_ALL ACC

1498: WHILE l_attempts < 3 LOOP --{L4
1499: BEGIN
1500: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_START);
1501: FORALL i in l_first..l_last
1502: UPDATE AS_ACCESSES_ALL_ALL ACC
1503: SET object_version_number = NVL(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
1504: WHERE ACC.sales_lead_id=l_sales_lead_id(i)
1505: AND ACC.freeze_flag = 'N'
1506: AND ACC.lead_id IS NULL

Line 1524: DELETE FROM AS_ACCESSES_ALL_ALL ACC

1520: WHEN DUP_VAL_ON_INDEX THEN
1521: BEGIN
1522: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL || AS_GAR.G_START);
1523: FORALL i in l_first..l_last
1524: DELETE FROM AS_ACCESSES_ALL_ALL ACC
1525: WHERE ACC.sales_lead_id=l_sales_lead_id(i)
1526: AND ACC.freeze_flag = 'N'
1527: AND ACC.lead_id IS NULL
1528: AND ACC.sales_lead_id IS NOT NULL

Line 1552: UPDATE AS_ACCESSES_ALL_ALL ACC

1548: IF l_attempts = 3 THEN
1549: FOR i IN l_first .. l_last LOOP --{L5
1550: BEGIN
1551: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_UPD || AS_GAR.G_START);
1552: UPDATE AS_ACCESSES_ALL_ALL ACC
1553: SET object_version_number = NVL(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
1554: WHERE ACC.sales_lead_id = l_sales_lead_id(i)
1555: AND ACC.freeze_flag = 'N'
1556: AND ACC.lead_id IS NULL

Line 1570: DELETE FROM AS_ACCESSES_ALL_ALL ACC

1566: EXCEPTION
1567: WHEN DUP_VAL_ON_INDEX THEN
1568: BEGIN
1569: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);
1570: DELETE FROM AS_ACCESSES_ALL_ALL ACC
1571: WHERE ACC.sales_lead_id=l_sales_lead_id(i)
1572: AND ACC.freeze_flag = 'N'
1573: AND ACC.lead_id IS NULL
1574: AND ACC.sales_lead_id IS NOT NULL

Line 1650: FROM AS_ACCESSES_ALL_ALL aaa,

1646:
1647: CURSOR lead_owner_totalmode(c_worker_id number) IS
1648: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1649: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1650: FROM AS_ACCESSES_ALL_ALL aaa,
1651: ( SELECT distinct trans_object_id
1652: FROM JTF_TAE_1001_LEAD_TRANS
1653: WHERE worker_id=c_worker_id ) w
1654: WHERE aaa.lead_id is NULL

Line 1668: FROM AS_ACCESSES_ALL aaa

1664: FROM JTF_TAE_1001_LEAD_TRANS w
1665: WHERE worker_id = c_worker_id
1666: AND NOT EXISTS
1667: (SELECT 'x'
1668: FROM AS_ACCESSES_ALL aaa
1669: WHERE aaa.sales_lead_id =w.trans_object_id
1670: AND (aaa.CREATED_BY_TAP_FLAG = 'Y'
1671: OR aaa.owner_flag='Y'));
1672:

Line 1677: FROM AS_ACCESSES_ALL_ALL aaa,

1673:
1674: CURSOR lead_owner_newmode(c_worker_id number) IS
1675: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1676: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1677: FROM AS_ACCESSES_ALL_ALL aaa,
1678: ( SELECT distinct trans_object_id
1679: FROM JTF_TAE_1001_LEAD_NM_TRANS
1680: WHERE worker_id=c_worker_id ) w
1681: WHERE aaa.lead_id is null

Line 1694: FROM AS_ACCESSES_ALL aaa

1690: FROM JTF_TAE_1001_LEAD_NM_TRANS w
1691: WHERE worker_id = c_worker_id
1692: AND NOT EXISTS
1693: (SELECT 'x'
1694: FROM AS_ACCESSES_ALL aaa
1695: WHERE aaa.sales_lead_id =w.trans_object_id
1696: AND (aaa.CREATED_BY_TAP_FLAG = 'Y'
1697: OR aaa.owner_flag='Y'));
1698:

Line 1785: FROM as_accesses_all_all

1781: sl.assign_sales_group_id,
1782: sl.assign_to_person_id
1783: ) =
1784: ( SELECT salesforce_id,sales_group_id,person_id
1785: FROM as_accesses_all_all
1786: WHERE access_id = l_access_id(i)
1787: )
1788: WHERE sl.sales_lead_id = l_sales_lead_id(i) ;
1789: COMMIT;

Line 1814: FROM as_accesses_all_all

1810: sl.assign_sales_group_id,
1811: sl.assign_to_person_id
1812: ) =
1813: ( SELECT salesforce_id,sales_group_id,person_id
1814: FROM as_accesses_all_all
1815: WHERE access_id = l_access_id(i)
1816: )
1817: WHERE sl.sales_lead_id = l_sales_lead_id(i) ;
1818: EXCEPTION

Line 1840: UPDATE AS_ACCESSES_ALL_ALL ACC SET object_version_number = NVL(object_version_number,0) + 1,

1836: l_attempts := 1;
1837: WHILE l_attempts < 3 LOOP
1838: BEGIN
1839: FORALL i in l_first .. l_last
1840: UPDATE AS_ACCESSES_ALL_ALL ACC SET object_version_number = NVL(object_version_number,0) + 1,
1841: ACC.LAST_UPDATE_DATE = SYSDATE,
1842: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
1843: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,
1844: ACC.REQUEST_ID = p_terr_globals.request_id,

Line 1862: UPDATE AS_ACCESSES_ALL_ALL ACC SET object_version_number = NVL(object_version_number,0) + 1,

1858: ROLLBACK;
1859: IF l_attempts = 3 THEN
1860: FOR i IN l_first .. l_last LOOP
1861: BEGIN
1862: UPDATE AS_ACCESSES_ALL_ALL ACC SET object_version_number = NVL(object_version_number,0) + 1,
1863: ACC.LAST_UPDATE_DATE = SYSDATE,
1864: ACC.LAST_UPDATED_BY = p_terr_globals.user_id,
1865: ACC.LAST_UPDATE_LOGIN = p_terr_globals.last_update_login,
1866: ACC.REQUEST_ID = p_terr_globals.request_id,