APPS.PO_JOB_ASSOCIATIONS_PKG dependencies on PO_JOB_ASSOCIATIONS_B

Line 17: cursor C is select ROWID from PO_JOB_ASSOCIATIONS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from PO_JOB_ASSOCIATIONS_B
18: where JOB_ID = X_JOB_ID
19: ;
20: begin
21: insert into PO_JOB_ASSOCIATIONS_B (

Line 21: insert into PO_JOB_ASSOCIATIONS_B (

17: cursor C is select ROWID from PO_JOB_ASSOCIATIONS_B
18: where JOB_ID = X_JOB_ID
19: ;
20: begin
21: insert into PO_JOB_ASSOCIATIONS_B (
22: JOB_ID,
23: CATEGORY_ID,
24: INACTIVE_DATE,
25: CREATION_DATE,

Line 91: from PO_JOB_ASSOCIATIONS_B

87: ) is
88: cursor c is select
89: CATEGORY_ID,
90: INACTIVE_DATE
91: from PO_JOB_ASSOCIATIONS_B
92: where JOB_ID = X_JOB_ID
93: for update of JOB_ID nowait;
94: recinfo c%rowtype;
95:

Line 150: update PO_JOB_ASSOCIATIONS_B set

146: X_LAST_UPDATED_BY in NUMBER,
147: X_LAST_UPDATE_LOGIN in NUMBER
148: ) is
149: begin
150: update PO_JOB_ASSOCIATIONS_B set
151: CATEGORY_ID = X_CATEGORY_ID,
152: INACTIVE_DATE = X_INACTIVE_DATE,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
154: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 188: delete from PO_JOB_ASSOCIATIONS_B

184: if (sql%notfound) then
185: raise no_data_found;
186: end if;
187:
188: delete from PO_JOB_ASSOCIATIONS_B
189: where JOB_ID = X_JOB_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 202: from PO_JOB_ASSOCIATIONS_B B

198: begin
199: delete from PO_JOB_ASSOCIATIONS_TL T
200: where not exists
201: (select NULL
202: from PO_JOB_ASSOCIATIONS_B B
203: where B.JOB_ID = T.JOB_ID
204: );
205:
206: insert into PO_JOB_ASSOCIATIONS_TL (