APPS.QP_PB_INPUT_LINES_PKG dependencies on QP_PB_INPUT_LINES

Line 1: package body QP_PB_INPUT_LINES_PKG as

1: package body QP_PB_INPUT_LINES_PKG as
2: /* $Header: QPXUPBLB.pls 120.1 2005/10/07 06:01:22 prarasto noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 22: cursor C is select ROWID from QP_PB_INPUT_LINES

18: X_ATTRIBUTE_NAME in VARCHAR2,
19: X_ATTRIBUTE_VALUE_NAME in VARCHAR2,
20: X_ATTRIBUTE_TYPE_VALUE in VARCHAR2
21: ) is
22: cursor C is select ROWID from QP_PB_INPUT_LINES
23: where PB_INPUT_LINE_ID = X_PB_INPUT_LINE_ID;
24:
25: begin
26: insert into QP_PB_INPUT_LINES(

Line 26: insert into QP_PB_INPUT_LINES(

22: cursor C is select ROWID from QP_PB_INPUT_LINES
23: where PB_INPUT_LINE_ID = X_PB_INPUT_LINE_ID;
24:
25: begin
26: insert into QP_PB_INPUT_LINES(
27: PB_INPUT_LINE_ID,
28: PB_INPUT_HEADER_ID,
29: CONTEXT,
30: ATTRIBUTE,

Line 97: update QP_PB_INPUT_LINES set

93: X_ATTRIBUTE_VALUE_NAME in VARCHAR2,
94: X_ATTRIBUTE_TYPE_VALUE in VARCHAR2)
95: is
96: begin
97: update QP_PB_INPUT_LINES set
98: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
99: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
100: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
101: CONTEXT = X_CONTEXT,

Line 114: delete from QP_PB_INPUT_LINES

110: X_PB_INPUT_LINE_ID in NUMBER
111: )
112: is
113: begin
114: delete from QP_PB_INPUT_LINES
115: where PB_INPUT_LINE_ID = X_PB_INPUT_LINE_ID;
116:
117: if (sql%notfound) then
118: raise no_data_found;

Line 123: end QP_PB_INPUT_LINES_PKG;

119: end if;
120:
121: end DELETE_ROW;
122:
123: end QP_PB_INPUT_LINES_PKG;