DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 189: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

185:
186: l_has_dist NUMBER;
187:
188: BEGIN
189: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
190: 'start MoveDistributions');
191:
192: /* If there is no distribution line, add one. */
193: BEGIN

Line 221: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

217: SET report_header_id = p_target_report_header_id,
218: report_line_id = p_target_report_line_id
219: WHERE report_line_id = p_source_report_line_id;
220:
221: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
222: 'end MoveDistributions');
223:
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN

Line 246: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

242: p_source_report_line_id IN expDist_report_line_ID,
243: p_target_report_line_id IN expDist_report_line_ID) IS
244:
245: BEGIN
246: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
247: 'start DuplicateDistributions');
248:
249: -- For the given line, duplicate its distributions
250: INSERT INTO AP_EXP_REPORT_DISTS

Line 352: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

348: report_line_id = p_source_report_line_id;
349:
350:
351:
352: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
353: 'end DuplicateDistributions');
354:
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN

Line 746: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

742: l_sequence_num NUMBER;
743:
744: BEGIN
745:
746: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
747: 'start AddDistributionLine');
748: l_sequence_num := 0;
749:
750: -- For the given line, duplicate its distributions

Line 857: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

853:
854:
855:
856:
857: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
858: 'end AddDistributionLine');
859:
860:
861: EXCEPTION

Line 933: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

929:
930:
931: BEGIN
932:
933: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
934: 'start AddDistributionLine');
935:
936: -----------------------------------------------------
937: l_debug_info := 'select from ap_expense_report_lines';

Line 1258: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

1254: -----------------------------------------------------
1255: l_rows := dbms_sql.execute(l_cursor);
1256:
1257:
1258: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1259: 'end AddDistributionLine');
1260:
1261:
1262: EXCEPTION