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_ACCOUNTS_PUB dependencies on AS_ACCESSES_ALL_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: --
18: -- NOTE: No Owner Assignment and Cleanup steps required for Accounts
19: -- 3-5-2007 annsrini included 2 cursors c_src and ins_acc. Also modified ins_acc2 cursor and INSERT_ACCESS_ACCOUNTS procedure to populate

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: --
18: -- NOTE: No Owner Assignment and Cleanup steps required for Accounts
19: -- 3-5-2007 annsrini included 2 cursors c_src and ins_acc. Also modified ins_acc2 cursor and INSERT_ACCESS_ACCOUNTS procedure to populate
20: -- salesforce_role_code into as_accesses_all table by fetching it from as_terr_resources_tmp table. fix for bug (5869095)

Line 782: FROM AS_ACCESSES_ALL_ALL A,

778: SELECT /*+ LEADING(WIN) */ A.customer_id, -- The use nested loop hint is removed in ACCOUNTS ONLY..
779: A.salesforce_id,
780: A.sales_group_id,
781: NVL(WIN.full_access_flag,'N')
782: FROM AS_ACCESSES_ALL_ALL A,
783: JTF_TAE_1001_ACCOUNT_WINNERS WIN
784: WHERE A.lead_id is NULL
785: AND A.delete_flag is NULL
786: AND A.sales_lead_id is NULL

Line 845: UPDATE AS_ACCESSES_ALL_ALL ACC

841: END IF;
842: WHILE l_attempts < 3 LOOP
843: BEGIN
844: FORALL i IN l_first .. l_last
845: UPDATE AS_ACCESSES_ALL_ALL ACC
846: SET object_version_number = NVL(object_version_number,0) + 1,
847: ACC.last_update_date = SYSDATE,
848: ACC.last_updated_by = p_terr_globals.user_id,
849: ACC.last_update_login = p_terr_globals.last_update_login,

Line 874: UPDATE AS_ACCESSES_ALL_ALL ACC

870: IF l_attempts = 3 THEN
871: FOR i IN l_first .. l_last
872: LOOP
873: BEGIN
874: UPDATE AS_ACCESSES_ALL_ALL ACC
875: SET object_version_number = NVL(object_version_number,0) + 1,
876: ACC.last_update_date = SYSDATE,
877: ACC.last_updated_by = p_terr_globals.user_id,
878: ACC.last_update_login = p_terr_globals.last_update_login,

Line 1118: INSERT INTO AS_ACCESSES_ALL_ALL

1114: END IF;
1115: BEGIN
1116: 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);
1117: FORALL i IN l_first .. l_last
1118: INSERT INTO AS_ACCESSES_ALL_ALL
1119: ( access_id
1120: ,access_type
1121: ,salesforce_id
1122: ,sales_group_id

Line 1167: FROM AS_ACCESSES_ALL_ALL AA

1163: ,'Y'
1164: ,l_org_id(i)
1165: FROM DUAL
1166: WHERE NOT EXISTS ( SELECT 'X'
1167: FROM AS_ACCESSES_ALL_ALL AA
1168: WHERE AA.sales_lead_id IS NULL
1169: AND AA.lead_id IS NULL
1170: AND AA.delete_flag is NULL
1171: AND AA.customer_id = l_customer_id(i)

Line 1184: INSERT INTO AS_ACCESSES_ALL_ALL

1180: WHEN DUP_VAL_ON_INDEX THEN
1181: 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);
1182: FOR i IN l_first .. l_last LOOP
1183: BEGIN
1184: INSERT INTO AS_ACCESSES_ALL_ALL
1185: ( access_id
1186: ,access_type
1187: ,salesforce_id
1188: ,sales_group_id

Line 1233: FROM AS_ACCESSES_ALL_ALL AA

1229: ,'Y'
1230: ,l_org_id(i)
1231: from dual
1232: where not exists ( SELECT 'X'
1233: FROM AS_ACCESSES_ALL_ALL AA
1234: WHERE AA.sales_lead_id IS NULL
1235: AND AA.lead_id IS NULL
1236: AND AA.delete_flag is NULL
1237: AND AA.customer_id = l_customer_id(i)

Line 1401: FROM AS_ACCESSES_ALL_ALL A

1397: p_terr_globals.prog_id,
1398: SYSDATE
1399: FROM
1400: ( SELECT DISTINCT a.access_id acc_id
1401: FROM AS_ACCESSES_ALL_ALL A
1402: WHERE A.customer_id=l_customer_id(i)
1403: AND A.delete_flag is NULL
1404: AND NVL(A.sales_group_id,-777) = NVL(l_sales_group_id(i),-777)
1405: AND A.salesforce_id=l_salesforce_id(i)

Line 1452: FROM AS_ACCESSES_ALL_ALL A

1448: p_terr_globals.prog_id,
1449: SYSDATE
1450: FROM
1451: ( SELECT distinct A.access_id acc_id
1452: FROM AS_ACCESSES_ALL_ALL A
1453: WHERE A.customer_id=l_customer_id(i)
1454: AND A.delete_flag is NULL
1455: AND NVL(A.sales_group_id,-777) = NVL(l_sales_group_id(i),-777)
1456: AND A.salesforce_id=l_salesforce_id(i)

Line 1567: FROM AS_ACCESSES_ALL_ALL A,

1563: A.sales_group_id,
1564: A.partner_customer_id,
1565: A.partner_cont_party_id,
1566: NVL(WIN.full_access_flag,'N')
1567: FROM AS_ACCESSES_ALL_ALL A,
1568: JTF_TAE_1001_ACCOUNT_WINNERS WIN,
1569: JTF_RS_ROLE_RELATIONS REL,
1570: JTF_RS_ROLES_B ROL
1571: WHERE WIN.source_id = -1001

Line 1646: UPDATE AS_ACCESSES_ALL_ALL ACC

1642: END IF;
1643: WHILE l_attempts < 3 LOOP
1644: BEGIN
1645: FORALL i IN l_first .. l_last
1646: UPDATE AS_ACCESSES_ALL_ALL ACC
1647: SET object_version_number = NVL(object_version_number,0) + 1,
1648: ACC.last_update_date = SYSDATE,
1649: ACC.last_updated_by = p_terr_globals.user_id,
1650: ACC.last_update_login = p_terr_globals.last_update_login,

Line 1677: UPDATE AS_ACCESSES_ALL_ALL ACC

1673: IF l_attempts = 3 THEN
1674: FOR i IN l_first .. l_last
1675: LOOP
1676: BEGIN
1677: UPDATE AS_ACCESSES_ALL_ALL ACC
1678: SET object_version_number = NVL(object_version_number,0) + 1,
1679: ACC.last_update_date = SYSDATE,
1680: ACC.last_updated_by = p_terr_globals.user_id,
1681: ACC.last_update_login = p_terr_globals.last_update_login,

Line 1803: FROM AS_ACCESSES_ALL_ALL AA

1799: AND SYSDATE between REL.start_date_active
1800: AND NVL(REL.end_date_active,SYSDATE)
1801: AND W.resource_id=RES.resource_id
1802: AND NOT EXISTS ( SELECT 1
1803: FROM AS_ACCESSES_ALL_ALL AA
1804: WHERE AA.sales_lead_id IS NULL
1805: AND AA.lead_id IS NULL
1806: AND (AA.partner_customer_id IS NOT NULL OR AA.partner_cont_party_id IS NOT NULL )
1807: AND AA.customer_id = W.trans_object_id

Line 1874: INSERT INTO AS_ACCESSES_ALL_ALL

1870: END IF;
1871: BEGIN
1872: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' to '||l_last);
1873: FORALL i IN l_first .. l_last
1874: INSERT INTO AS_ACCESSES_ALL_ALL
1875: ( access_id
1876: ,access_type
1877: ,salesforce_id
1878: ,sales_group_id

Line 1932: INSERT INTO AS_ACCESSES_ALL_ALL

1928: WHEN DUP_VAL_ON_INDEX THEN
1929: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1930: FOR i IN l_first .. l_last LOOP
1931: BEGIN
1932: INSERT INTO AS_ACCESSES_ALL_ALL
1933: ( access_id
1934: ,access_type
1935: ,salesforce_id
1936: ,sales_group_id

Line 2147: FROM AS_ACCESSES_ALL_ALL A

2143: p_terr_globals.prog_id,
2144: SYSDATE
2145: FROM
2146: ( SELECT distinct A.access_id acc_id
2147: FROM AS_ACCESSES_ALL_ALL A
2148: WHERE A.customer_id=l_customer_id(i)
2149: AND (A.partner_customer_id is NOT NULL OR A.partner_cont_party_id is NOT NULL )
2150: AND A.delete_flag is NULL
2151: AND NVL(A.sales_group_id,-777)=NVL(l_sales_group_id(i),-777)

Line 2199: FROM AS_ACCESSES_ALL_ALL A

2195: p_terr_globals.prog_id,
2196: SYSDATE
2197: FROM
2198: ( SELECT distinct A.access_id acc_id
2199: FROM AS_ACCESSES_ALL_ALL A
2200: WHERE A.customer_id=l_customer_id(i)
2201: AND A.delete_flag is NULL
2202: AND (A.partner_customer_id is NOT NULL OR A.partner_cont_party_id is NOT NULL )
2203: AND NVL(A.sales_group_id,-777)=NVL(l_sales_group_id(i),-777)

Line 2362: UPDATE AS_ACCESSES_ALL_ALL ACC

2358: WHILE l_attempts < 3 LOOP --{L4
2359: BEGIN
2360: 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);
2361: FORALL i in l_first..l_last
2362: UPDATE AS_ACCESSES_ALL_ALL ACC
2363: SET object_version_number = NVL(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
2364: WHERE ACC.customer_id=l_customer_id(i)
2365: AND ACC.delete_flag is NULL
2366: AND NVL(ACC.freeze_flag,'N') = 'N'

Line 2386: DELETE FROM AS_ACCESSES_ALL_ALL ACC

2382: WHEN DUP_VAL_ON_INDEX THEN
2383: BEGIN
2384: 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);
2385: FORALL i in l_first..l_last
2386: DELETE FROM AS_ACCESSES_ALL_ALL ACC
2387: WHERE ACC.customer_id=l_customer_id(i)
2388: AND NVL(ACC.freeze_flag,'N') = 'N'
2389: AND ACC.lead_id IS NULL
2390: AND ACC.delete_flag is NULL

Line 2417: UPDATE AS_ACCESSES_ALL_ALL ACC

2413: IF l_attempts = 3 THEN
2414: FOR i IN l_first .. l_last LOOP --{L5
2415: BEGIN
2416: 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);
2417: UPDATE AS_ACCESSES_ALL_ALL ACC
2418: SET object_version_number = NVL(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
2419: WHERE ACC.customer_id=l_customer_id(i)
2420: AND ACC.delete_flag is NULL
2421: AND NVL(ACC.freeze_flag,'N') = 'N'

Line 2435: DELETE FROM AS_ACCESSES_ALL_ALL ACC

2431: EXCEPTION
2432: WHEN DUP_VAL_ON_INDEX THEN
2433: BEGIN
2434: 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);
2435: DELETE FROM AS_ACCESSES_ALL_ALL ACC
2436: WHERE ACC.customer_id=l_customer_id(i)
2437: AND NVL(ACC.freeze_flag,'N') = 'N'
2438: AND ACC.delete_flag is NULL
2439: AND ACC.lead_id IS NULL