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_WEBADI_SALSTEAM_UPDATE dependencies on JTF_TTY_NACCT_SALES_PUB

Line 760: l_added_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;

756: l_atleast_one_rep boolean := FALSE;
757: l_error varchar2(30);
758: l_imported_on DATE := null;
759:
760: l_added_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
764:

Line 761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;

757: l_error varchar2(30);
758: l_imported_on DATE := null;
759:
760: l_added_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
764:
765: l_affected_parties_tbl JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE;

Line 762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;

758: l_imported_on DATE := null;
759:
760: l_added_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
764:
765: l_affected_parties_tbl JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE;
766: l_assign_flag varchar2(1);

Line 763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;

759:
760: l_added_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
764:
765: l_affected_parties_tbl JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE;
766: l_assign_flag varchar2(1);
767: l_whether_exist varchar2(1);

Line 765: l_affected_parties_tbl JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE;

761: l_add_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
762: l_directs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
763: l_removed_rscs_tbl JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE;
764:
765: l_affected_parties_tbl JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE;
766: l_assign_flag varchar2(1);
767: l_whether_exist varchar2(1);
768: l_user_id NUMBER;
769:

Line 895: l_added_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();

891:
892:
893:
894: --dbms_output.put_line('passed initial validation');
895: l_added_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
896: l_affected_parties_tbl := JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE();
897: l_affected_parties_tbl.extend;
898: l_affected_parties_tbl(1).terr_group_account_id := l_terr_grp_acct_id;
899:

Line 896: l_affected_parties_tbl := JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE();

892:
893:
894: --dbms_output.put_line('passed initial validation');
895: l_added_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
896: l_affected_parties_tbl := JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE();
897: l_affected_parties_tbl.extend;
898: l_affected_parties_tbl(1).terr_group_account_id := l_terr_grp_acct_id;
899:
900: begin

Line 2021: l_add_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();

2017: end;
2018:
2019:
2020:
2021: l_add_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
2022: l_removed_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
2023:
2024: if p_alignment_id is null
2025: then

Line 2022: l_removed_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();

2018:
2019:
2020:
2021: l_add_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
2022: l_removed_rscs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
2023:
2024: if p_alignment_id is null
2025: then
2026: /* Following code find out all the newly added sales info and

Line 2217: l_directs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();

2213: l_res_found := FALSE;
2214: if l_added_rscs_tbl.FIRST is not null
2215: then
2216: l_direct_flag := 'N' ;
2217: l_directs_tbl := JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE();
2218: l_index := 0;
2219: OPEN c_check_direct_res(c_resource_id => c_res.resource_id,
2220: c_group_id => c_res.rsc_group_id,
2221: c_role_code => c_res.rsc_role_code,

Line 2276: JTF_TTY_NACCT_SALES_PUB.G_ADD_SALESREP_TBL:=l_add_rscs_tbl;

2272: end loop; -- end of c_res loop
2273: end if; -- end if alignment_id is null or imported_on_date is null
2274: end if; -- end if p_alignment_id is null
2275:
2276: JTF_TTY_NACCT_SALES_PUB.G_ADD_SALESREP_TBL:=l_add_rscs_tbl;
2277: JTF_TTY_NACCT_SALES_PUB.G_REM_SALESREP_TBL:=l_removed_rscs_tbl;
2278: JTF_TTY_NACCT_SALES_PUB.G_AFFECT_PARTY_TBL:=l_affected_parties_tbl;
2279:
2280: --insert into tmp2 values('what is p_alignment_id',p_alignment_id); commit;

Line 2277: JTF_TTY_NACCT_SALES_PUB.G_REM_SALESREP_TBL:=l_removed_rscs_tbl;

2273: end if; -- end if alignment_id is null or imported_on_date is null
2274: end if; -- end if p_alignment_id is null
2275:
2276: JTF_TTY_NACCT_SALES_PUB.G_ADD_SALESREP_TBL:=l_add_rscs_tbl;
2277: JTF_TTY_NACCT_SALES_PUB.G_REM_SALESREP_TBL:=l_removed_rscs_tbl;
2278: JTF_TTY_NACCT_SALES_PUB.G_AFFECT_PARTY_TBL:=l_affected_parties_tbl;
2279:
2280: --insert into tmp2 values('what is p_alignment_id',p_alignment_id); commit;
2281: if p_alignment_id is null then

Line 2278: JTF_TTY_NACCT_SALES_PUB.G_AFFECT_PARTY_TBL:=l_affected_parties_tbl;

2274: end if; -- end if p_alignment_id is null
2275:
2276: JTF_TTY_NACCT_SALES_PUB.G_ADD_SALESREP_TBL:=l_add_rscs_tbl;
2277: JTF_TTY_NACCT_SALES_PUB.G_REM_SALESREP_TBL:=l_removed_rscs_tbl;
2278: JTF_TTY_NACCT_SALES_PUB.G_AFFECT_PARTY_TBL:=l_affected_parties_tbl;
2279:
2280: --insert into tmp2 values('what is p_alignment_id',p_alignment_id); commit;
2281: if p_alignment_id is null then
2282: --call named account update API

Line 2284: JTF_TTY_NACCT_SALES_PUB.UPDATE_SALES_TEAM(

2280: --insert into tmp2 values('what is p_alignment_id',p_alignment_id); commit;
2281: if p_alignment_id is null then
2282: --call named account update API
2283: --insert into tmp values('what is l_terr_group_id',l_terr_group_id); commit;
2284: JTF_TTY_NACCT_SALES_PUB.UPDATE_SALES_TEAM(
2285: p_api_version_number => 1,
2286: p_init_msg_list => 'N',
2287: p_SQL_Trace => 'N',
2288: p_Debug_Flag => 'N',