DBA Data[Home] [Help]

APPS.PA_PAXARPPR_XMLP_PKG dependencies on PA_PURGE

Line 81: PA_PURGE_ERROR_CODE := 0;

77: FROM dual;
78:
79:
80:
81: PA_PURGE_ERROR_CODE := 0;
82: /*srw.message(0,'Before ...');*/null;
83:
84:
85: IF P_run_purge = 'Y' THEN

Line 89: pa_purge.purge(p_purge_batch_id,

85: IF P_run_purge = 'Y' THEN
86: ret_code := '0';
87: /*srw.message(0,ret_code);*/null;
88:
89: pa_purge.purge(p_purge_batch_id,
90: p_commit_size,
91: ret_code,
92: errbuf);
93: /*srw.message(0,ret_code);*/null;

Line 101: PA_PURGE_ERROR_CODE := ret_code;

97:
98: /*srw.message(0, errbuf);*/null;
99:
100:
101: PA_PURGE_ERROR_CODE := ret_code;
102: PA_PURGE_ERROR_BUFF := errbuf;
103: END IF;
104: END IF;
105:

Line 102: PA_PURGE_ERROR_BUFF := errbuf;

98: /*srw.message(0, errbuf);*/null;
99:
100:
101: PA_PURGE_ERROR_CODE := ret_code;
102: PA_PURGE_ERROR_BUFF := errbuf;
103: END IF;
104: END IF;
105:
106:

Line 113: FROM pa_purge_batches bat, pa_lookups lk

109: SELECT bat.batch_name, bat.description, bat.batch_status_code, bat.txn_to_date,
110: bat.active_closed_flag, lk.meaning, bat.purged_date
111: INTO c_batch_name, c_batch_description, c_batch_status, c_through_date,
112: c_batch_active_closed, c_batch_status_meaning, c_batch_purged_date
113: FROM pa_purge_batches bat, pa_lookups lk
114: WHERE purge_batch_id = p_purge_batch_id
115: AND lk.lookup_type = 'PURGE_BATCH_STATUS'
116: AND lk.lookup_code = bat.batch_status_code;
117: /*srw.message(0,'after select into');*/null;

Line 183: IF PA_PURGE_ERROR_CODE <> '0' then

179: END IF;
180:
181:
182:
183: IF PA_PURGE_ERROR_CODE <> '0' then
184: /*srw.message(0,' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_CODE || ' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_BUFF);*/null;
185:
186: RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
187:

Line 184: /*srw.message(0,' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_CODE || ' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_BUFF);*/null;

180:
181:
182:
183: IF PA_PURGE_ERROR_CODE <> '0' then
184: /*srw.message(0,' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_CODE || ' '||PA_PURGE_ERR_CODE.PA_PURGE_ERROR_BUFF);*/null;
185:
186: RAISE_application_error(-20101,null);/*SRW.PROGRAM_ABORT;*/null;
187:
188: End If;