APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_SALESREPS

Line 71: FROM jtf_rs_salesreps res

67: , res.start_date_active
68: , res.end_date_active
69: , res.object_version_number
70: , res.sales_credit_type_id
71: FROM jtf_rs_salesreps res
72: WHERE res.resource_id = l_resource_id;
73:
74: res_srp_rec res_srp_cur%rowtype;
75:

Line 77: CURSOR res_srp_terr_cur(l_salesrep_id JTF_RS_SALESREPS.SALESREP_ID%TYPE)

73:
74: res_srp_rec res_srp_cur%rowtype;
75:
76: --cursor to get salesrep territories
77: CURSOR res_srp_terr_cur(l_salesrep_id JTF_RS_SALESREPS.SALESREP_ID%TYPE)
78: IS
79: SELECT terr.salesrep_id
80: ,terr.territory_id
81: ,terr.salesrep_territory_id

Line 355: jtf_rs_salesreps_pub.update_salesrep

351: l_end_date_active := to_date(to_char(res_srp_rec.end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
352: IF(res_srp_rec.start_date_active > trunc(p_end_date_active))
353: THEN
354: --update to sydate - 2 and sysdate -1
355: jtf_rs_salesreps_pub.update_salesrep
356: ( P_API_VERSION => 1.0,
357: P_SALESREP_ID => res_srp_rec.salesrep_id,
358: P_ORG_ID => res_srp_rec.org_id,
359: P_SALES_CREDIT_TYPE_ID => res_srp_rec.sales_credit_type_id,

Line 373: jtf_rs_salesreps_pub.update_salesrep

369: >= nvl(end_date_active, l_fnd_date))
370: THEN
371:
372: --update end date with sysdate -1 call update role relate api
373: jtf_rs_salesreps_pub.update_salesrep
374: ( P_API_VERSION => 1.0,
375: P_SALESREP_ID => res_srp_rec.salesrep_id,
376: P_ORG_ID => res_srp_rec.org_id,
377: P_SALES_CREDIT_TYPE_ID => res_srp_rec.sales_credit_type_id,