APPS.QPR_TRANSF_HEADERS_PKG dependencies on QPR_TRANSF_HEADERS_B

Line 27: cursor C is select ROWID from QPR_TRANSF_HEADERS_B

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from QPR_TRANSF_HEADERS_B
28: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID
29: ;
30: begin
31: insert into QPR_TRANSF_HEADERS_B (

Line 31: insert into QPR_TRANSF_HEADERS_B (

27: cursor C is select ROWID from QPR_TRANSF_HEADERS_B
28: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID
29: ;
30: begin
31: insert into QPR_TRANSF_HEADERS_B (
32: TRANSF_GROUP_ID,
33: FROM_DIM_MEAS_CODE,
34: FROM_DIM_HIER_CODE,
35: LIMIT_DIM_FLAG,

Line 153: from QPR_TRANSF_HEADERS_B

149: TO_VALUE,
150: TO_VALUE_DESC,
151: PROGRAM_LOGIN_ID,
152: REQUEST_ID
153: from QPR_TRANSF_HEADERS_B
154: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID
155: for update of TRANSF_HEADER_ID nowait;
156: recinfo c%rowtype;
157:

Line 245: update QPR_TRANSF_HEADERS_B set

241: X_LAST_UPDATED_BY in NUMBER,
242: X_LAST_UPDATE_LOGIN in NUMBER
243: ) is
244: begin
245: update QPR_TRANSF_HEADERS_B set
246: TRANSF_GROUP_ID = X_TRANSF_GROUP_ID,
247: FROM_DIM_MEAS_CODE = X_FROM_DIM_MEAS_CODE,
248: FROM_DIM_HIER_CODE = X_FROM_DIM_HIER_CODE,
249: LIMIT_DIM_FLAG = X_LIMIT_DIM_FLAG,

Line 294: delete from QPR_TRANSF_HEADERS_B

290: if (sql%notfound) then
291: raise no_data_found;
292: end if;
293:
294: delete from QPR_TRANSF_HEADERS_B
295: where TRANSF_HEADER_ID = X_TRANSF_HEADER_ID;
296:
297: if (sql%notfound) then
298: raise no_data_found;

Line 308: from QPR_TRANSF_HEADERS_B B

304: begin
305: delete from QPR_TRANSF_HEADERS_TL T
306: where not exists
307: (select NULL
308: from QPR_TRANSF_HEADERS_B B
309: where B.TRANSF_HEADER_ID = T.TRANSF_HEADER_ID
310: );
311:
312: update QPR_TRANSF_HEADERS_TL T set (