APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on RA_SALESREP_TERRITORIES

Line 85: FROM ra_salesrep_territories terr

81: ,terr.salesrep_territory_id
82: ,terr.start_date_active
83: ,terr.end_date_active
84: ,terr.object_version_number
85: FROM ra_salesrep_territories terr
86: WHERE terr.salesrep_id = l_salesrep_id;
87:
88: res_srp_terr_rec res_srp_terr_cur%rowtype;
89:

Line 91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,

87:
88: res_srp_terr_rec res_srp_terr_cur%rowtype;
89:
90: --cursor to get overlap salesrep territories
91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,
92: c_end_date_active ra_salesrep_territories.end_date_active%type,
93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,
94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)

Line 92: c_end_date_active ra_salesrep_territories.end_date_active%type,

88: res_srp_terr_rec res_srp_terr_cur%rowtype;
89:
90: --cursor to get overlap salesrep territories
91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,
92: c_end_date_active ra_salesrep_territories.end_date_active%type,
93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,
94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)
96: IS

Line 93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,

89:
90: --cursor to get overlap salesrep territories
91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,
92: c_end_date_active ra_salesrep_territories.end_date_active%type,
93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,
94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)
96: IS
97: SELECT salesrep_territory_id

Line 94: c_territory_id ra_salesrep_territories.territory_id%type,

90: --cursor to get overlap salesrep territories
91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,
92: c_end_date_active ra_salesrep_territories.end_date_active%type,
93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,
94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)
96: IS
97: SELECT salesrep_territory_id
98: FROM ra_salesrep_territories

Line 95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)

91: CURSOR res_srp_terr_dup_cur(c_start_date_active ra_salesrep_territories.start_date_active%type,
92: c_end_date_active ra_salesrep_territories.end_date_active%type,
93: c_salesrep_id ra_salesrep_territories.salesrep_id%type,
94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)
96: IS
97: SELECT salesrep_territory_id
98: FROM ra_salesrep_territories
99: WHERE salesrep_id = c_salesrep_id

Line 98: FROM ra_salesrep_territories

94: c_territory_id ra_salesrep_territories.territory_id%type,
95: c_salesrep_territory_id ra_salesrep_territories.salesrep_territory_id%type)
96: IS
97: SELECT salesrep_territory_id
98: FROM ra_salesrep_territories
99: WHERE salesrep_id = c_salesrep_id
100: AND territory_id = c_territory_id
101: and salesrep_territory_id <> c_salesrep_territory_id
102: AND (c_start_date_active between start_date_active and (nvl(end_date_active, l_fnd_date))

Line 331: update ra_salesrep_territories

327: raise fnd_api.g_exc_error;
328: END IF;
329: CLOSE res_srp_terr_dup_cur;
330:
331: update ra_salesrep_territories
332: set start_date_active = trunc(p_end_date_active - 1),
333: end_date_active = trunc(p_end_date_active),
334: object_version_number = object_version_number + 1,
335: last_update_date = sysdate,

Line 339: update ra_salesrep_territories

335: last_update_date = sysdate,
336: last_updated_by = l_updated_by
337: where salesrep_territory_id = res_srp_terr_rec.salesrep_territory_id;
338: ELSIF(nvl(res_srp_terr_rec.end_date_active, l_fnd_date) >= nvl(p_end_date_active, l_fnd_date)) THEN
339: update ra_salesrep_territories
340: set end_date_active = trunc(p_end_date_active),
341: object_version_number = object_version_number + 1,
342: last_update_date = sysdate,
343: last_updated_by = l_updated_by