DBA Data[Home] [Help]

APPS.GMA_PURGE_UTILITIES dependencies on SY_PURG_ERR

Line 14: INSERT INTO sy_purg_err

10:
11: BEGIN
12:
13: -- Log the message to the DB
14: INSERT INTO sy_purg_err
15: ( purge_id
16: , line_no
17: , creation_date
18: , created_by

Line 24: , sy_purg_err_line_seq.nextval

20: , last_update_date
21: , text)
22: VALUES
23: ( NVL(p_purge_id,0)
24: , sy_purg_err_line_seq.nextval
25: , sysdate
26: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),0)
27: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),0)
28: , sysdate

Line 82: l_frag sy_purg_err.text%TYPE;

78: -- prints long text string broken at 80 columns
79:
80: l_counter INTEGER;
81: l_o_counter INTEGER;
82: l_frag sy_purg_err.text%TYPE;
83: l_text sy_purg_def.sqlstatement%TYPE;
84:
85: BEGIN
86: