APPS.QP_PARAMETERS_PKG dependencies on QP_PARAMETERS_B

Line 20: cursor C is select ROWID from QP_PARAMETERS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from QP_PARAMETERS_B
21: where PARAMETER_ID = X_PARAMETER_ID
22: ;
23: begin
24: insert into QP_PARAMETERS_B (

Line 24: insert into QP_PARAMETERS_B (

20: cursor C is select ROWID from QP_PARAMETERS_B
21: where PARAMETER_ID = X_PARAMETER_ID
22: ;
23: begin
24: insert into QP_PARAMETERS_B (
25: VALUE_SET_ID,
26: ADVANCED_PRICING_ONLY,
27: SEEDED_VALUE,
28: PARAMETER_CODE,

Line 110: from QP_PARAMETERS_B

106: ADVANCED_PRICING_ONLY,
107: SEEDED_VALUE,
108: PARAMETER_CODE,
109: PARAMETER_LEVEL
110: from QP_PARAMETERS_B
111: where PARAMETER_ID = X_PARAMETER_ID
112: for update of PARAMETER_ID nowait;
113: recinfo c%rowtype;
114:

Line 177: update QP_PARAMETERS_B set

173: X_LAST_UPDATED_BY in NUMBER,
174: X_LAST_UPDATE_LOGIN in NUMBER
175: ) is
176: begin
177: update QP_PARAMETERS_B set
178: VALUE_SET_ID = X_VALUE_SET_ID,
179: ADVANCED_PRICING_ONLY = X_ADVANCED_PRICING_ONLY,
180: SEEDED_VALUE = X_SEEDED_VALUE,
181: PARAMETER_CODE = X_PARAMETER_CODE,

Line 219: delete from QP_PARAMETERS_B

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: delete from QP_PARAMETERS_B
220: where PARAMETER_ID = X_PARAMETER_ID;
221:
222: if (sql%notfound) then
223: raise no_data_found;

Line 241: from QP_PARAMETERS_B B

237: begin
238: delete from QP_PARAMETERS_TL T
239: where not exists
240: (select NULL
241: from QP_PARAMETERS_B B
242: where B.PARAMETER_ID = T.PARAMETER_ID
243: );
244:
245: update QP_PARAMETERS_TL T set (