APPS.AP_WEB_DB_EXPDIST_PKG dependencies on AP_WEB_DB_EXPDIST_PKG

Line 1: PACKAGE BODY AP_WEB_DB_EXPDIST_PKG AS

1: PACKAGE BODY AP_WEB_DB_EXPDIST_PKG AS
2: /* $Header: apwdbedb.pls 120.24 2012/01/11 13:27:38 meesubra ship $ */
3:
4: ---------------------------------------------
5: -- Some global types, constants and cursors

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 353: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

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

Line 470: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568

466: segment27,
467: segment28,
468: segment29,
469: segment30,
470: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568
471: FROM GL_CODE_COMBINATIONS
472: WHERE code_combination_id = p_ccid)
473: WHERE report_distribution_id = l_report_distribution_id
474: AND report_header_id = p_report_header_id;

Line 589: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568

585: segment27,
586: segment28,
587: segment29,
588: segment30,
589: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568
590: FROM GL_CODE_COMBINATIONS
591: WHERE code_combination_id = p_ccid),
592: amount = p_line_amount
593: WHERE report_distribution_id = l_report_distribution_id

Line 685: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(dist_lines_rec.CODE_COMBINATION_ID) -- Bug 7395568

681: segment27,
682: segment28,
683: segment29,
684: segment30,
685: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(dist_lines_rec.CODE_COMBINATION_ID) -- Bug 7395568
686: FROM GL_CODE_COMBINATIONS
687: WHERE code_combination_id = dist_lines_rec.CODE_COMBINATION_ID)
688: WHERE CURRENT OF dist_lines_c;
689:

Line 753: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

749: l_sequence_num NUMBER;
750:
751: BEGIN
752:
753: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
754: 'start AddDistributionLine');
755: l_sequence_num := 0;
756:
757: -- For the given line, duplicate its distributions

Line 866: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

862:
863:
864:
865:
866: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
867: 'end AddDistributionLine');
868:
869:
870: EXCEPTION

Line 944: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

940:
941:
942: BEGIN
943:
944: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
945: 'start AddDistributionLine');
946:
947: -----------------------------------------------------
948: l_debug_info := 'AP_WEB_DB_AP_INT_PKG.GetCOAofSOB';

Line 1297: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

1293: -----------------------------------------------------
1294: l_rows := dbms_sql.execute(l_cursor);
1295:
1296:
1297: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1298: 'end AddDistributionLine');
1299:
1300:
1301: EXCEPTION

Line 1445: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',

1441:
1442: RETURN l_segment_value;
1443:
1444: EXCEPTION WHEN OTHERS THEN
1445: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1446: 'Exception getting segment value ' || SQLERRM);
1447: -- Return Null for exception.
1448: RETURN NULL;
1449: END GetCCSegmentValue;

Line 1451: END AP_WEB_DB_EXPDIST_PKG;

1447: -- Return Null for exception.
1448: RETURN NULL;
1449: END GetCCSegmentValue;
1450:
1451: END AP_WEB_DB_EXPDIST_PKG;