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_TTY_NA_TERRGP dependencies on JTF_TTY_RSC_ACCT_SUMM

Line 331: DELETE from jtf_tty_rsc_acct_summ j

327:
328: p_user_id := fnd_global.user_id;
329: /* delete from the named acct sum only for affect resources */
330: /*
331: DELETE from jtf_tty_rsc_acct_summ j
332: WHERE j.RESOURCE_ID in (SELECT RESOURCE_ID
333: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1
334: WHERE j.TERR_GROUP_ACCOUNT_ID = tga1.TERR_GROUP_ACCOUNT_ID
335: AND tga1.TERR_GROUP_ID = p_terr_gp_id)

Line 344: insert into jtf_tty_rsc_acct_summ(

340: */
341: /* sum the rsc acct sum table for the deletes resources only */
342: /* and for na's for different terr gp from the deleted one */
343: /*
344: insert into jtf_tty_rsc_acct_summ(
345: RESOURCE_ACCT_SUMM_ID,
346: OBJECT_VERSION_NUMBER,
347: RESOURCE_ID,
348: RSC_GROUP_ID,

Line 356: (select jtf_tty_rsc_acct_summ_s.nextval,

352: CREATED_BY,
353: CREATION_DATE,
354: LAST_UPDATED_BY,
355: LAST_UPDATE_DATE)
356: (select jtf_tty_rsc_acct_summ_s.nextval,
357: 1,
358: ilv.RESOURCE_ID,
359: ilv.RSC_GROUP_ID,
360: 'RS_EMPLOYEE',

Line 1180: DELETE from jtf_tty_rsc_acct_summ j

1176: AND j.RSC_ROLE_CODE = p_role_code;
1177: */
1178: /* delete from the named acct sum */
1179: /*
1180: DELETE from jtf_tty_rsc_acct_summ j
1181: WHERE j.RESOURCE_ID = p_resource_id
1182: AND j.RSC_GROUP_ID = p_group_id
1183: AND j.RSC_RESOURCE_TYPE = 'RS_EMPLOYEE';
1184: sum_res_gp_accts(p_user_id, p_resource_id, p_group_id);

Line 1213: DELETE from jtf_tty_rsc_acct_summ j

1209: where group_id = managed_group_id);
1210: */
1211: /* delete from the named acct sum */
1212: /*
1213: DELETE from jtf_tty_rsc_acct_summ j
1214: WHERE j.RESOURCE_ID IN (
1215: select resource_id
1216: from jtf_rs_group_members
1217: where group_id = managed_group_id);

Line 1221: insert into jtf_tty_rsc_acct_summ(

1217: where group_id = managed_group_id);
1218: */
1219: /* re-summarize */
1220: /*
1221: insert into jtf_tty_rsc_acct_summ(
1222: RESOURCE_ACCT_SUMM_ID,
1223: OBJECT_VERSION_NUMBER,
1224: RESOURCE_ID,
1225: RSC_GROUP_ID,

Line 1233: (select jtf_tty_rsc_acct_summ_s.nextval,

1229: CREATED_BY,
1230: CREATION_DATE,
1231: LAST_UPDATED_BY,
1232: LAST_UPDATE_DATE)
1233: (select jtf_tty_rsc_acct_summ_s.nextval,
1234: 1,
1235: ilv.RESOURCE_ID,
1236: ilv.RSC_GROUP_ID,
1237: 'RS_EMPLOYEE',

Line 1286: DELETE from jtf_tty_rsc_acct_summ j

1282: where group_id = child_group_id);
1283: */
1284: /* delete from the named acct sum */
1285: /*
1286: DELETE from jtf_tty_rsc_acct_summ j
1287: WHERE j.RESOURCE_ID IN (
1288: select resource_id
1289: from jtf_rs_group_members
1290: where group_id = child_group_id);

Line 1294: insert into jtf_tty_rsc_acct_summ(

1290: where group_id = child_group_id);
1291: */
1292: /* re-summarize */
1293: /*
1294: insert into jtf_tty_rsc_acct_summ(
1295: RESOURCE_ACCT_SUMM_ID,
1296: OBJECT_VERSION_NUMBER,
1297: RESOURCE_ID,
1298: RSC_GROUP_ID,

Line 1306: (select jtf_tty_rsc_acct_summ_s.nextval,

1302: CREATED_BY,
1303: CREATION_DATE,
1304: LAST_UPDATED_BY,
1305: LAST_UPDATE_DATE)
1306: (select jtf_tty_rsc_acct_summ_s.nextval,
1307: 1,
1308: ilv.RESOURCE_ID,
1309: ilv.RSC_GROUP_ID,
1310: 'RS_EMPLOYEE',

Line 1544: delete from jtf_tty_rsc_acct_summ

1540: p_action_type IN VARCHAR2)
1541: AS
1542: BEGIN
1543: /*
1544: delete from jtf_tty_rsc_acct_summ
1545: where resource_id in(
1546: select resource_id
1547: from jtf_tty_terr_grp_owners
1548: where terr_group_id = p_terr_gp_id)

Line 1555: insert into jtf_tty_rsc_acct_summ(

1551: from jtf_tty_terr_grp_owners
1552: where terr_group_id = p_terr_gp_id);
1553:
1554:
1555: insert into jtf_tty_rsc_acct_summ(
1556: RESOURCE_ACCT_SUMM_ID,
1557: OBJECT_VERSION_NUMBER,
1558: RESOURCE_ID,
1559: RSC_GROUP_ID,

Line 1567: (select jtf_tty_rsc_acct_summ_s.nextval,

1563: CREATED_BY,
1564: CREATION_DATE,
1565: LAST_UPDATED_BY,
1566: LAST_UPDATE_DATE)
1567: (select jtf_tty_rsc_acct_summ_s.nextval,
1568: 1,
1569: ilv.RESOURCE_ID,
1570: ilv.RSC_GROUP_ID,
1571: 'RS_EMPLOYEE',

Line 1602: delete from jtf_tty_rsc_acct_summ

1598: p_rsc_group_id IN NUMBER)
1599: AS
1600: BEGIN
1601: /*
1602: delete from jtf_tty_rsc_acct_summ
1603: where RESOURCE_ID = p_resource_id
1604: and RSC_GROUP_ID = p_rsc_group_id;
1605: insert into jtf_tty_rsc_acct_summ(
1606: RESOURCE_ACCT_SUMM_ID,

Line 1605: insert into jtf_tty_rsc_acct_summ(

1601: /*
1602: delete from jtf_tty_rsc_acct_summ
1603: where RESOURCE_ID = p_resource_id
1604: and RSC_GROUP_ID = p_rsc_group_id;
1605: insert into jtf_tty_rsc_acct_summ(
1606: RESOURCE_ACCT_SUMM_ID,
1607: OBJECT_VERSION_NUMBER,
1608: RESOURCE_ID,
1609: RSC_GROUP_ID,

Line 1617: (select jtf_tty_rsc_acct_summ_s.nextval,

1613: CREATED_BY,
1614: CREATION_DATE,
1615: LAST_UPDATED_BY,
1616: LAST_UPDATE_DATE)
1617: (select jtf_tty_rsc_acct_summ_s.nextval,
1618: 1,
1619: ilv.RESOURCE_ID,
1620: ilv.RSC_GROUP_ID,
1621: 'RS_EMPLOYEE',

Line 1829: DELETE jtf_tty_rsc_acct_summ;

1825: --and na.site_type_code = p_site_type_code;
1826:
1827: BEGIN
1828: jtf_tty_workflow_pop_bin_pvt.print_log('In sum rm bin Procedure ');
1829: DELETE jtf_tty_rsc_acct_summ;
1830:
1831: FOR owner_users IN all_owner_users_c LOOP
1832: p_owner_user_id := owner_users.user_id;
1833: p_owner_group_id := owner_users.rsc_group_id;

Line 1840: FROM jtf_tty_rsc_acct_summ

1836: p_resource_id := managers.resource_id;
1837: p_group_id := managers.group_id;
1838: SELECT COUNT(RESOURCE_ACCT_SUMM_ID)
1839: INTO p_count
1840: FROM jtf_tty_rsc_acct_summ
1841: WHERE RESOURCE_ID = p_resource_id
1842: AND RSC_GROUP_ID = p_group_id;
1843:
1844: IF (p_count < 1) THEN

Line 1854: INSERT INTO jtf_tty_rsc_acct_summ(

1850: IF (p_site_type_code = 'ALL') THEN
1851: FOR namedaccounts IN named_accounts_all_c LOOP
1852: p_num_accts := namedaccounts.num_accounts;
1853: END LOOP;
1854: INSERT INTO jtf_tty_rsc_acct_summ(
1855: RESOURCE_ACCT_SUMM_ID,
1856: OBJECT_VERSION_NUMBER,
1857: RESOURCE_ID,
1858: RSC_GROUP_ID,

Line 1868: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

1864: CREATED_BY,
1865: CREATION_DATE,
1866: LAST_UPDATED_BY,
1867: LAST_UPDATE_DATE)
1868: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
1869: 1,
1870: p_resource_id,
1871: p_group_id,
1872: 'RS_EMPLOYEE',

Line 1883: INSERT INTO jtf_tty_rsc_acct_summ(

1879: l_user_id,
1880: l_sysdate);
1881: FOR res_managers IN resource_managers_c LOOP
1882: p_manager_id := res_managers.manager_id;
1883: INSERT INTO jtf_tty_rsc_acct_summ(
1884: RESOURCE_ACCT_SUMM_ID,
1885: OBJECT_VERSION_NUMBER,
1886: RESOURCE_ID,
1887: RSC_GROUP_ID,

Line 1897: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

1893: CREATED_BY,
1894: CREATION_DATE,
1895: LAST_UPDATED_BY,
1896: LAST_UPDATE_DATE)
1897: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
1898: 1,
1899: p_resource_id,
1900: p_group_id,
1901: 'RS_EMPLOYEE',

Line 1915: INSERT INTO jtf_tty_rsc_acct_summ(

1911: ELSE
1912: FOR namedaccounts IN named_accounts_c LOOP
1913: p_num_accts := namedaccounts.num_accounts;
1914: END LOOP;
1915: INSERT INTO jtf_tty_rsc_acct_summ(
1916: RESOURCE_ACCT_SUMM_ID,
1917: OBJECT_VERSION_NUMBER,
1918: RESOURCE_ID,
1919: RSC_GROUP_ID,

Line 1929: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

1925: CREATED_BY,
1926: CREATION_DATE,
1927: LAST_UPDATED_BY,
1928: LAST_UPDATE_DATE)
1929: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
1930: 1,
1931: p_resource_id,
1932: p_group_id,
1933: 'RS_EMPLOYEE',

Line 1944: INSERT INTO jtf_tty_rsc_acct_summ(

1940: l_user_id,
1941: l_sysdate);
1942: FOR res_managers IN resource_managers_c LOOP
1943: p_manager_id := res_managers.manager_id;
1944: INSERT INTO jtf_tty_rsc_acct_summ(
1945: RESOURCE_ACCT_SUMM_ID,
1946: OBJECT_VERSION_NUMBER,
1947: RESOURCE_ID,
1948: RSC_GROUP_ID,

Line 1958: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

1954: CREATED_BY,
1955: CREATION_DATE,
1956: LAST_UPDATED_BY,
1957: LAST_UPDATE_DATE)
1958: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
1959: 1,
1960: p_resource_id,
1961: p_group_id,
1962: 'RS_EMPLOYEE',

Line 1982: FROM jtf_tty_rsc_acct_summ

1978: p_resource_id := salesreps.resource_id;
1979: p_group_id := salesreps.group_id;
1980: SELECT COUNT(RESOURCE_ACCT_SUMM_ID)
1981: INTO p_count
1982: FROM jtf_tty_rsc_acct_summ
1983: WHERE RESOURCE_ID = p_resource_id
1984: AND RSC_GROUP_ID = p_group_id;
1985: IF (p_count < 1) THEN
1986: FOR numbergeos IN num_geos_c LOOP

Line 1995: INSERT INTO jtf_tty_rsc_acct_summ(

1991: IF (p_site_type_code = 'ALL') THEN
1992: FOR namedaccounts IN salesrep_named_accounts_all_c LOOP
1993: p_num_accts := namedaccounts.num_accounts;
1994: END LOOP;
1995: INSERT INTO jtf_tty_rsc_acct_summ(
1996: RESOURCE_ACCT_SUMM_ID,
1997: OBJECT_VERSION_NUMBER,
1998: RESOURCE_ID,
1999: RSC_GROUP_ID,

Line 2009: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

2005: CREATED_BY,
2006: CREATION_DATE,
2007: LAST_UPDATED_BY,
2008: LAST_UPDATE_DATE)
2009: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
2010: 1,
2011: p_resource_id,
2012: p_group_id,
2013: 'RS_EMPLOYEE',

Line 2024: INSERT INTO jtf_tty_rsc_acct_summ(

2020: l_user_id,
2021: l_sysdate);
2022: FOR res_managers IN resource_managers_c LOOP
2023: p_manager_id := res_managers.manager_id;
2024: INSERT INTO jtf_tty_rsc_acct_summ(
2025: RESOURCE_ACCT_SUMM_ID,
2026: OBJECT_VERSION_NUMBER,
2027: RESOURCE_ID,
2028: RSC_GROUP_ID,

Line 2038: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

2034: CREATED_BY,
2035: CREATION_DATE,
2036: LAST_UPDATED_BY,
2037: LAST_UPDATE_DATE)
2038: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
2039: 1,
2040: p_resource_id,
2041: p_group_id,
2042: 'RS_EMPLOYEE',

Line 2056: INSERT INTO jtf_tty_rsc_acct_summ(

2052: ELSE
2053: FOR namedaccounts IN salesrep_named_accounts_c LOOP
2054: p_num_accts := namedaccounts.num_accounts;
2055: END LOOP;
2056: INSERT INTO jtf_tty_rsc_acct_summ(
2057: RESOURCE_ACCT_SUMM_ID,
2058: OBJECT_VERSION_NUMBER,
2059: RESOURCE_ID,
2060: RSC_GROUP_ID,

Line 2070: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

2066: CREATED_BY,
2067: CREATION_DATE,
2068: LAST_UPDATED_BY,
2069: LAST_UPDATE_DATE)
2070: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
2071: 1,
2072: p_resource_id,
2073: p_group_id,
2074: 'RS_EMPLOYEE',

Line 2085: INSERT INTO jtf_tty_rsc_acct_summ(

2081: l_user_id,
2082: l_sysdate);
2083: FOR res_managers IN resource_managers_c LOOP
2084: p_manager_id := res_managers.manager_id;
2085: INSERT INTO jtf_tty_rsc_acct_summ(
2086: RESOURCE_ACCT_SUMM_ID,
2087: OBJECT_VERSION_NUMBER,
2088: RESOURCE_ID,
2089: RSC_GROUP_ID,

Line 2099: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,

2095: CREATED_BY,
2096: CREATION_DATE,
2097: LAST_UPDATED_BY,
2098: LAST_UPDATE_DATE)
2099: VALUES(jtf_tty_rsc_acct_summ_s.NEXTVAL,
2100: 1,
2101: p_resource_id,
2102: p_group_id,
2103: 'RS_EMPLOYEE',

Line 2159: delete jtf_tty_rsc_acct_summ;

2155:
2156: BEGIN
2157: jtf_tty_na_terrgp.sum_rm_bin(return_status, error_message);
2158: /*
2159: delete jtf_tty_rsc_acct_summ;
2160:
2161: insert into jtf_tty_rsc_acct_summ(
2162: RESOURCE_ACCT_SUMM_ID,
2163: OBJECT_VERSION_NUMBER,

Line 2161: insert into jtf_tty_rsc_acct_summ(

2157: jtf_tty_na_terrgp.sum_rm_bin(return_status, error_message);
2158: /*
2159: delete jtf_tty_rsc_acct_summ;
2160:
2161: insert into jtf_tty_rsc_acct_summ(
2162: RESOURCE_ACCT_SUMM_ID,
2163: OBJECT_VERSION_NUMBER,
2164: RESOURCE_ID,
2165: RSC_GROUP_ID,

Line 2173: (select jtf_tty_rsc_acct_summ_s.nextval,

2169: CREATED_BY,
2170: CREATION_DATE,
2171: LAST_UPDATED_BY,
2172: LAST_UPDATE_DATE)
2173: (select jtf_tty_rsc_acct_summ_s.nextval,
2174: 1,
2175: ilv.RESOURCE_ID,
2176: ilv.RSC_GROUP_ID,
2177: 'RS_EMPLOYEE',

Line 2456: DELETE from jtf_tty_rsc_acct_summ j

2452: AND j.RSC_ROLE_CODE = p_role_code;
2453: */
2454: /* delete from the named acct sum */
2455: /*
2456: DELETE from jtf_tty_rsc_acct_summ j
2457: WHERE j.RESOURCE_ID = p_resource_id
2458: AND j.RSC_GROUP_ID = p_group_id
2459: AND j.RSC_RESOURCE_TYPE = 'RS_EMPLOYEE';
2460: sum_res_gp_accts(p_user_id, p_resource_id, p_group_id);

Line 2486: DELETE from jtf_tty_rsc_acct_summ j

2482: where group_id = managed_group_id);
2483: */
2484: /* delete from the named acct sum */
2485: /*
2486: DELETE from jtf_tty_rsc_acct_summ j
2487: WHERE j.RESOURCE_ID IN (
2488: select resource_id
2489: from jtf_rs_group_members
2490: where group_id = managed_group_id);

Line 2494: insert into jtf_tty_rsc_acct_summ(

2490: where group_id = managed_group_id);
2491: */
2492: /* re-summarize */
2493: /*
2494: insert into jtf_tty_rsc_acct_summ(
2495: RESOURCE_ACCT_SUMM_ID,
2496: OBJECT_VERSION_NUMBER,
2497: RESOURCE_ID,
2498: RSC_GROUP_ID,

Line 2506: (select jtf_tty_rsc_acct_summ_s.nextval,

2502: CREATED_BY,
2503: CREATION_DATE,
2504: LAST_UPDATED_BY,
2505: LAST_UPDATE_DATE)
2506: (select jtf_tty_rsc_acct_summ_s.nextval,
2507: 1,
2508: ilv.RESOURCE_ID,
2509: ilv.RSC_GROUP_ID,
2510: 'RS_EMPLOYEE',

Line 2557: DELETE from jtf_tty_rsc_acct_summ j

2553: where group_id = child_group_id);
2554: */
2555: /* delete from the named acct sum */
2556: /*
2557: DELETE from jtf_tty_rsc_acct_summ j
2558: WHERE j.RESOURCE_ID IN (
2559: select resource_id
2560: from jtf_rs_group_members
2561: where group_id = child_group_id);

Line 2565: insert into jtf_tty_rsc_acct_summ(

2561: where group_id = child_group_id);
2562: */
2563: /* re-summarize */
2564: /*
2565: insert into jtf_tty_rsc_acct_summ(
2566: RESOURCE_ACCT_SUMM_ID,
2567: OBJECT_VERSION_NUMBER,
2568: RESOURCE_ID,
2569: RSC_GROUP_ID,

Line 2577: (select jtf_tty_rsc_acct_summ_s.nextval,

2573: CREATED_BY,
2574: CREATION_DATE,
2575: LAST_UPDATED_BY,
2576: LAST_UPDATE_DATE)
2577: (select jtf_tty_rsc_acct_summ_s.nextval,
2578: 1,
2579: ilv.RESOURCE_ID,
2580: ilv.RSC_GROUP_ID,
2581: 'RS_EMPLOYEE',

Line 3233: from jtf_tty_rsc_acct_summ

3229: */
3230: /*
3231: select count(*)
3232: into p_rsc_acct_count
3233: from jtf_tty_rsc_acct_summ
3234: where resource_id = p_resource_id
3235: and (rsc_group_id = p_rsc_group_id or p_rsc_group_id is null)
3236: and rsc_resource_type = 'RS_EMPLOYEE'
3237: and site_type_code = p_site_type_code;

Line 3243: insert into jtf_tty_rsc_acct_summ

3239: -- if does not exist, create a new entry, else update the count for
3240: -- correct row
3241: /*
3242: if (p_rsc_acct_count = 0) then
3243: insert into jtf_tty_rsc_acct_summ
3244: (RESOURCE_ACCT_SUMM_ID,
3245: OBJECT_VERSION_NUMBER ,
3246: RESOURCE_ID ,
3247: RSC_GROUP_ID,

Line 3272: update jtf_tty_rsc_acct_summ

3268: p_user_id);
3269:
3270: else
3271:
3272: update jtf_tty_rsc_acct_summ
3273: set NUMBER_ACCOUNTS = NUMBER_ACCOUNTS + 1
3274: where resource_id = p_resource_id
3275: and rsc_resource_type = 'RS_EMPLOYEE'
3276: and site_type_code = p_site_type_code