APPS.JTF_EBI_PUB dependencies on JTF_RS_SALESREPS_INT

Line 32: UPDATE JTF_RS_SALESREPS_INT

28: BEGIN
29:
30: -- set operation to NO-OP for other rows which has same ResourceId and OrgId
31:
32: UPDATE JTF_RS_SALESREPS_INT
33: SET OPERATION = 'NO-OP'
34: WHERE RESOURCE_ID = p_resource_id
35: AND ORG_ID = p_org_id
36: AND INTERFACE_ID <> p_interface_id

Line 128: jtf_rs_salesreps_int

124: CURSOR c_salesrep_int (p_batch_id IN NUMBER) IS
125: SELECT
126: interface_id, resource_id, org_id, start_date_active, end_date_active, operation
127: FROM
128: jtf_rs_salesreps_int
129: WHERE
130: batch_id = p_batch_id
131: ORDER BY
132: interface_id;

Line 149: SELECT OPERATION INTO L_OPERATION FROM JTF_RS_SALESREPS_INT WHERE INTERFACE_ID = CUR.INTERFACE_ID;

145: FOR cur in c_salesrep_int(p_batch_id) LOOP
146: l_start_date := NULL;
147: l_end_date := NULL;
148:
149: SELECT OPERATION INTO L_OPERATION FROM JTF_RS_SALESREPS_INT WHERE INTERFACE_ID = CUR.INTERFACE_ID;
150:
151: IF (l_operation <> 'NO-OP') THEN
152:
153: set_no_op_for_similar_rows(p_batch_id,cur.INTERFACE_ID, cur.RESOURCE_ID, cur.ORG_ID);

Line 157: UPDATE JTF_RS_SALESREPS_INT

153: set_no_op_for_similar_rows(p_batch_id,cur.INTERFACE_ID, cur.RESOURCE_ID, cur.ORG_ID);
154:
155: get_res_start_and_end_date(cur.RESOURCE_ID,l_start_date,l_end_date);
156:
157: UPDATE JTF_RS_SALESREPS_INT
158: SET START_DATE_ACTIVE = l_start_date, END_DATE_ACTIVE = l_end_date
159: WHERE INTERFACE_ID = cur.INTERFACE_ID;
160:
161: END IF;