APPS.JTF_RS_SALESREPS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 69: l_category jtf_rs_resource_extns.category%type;

65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
73: l_msg_data VARCHAR2(2000);

Line 79: CURSOR c_category(l_resource_id jtf_rs_resource_extns.resource_id%type) is

75: l_check_char VARCHAR2(1);
76: l_check_dup_id VARCHAR2(1);
77: l_bind_data_id NUMBER;
78:
79: CURSOR c_category(l_resource_id jtf_rs_resource_extns.resource_id%type) is
80: SELECT category,source_id
81: FROM jtf_rs_resource_extns
82: WHERE resource_id = l_resource_id;
83:

Line 81: FROM jtf_rs_resource_extns

77: l_bind_data_id NUMBER;
78:
79: CURSOR c_category(l_resource_id jtf_rs_resource_extns.resource_id%type) is
80: SELECT category,source_id
81: FROM jtf_rs_resource_extns
82: WHERE resource_id = l_resource_id;
83:
84: CURSOR c_jtf_rs_salesreps(l_rowid IN ROWID) IS
85: SELECT 'Y'

Line 97: CURSOR c_dup_resource(l_resource_id jtf_rs_resource_extns.resource_id%type,

93: FROM jtf_rs_salesreps
94: WHERE salesrep_id = l_salesrep_id
95: AND nvl(org_id,-99) = nvl(l_org_id,-99);
96:
97: CURSOR c_dup_resource(l_resource_id jtf_rs_resource_extns.resource_id%type,
98: l_org_id jtf_rs_salesreps.org_id%type) IS
99: SELECT 'Y'
100: FROM jtf_rs_salesreps
101: WHERE resource_id = l_resource_id