APPS.PSP_AUTO_PKG dependencies on PSP_AUTO_PARAMS

Line 170: select null from psp_auto_params

166:
167: v_Dummy varchar2(1);
168:
169: cursor expressions_c is
170: select null from psp_auto_params
171: where acct_id = X_Acct_Id;
172:
173: cursor rules_c is
174: select null from psp_auto_rules

Line 183: DELETE FROM psp_auto_params

179: -- Delete the detail records
180: open expressions_c;
181: fetch expressions_c into v_Dummy;
182: if (expressions_c%FOUND) then
183: DELETE FROM psp_auto_params
184: WHERE Acct_Id = X_Acct_Id;
185: if (SQL%NOTFOUND) then
186: close expressions_c;
187: Raise NO_DATA_FOUND;

Line 224: FROM psp_auto_params

220: X_User_Value VARCHAR2
221: ) IS
222: CURSOR C IS
223: SELECT ROWID
224: FROM psp_auto_params
225: WHERE Acct_Id = X_Acct_Id
226: AND Param_line_num = X_Param_Line_Num;
227: BEGIN
228: INSERT INTO psp_auto_params

Line 228: INSERT INTO psp_auto_params

224: FROM psp_auto_params
225: WHERE Acct_Id = X_Acct_Id
226: AND Param_line_num = X_Param_Line_Num;
227: BEGIN
228: INSERT INTO psp_auto_params
229: (
230: Acct_Id,
231: Param_Line_Num,
232: Lookup_Id,

Line 271: FROM psp_auto_params

267: X_User_Value VARCHAR2
268: ) IS
269: CURSOR C IS
270: SELECT *
271: FROM psp_auto_params
272: WHERE ROWID = X_Rowid
273: FOR UPDATE OF Acct_Id NOWAIT;
274: Recinfo C%ROWTYPE;
275: BEGIN

Line 309: UPDATE psp_auto_params

305: X_Operand VARCHAR2,
306: X_User_Value VARCHAR2
307: ) IS
308: BEGIN
309: UPDATE psp_auto_params
310: SET Acct_Id = X_Acct_Id,
311: Param_Line_Num = X_Param_Line_Num,
312: Lookup_Id = X_Lookup_Id,
313: Operand = X_Operand,

Line 326: DELETE FROM psp_auto_params

322: END Update_Expressions_Row;
323: PROCEDURE Delete_Expressions_Row (X_Rowid VARCHAR2) IS
324: BEGIN
325: -- Delete the detail records
326: DELETE FROM psp_auto_params
327: WHERE ROWID = X_Rowid;
328: if (SQL%NOTFOUND) then
329: Raise NO_DATA_FOUND;
330: end if;