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_MAINTAIN_NA_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 285: DELETE from jtf_tty_named_acct_rsc

281:
282: BEGIN
283:
284: --Delete resource assignment for the TG account
285: DELETE from jtf_tty_named_acct_rsc
286: WHERE terr_group_account_id = p_terr_grp_acct_id;
287:
288: --Delete TG account
289: DELETE from JTF_TTY_TERR_GRP_ACCTS

Line 954: INSERT INTO jtf_tty_named_acct_rsc

950: LOOP
951: FETCH c_get_rsc_details INTO l_rsc_group_id, l_resource_id, l_rsc_role_code, l_rsc_resource_type;
952: EXIT WHEN c_get_rsc_details%NOTFOUND;
953: l_user_id := fnd_global.user_id;
954: INSERT INTO jtf_tty_named_acct_rsc
955: (ACCOUNT_RESOURCE_ID,
956: OBJECT_VERSION_NUMBER,
957: TERR_GROUP_ACCOUNT_ID,
958: RESOURCE_ID,

Line 967: (SELECT jtf_tty_named_acct_rsc_s.nextval,

963: CREATED_BY,
964: CREATION_DATE,
965: LAST_UPDATED_BY,
966: LAST_UPDATE_DATE)
967: (SELECT jtf_tty_named_acct_rsc_s.nextval,
968: 1,
969: p_terr_grp_acct_id,
970: l_resource_id,
971: l_rsc_group_id,

Line 980: WHERE NOT EXISTS (SELECT null FROM jtf_tty_named_acct_rsc rsc

976: sysdate,
977: l_user_id,
978: sysdate
979: FROM dual
980: WHERE NOT EXISTS (SELECT null FROM jtf_tty_named_acct_rsc rsc
981: WHERE rsc.terr_group_account_id = p_terr_grp_acct_id
982: AND rsc.RESOURCE_ID = l_resource_id
983: AND rsc.RSC_ROLE_CODE = l_rsc_role_code
984: AND rsc.RSC_GROUP_ID = l_rsc_group_id

Line 1133: jtf_tty_named_acct_rsc nar,

1129: /*
1130: BEGIN
1131: SELECT 'VALID' INTO l_select
1132: FROM jtf_tty_terr_grp_accts tga,
1133: jtf_tty_named_acct_rsc nar,
1134: jtf_tty_terr_groups tg
1135: WHERE nar.terr_group_account_id = tga.terr_group_account_id
1136: AND nar.rsc_role_code = X_ROLE_CODE
1137: AND tga.terr_group_id = tg.terr_group_id

Line 1578: jtf_tty_named_acct_rsc narsc

1574: SELECT 'X'
1575: INTO p_exists_flag
1576: FROM jtf_tty_terr_grp_accts ga,
1577: jtf_tty_my_resources_v repdn,
1578: jtf_tty_named_acct_rsc narsc
1579: WHERE ga.terr_group_account_id = narsc.terr_group_account_id
1580: AND narsc.resource_id = repdn.resource_id
1581: AND narsc.rsc_group_id = repdn.group_id
1582: AND narsc.rsc_role_code = repdn.role_code

Line 1593: INSERT INTO jtf_tty_named_acct_rsc(

1589: EXCEPTION
1590: WHEN NO_DATA_FOUND THEN
1591: -- dbms_output.put_line('Sandeep - ASSIGN_UA_ACCT_TO_TGOWNERS: Doing insert ' || P_TERR_GP_ACCT_ID );
1592: /* Assign tga to the owner p_owner_user_rsc_id, p_owner_group_id, p_owner_role_code */
1593: INSERT INTO jtf_tty_named_acct_rsc(
1594: ACCOUNT_RESOURCE_ID,
1595: OBJECT_VERSION_NUMBER,
1596: TERR_GROUP_ACCOUNT_ID,
1597: RESOURCE_ID,

Line 1607: VALUES(jtf_tty_named_acct_rsc_s.nextval,

1603: CREATION_DATE ,
1604: LAST_UPDATED_BY ,
1605: LAST_UPDATE_DATE ,
1606: LAST_UPDATE_LOGIN )
1607: VALUES(jtf_tty_named_acct_rsc_s.nextval,
1608: 1,
1609: p_terr_gp_acct_id,
1610: p_owner_user_rsc_id,
1611: p_owner_group_id,

Line 1754: from jtf_tty_named_acct_rsc narsc ,

1750: and nai.named_account_id = gai.named_account_id
1751: and gai.terr_group_account_id = cl_terr_group_account_id
1752: -- subsidiaries that are owned by user
1753: and exists( select 'Y'
1754: from jtf_tty_named_acct_rsc narsc ,
1755: jtf_tty_my_resources_v repdn
1756: -- jtf_tty_named_accts na,
1757: -- jtf_tty_terr_grp_accts ga
1758: where narsc.terr_group_account_id = gao.terr_group_account_id

Line 1876: -- dbms_output.put_line('DELETING FROM jtf_tty_named_acct_rsc ');

1872: lp_resource_type := p_removed_rscs_tbl(i).resource_type;
1873: lp_mgr_resource_id := p_removed_rscs_tbl(i).mgr_resource_id;
1874:
1875: -- delete resource to be removed from sales team
1876: -- dbms_output.put_line('DELETING FROM jtf_tty_named_acct_rsc ');
1877: -- dbms_output.put_line(' ' ||
1878: -- ' //l_terr_group_account_id=' || l_terr_group_account_id ||
1879: -- ' //lp_resource_id=' || lp_resource_id ||
1880: -- ' //lp_group_id=' || lp_group_id ||

Line 1883: delete from jtf_tty_named_acct_rsc

1879: -- ' //lp_resource_id=' || lp_resource_id ||
1880: -- ' //lp_group_id=' || lp_group_id ||
1881: -- ' //lp_role_code=' || lp_role_code || '//');
1882:
1883: delete from jtf_tty_named_acct_rsc
1884: where rsc_group_id = lp_group_id
1885: and rsc_role_code = lp_role_code
1886: and terr_group_account_id = l_terr_group_account_id
1887: and resource_id = lp_resource_id;

Line 1901: from jtf_tty_named_acct_rsc ar

1897: -- ACHANDA : bug 3265188 : change the IN clause to EXISTS to improve performance
1898:
1899: if (p_from_where <> 'ADMIN') THEN
1900: select count(*) INTO l_directs_on_account
1901: from jtf_tty_named_acct_rsc ar
1902: where ar.terr_group_account_id = l_terr_group_account_id
1903: and exists (
1904: select 1
1905: from jtf_tty_my_resources_v grv

Line 1920: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

1916:
1917: -- dbms_output.put_line('l_directs_on_account = ' || l_directs_on_account);
1918:
1919: IF l_directs_on_account = 0 THEN
1920: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
1921: from dual;
1922:
1923: lp_mgr_group_id := p_removed_rscs_tbl(i).mgr_group_id;
1924: lp_mgr_role_code := p_removed_rscs_tbl(i).mgr_role_code;

Line 1928: insert into jtf_tty_named_acct_rsc (

1924: lp_mgr_role_code := p_removed_rscs_tbl(i).mgr_role_code;
1925:
1926: -- assigned flag N because user did not assign himself.
1927: -- It is an auto assign to user when none of his directs are assigned.
1928: insert into jtf_tty_named_acct_rsc (
1929: account_resource_id,
1930: object_version_number,
1931: terr_group_account_id,
1932: resource_id,

Line 1971: -- delete subordinates from JTF_TTY_NAMED_ACCT_RSC

1967: IF lp_mgr_resource_id <> lp_resource_id THEN
1968: /* not required as we do not have denorm table */
1969: /*
1970: FOR crd IN c_rsc_directs(lp_resource_id, lp_group_id) LOOP
1971: -- delete subordinates from JTF_TTY_NAMED_ACCT_RSC
1972: DELETE FROM JTF_TTY_NAMED_ACCT_RSC
1973: WHERE rsc_role_code = lp_role_code
1974: AND terr_group_account_id = l_terr_group_account_id
1975: AND resource_id = crd.resource_id;

Line 1972: DELETE FROM JTF_TTY_NAMED_ACCT_RSC

1968: /* not required as we do not have denorm table */
1969: /*
1970: FOR crd IN c_rsc_directs(lp_resource_id, lp_group_id) LOOP
1971: -- delete subordinates from JTF_TTY_NAMED_ACCT_RSC
1972: DELETE FROM JTF_TTY_NAMED_ACCT_RSC
1973: WHERE rsc_role_code = lp_role_code
1974: AND terr_group_account_id = l_terr_group_account_id
1975: AND resource_id = crd.resource_id;
1976:

Line 1993: **** Changes made only to JTF_TTY_NAMED_ACCT_RSC

1989: END IF; -- ((p_affected_parties_tbl.last > 0) and (p_removed_rscs_tbl.last > 0))
1990: END IF; -- ((p_affected_parties_tbl is not null) and (p_removed_rscs_tbl is not null))
1991: /***********************************************************
1992: **** PHASE I: DATAMODEL MODIFICATIONS
1993: **** Changes made only to JTF_TTY_NAMED_ACCT_RSC
1994: **** JTF_TTY_ACCT_RSC_DN
1995: ************************************************************/
1996: -- dbms_output.put_line('PHASE I ');
1997:

Line 2030: from jtf_tty_named_acct_rsc

2026: -- DOES RECORD PROCESSED EXIST? Bug: 2729383
2027: select count(*) into l_acct_rsc_exist_count
2028: from (
2029: select account_resource_id
2030: from jtf_tty_named_acct_rsc
2031: where resource_id = lp_resource_id
2032: and rsc_group_id = lp_group_id
2033: and rsc_role_code = lp_role_code
2034: and terr_group_account_id = l_terr_group_account_id

Line 2043: from jtf_tty_named_acct_rsc

2039: -- DOES RECORD PROCESSED EXIST? Bug: 2729383
2040: select count(*) into l_acct_rsc_exist_count
2041: from (
2042: select account_resource_id
2043: from jtf_tty_named_acct_rsc
2044: where resource_id = lp_resource_id
2045: and rsc_group_id = lp_group_id
2046: and rsc_role_code = lp_role_code
2047: and terr_group_account_id = l_terr_group_account_id

Line 2075: -- insert into jtf_tty_named_acct_rsc

2071:
2072: -- test if record already exists for this rsc/grp/role with assign Y
2073:
2074:
2075: -- insert into jtf_tty_named_acct_rsc
2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
2077: from dual;
2078:
2079: -- dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');

Line 2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

2072: -- test if record already exists for this rsc/grp/role with assign Y
2073:
2074:
2075: -- insert into jtf_tty_named_acct_rsc
2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
2077: from dual;
2078:
2079: -- dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');
2080: -- dbms_output.put_line(' ' || ' //new_seq_acct_rsc_id=' || new_seq_acct_rsc_id ||

Line 2079: -- dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');

2075: -- insert into jtf_tty_named_acct_rsc
2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
2077: from dual;
2078:
2079: -- dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');
2080: -- dbms_output.put_line(' ' || ' //new_seq_acct_rsc_id=' || new_seq_acct_rsc_id ||
2081: --' //l_terr_group_account_id=' || l_terr_group_account_id ||' //lp_resource_id=' ||
2082: -- lp_resource_id ||' //lp_group_id=' || lp_group_id
2083: --|| l_assign_flag ||' //lp_resource_type=' || lp_resource_type );

Line 2086: insert into jtf_tty_named_acct_rsc (

2082: -- lp_resource_id ||' //lp_group_id=' || lp_group_id
2083: --|| l_assign_flag ||' //lp_resource_type=' || lp_resource_type );
2084:
2085: -- assigned flag Y because user is assigning this individual, may be himself.
2086: insert into jtf_tty_named_acct_rsc (
2087: account_resource_id,
2088: object_version_number,
2089: terr_group_account_id,
2090: resource_id,

Line 2130: -- delete user for this account from JTF_TTY_NAMED_ACCT_RSC

2126: ,p_added_rscs_tbl(i).RESOURCE_END_DATE
2127: );
2128:
2129: -- if user exists as an account resource w/assign_flag = N then
2130: -- delete user for this account from JTF_TTY_NAMED_ACCT_RSC
2131: -- dbms_output.put_line('deleting from JTF_TTY_NAMED_ACCT_RSC:' || '//lp_group_id:'
2132: --|| lp_group_id ||'//p_role_code:' ||lp_role_code ||'//l_terr_group_account_id:'
2133: --||l_terr_group_account_id || '//lp_user_resource_id:' || lp_user_resource_id);
2134: -- Bug: 2726632

Line 2131: -- dbms_output.put_line('deleting from JTF_TTY_NAMED_ACCT_RSC:' || '//lp_group_id:'

2127: );
2128:
2129: -- if user exists as an account resource w/assign_flag = N then
2130: -- delete user for this account from JTF_TTY_NAMED_ACCT_RSC
2131: -- dbms_output.put_line('deleting from JTF_TTY_NAMED_ACCT_RSC:' || '//lp_group_id:'
2132: --|| lp_group_id ||'//p_role_code:' ||lp_role_code ||'//l_terr_group_account_id:'
2133: --||l_terr_group_account_id || '//lp_user_resource_id:' || lp_user_resource_id);
2134: -- Bug: 2726632
2135: -- Bug: 2732533

Line 2172: delete from jtf_tty_named_acct_rsc

2168: , l_login_id
2169: );
2170: */
2171:
2172: delete from jtf_tty_named_acct_rsc
2173: where 1=1
2174: --and rsc_group_id = lp_group_id
2175: --and rsc_role_code = lp_role_code
2176: and terr_group_account_id = l_terr_group_account_id

Line 2182: update jtf_tty_named_acct_rsc

2178: and assigned_flag = 'N';
2179:
2180: ELSE
2181: -- add 06/05/2006 bug 5246668, update resource attributes
2182: update jtf_tty_named_acct_rsc
2183: set attribute1 = p_added_rscs_tbl(i).RESOURCE_ATT1,
2184: attribute2 = p_added_rscs_tbl(i).RESOURCE_ATT2,
2185: attribute3 = p_added_rscs_tbl(i).RESOURCE_ATT3,
2186: attribute4 = p_added_rscs_tbl(i).RESOURCE_ATT4,

Line 2384: from jtf_tty_named_acct_rsc

2380: CURSOR c_res_list(l_terr_grp_acct_id IN number,
2381: l_sales_group IN number,
2382: l_sales_role IN varchar2)
2383: IS select RESOURCE_ID, RSC_GROUP_ID , RSC_ROLE_CODE
2384: from jtf_tty_named_acct_rsc
2385: where TERR_GROUP_ACCOUNT_ID = l_terr_grp_acct_id
2386: and (l_sales_group is null
2387: or RSC_GROUP_ID in
2388: (select group_id

Line 2511: from jtf_tty_named_acct_rsc

2507: begin
2508: l_valid_person_flag := FALSE;
2509: select ASSIGNED_FLAG
2510: into l_assign_flag
2511: from jtf_tty_named_acct_rsc
2512: where TERR_GROUP_ACCOUNT_ID = P_TERR_GP_ACCT_ID
2513: and RESOURCE_ID = l_added_rscs_tbl(j).Resource_id
2514: and RSC_GROUP_ID = l_added_rscs_tbl(j).group_id
2515: and RSC_ROLE_CODE = l_added_rscs_tbl(j).role_code