APPS.QP_PTE_REQUEST_TYPES_PKG dependencies on QP_PTE_REQUEST_TYPES_B

Line 35: cursor C is select ROWID from QP_PTE_REQUEST_TYPES_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from QP_PTE_REQUEST_TYPES_B
36: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE
37: ;
38: begin
39: insert into QP_PTE_REQUEST_TYPES_B (

Line 39: insert into QP_PTE_REQUEST_TYPES_B (

35: cursor C is select ROWID from QP_PTE_REQUEST_TYPES_B
36: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE
37: ;
38: begin
39: insert into QP_PTE_REQUEST_TYPES_B (
40: ORDER_LEVEL_GLOBAL_STRUCT,
41: LINE_LEVEL_GLOBAL_STRUCT,
42: ORDER_LEVEL_VIEW_NAME,
43: LINE_LEVEL_VIEW_NAME,

Line 186: from QP_PTE_REQUEST_TYPES_B

182: ATTRIBUTE13,
183: ATTRIBUTE14,
184: ATTRIBUTE15,
185: PTE_CODE
186: from QP_PTE_REQUEST_TYPES_B
187: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE
188: for update of REQUEST_TYPE_CODE nowait;
189: recinfo c%rowtype;
190:

Line 301: update QP_PTE_REQUEST_TYPES_B set

297: X_LAST_UPDATED_BY in NUMBER,
298: X_LAST_UPDATE_LOGIN in NUMBER
299: ) is
300: begin
301: update QP_PTE_REQUEST_TYPES_B set
302: ORDER_LEVEL_GLOBAL_STRUCT = X_ORDER_LEVEL_GLOBAL_STRUCT,
303: LINE_LEVEL_GLOBAL_STRUCT = X_LINE_LEVEL_GLOBAL_STRUCT,
304: ORDER_LEVEL_VIEW_NAME = X_ORDER_LEVEL_VIEW_NAME,
305: LINE_LEVEL_VIEW_NAME = X_LINE_LEVEL_VIEW_NAME,

Line 358: delete from QP_PTE_REQUEST_TYPES_B

354: if (sql%notfound) then
355: raise no_data_found;
356: end if;
357:
358: delete from QP_PTE_REQUEST_TYPES_B
359: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 372: from QP_PTE_REQUEST_TYPES_B B

368: begin
369: delete from QP_PTE_REQUEST_TYPES_TL T
370: where not exists
371: (select NULL
372: from QP_PTE_REQUEST_TYPES_B B
373: where B.REQUEST_TYPE_CODE = T.REQUEST_TYPE_CODE
374: );
375:
376: update QP_PTE_REQUEST_TYPES_TL T set (