APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_DB_EXPDIST_PKG

Line 1187: return AP_WEB_DB_EXPDIST_PKG.ContainsProjectRelatedDist(p_report_header_id => p_ReportHeaderID);

1183: --------------------------------------------------------------------------------
1184: V_Temp VARCHAR2(20);
1185: BEGIN
1186:
1187: return AP_WEB_DB_EXPDIST_PKG.ContainsProjectRelatedDist(p_report_header_id => p_ReportHeaderID);
1188:
1189: EXCEPTION
1190: WHEN TOO_MANY_ROWS THEN
1191: return TRUE;

Line 1210: return AP_WEB_DB_EXPDIST_PKG.ContainsNonProjectRelatedDist(p_report_header_id => p_ReportHeaderID);

1206: --------------------------------------------------------------------------------
1207: V_Temp VARCHAR2(20);
1208: BEGIN
1209:
1210: return AP_WEB_DB_EXPDIST_PKG.ContainsNonProjectRelatedDist(p_report_header_id => p_ReportHeaderID);
1211:
1212: EXCEPTION
1213: WHEN TOO_MANY_ROWS THEN
1214: return TRUE;

Line 1574: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1570: creation_date = sysdate
1571: WHERE report_line_id = i.report_line_id;
1572:
1573: -- Move distribution lines associated with this child line
1574: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1575: p_target_report_header_id => p_new_expense_report_id,
1576: p_source_report_line_id => i.report_line_id,
1577: p_target_report_line_id => i.report_line_id);
1578:

Line 1588: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1584: /* Bug# 6131435 : Parent Line will not be having any distribution lines
1585: So Distribution lines need not be moved for a parent line */
1586: /* Bug# 6632585 : Distribution lines of non-itemized lines should be moved */
1587: IF (l_itemization_parent_id <> -1 OR l_itemization_parent_id is NULL) THEN
1588: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1589: p_target_report_header_id => p_new_expense_report_id,
1590: p_source_report_line_id => l_OrigReportLineID,
1591: p_target_report_line_id => l_OrigReportLineID);
1592: END IF;

Line 1689: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1685: creation_date = sysdate
1686: WHERE report_line_id = i.report_line_id;
1687:
1688: -- Move distribution lines associated with this child line
1689: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1690: p_target_report_header_id => p_new_expense_report_id,
1691: p_source_report_line_id => i.report_line_id,
1692: p_target_report_line_id => i.report_line_id);
1693:

Line 1703: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1699: /* Bug# 6131435 : Parent Line will not be having any distribution lines.
1700: So Distribution lines need not be moved for a parent line */
1701: /* Bug# 6632585 : Distribution lines of non-itemized lines should be moved */
1702: IF (l_itemization_parent_id <> -1 OR l_itemization_parent_id is NULL) THEN
1703: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1704: p_target_report_header_id => p_new_expense_report_id,
1705: p_source_report_line_id => l_OrigReportLineID,
1706: p_target_report_line_id => l_OrigReportLineID);
1707: END IF;

Line 2318: AP_WEB_DB_EXPDIST_PKG.DeleteReportDistributions(P_ReportID);

2314: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
2315:
2316: BEGIN
2317: -- Delete distribution lines associated to this report first
2318: AP_WEB_DB_EXPDIST_PKG.DeleteReportDistributions(P_ReportID);
2319:
2320: -- Delete attendees
2321: AP_WEB_DB_EXP_ATTENDEES_PKG.deleteAttendees(P_ReportID);
2322:

Line 2817: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(

2813: p_daily_amount => p_mileage_line_array(i).daily_amount,
2814: p_receipt_currency_amount => p_mileage_line_array(i).amount,
2815: x_report_line_id => l_new_report_line_id);
2816:
2817: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(
2818: p_report_line_id => l_new_report_line_id);
2819:
2820: ELSIF (p_mileage_line_array(i).status = C_Modified
2821: OR p_mileage_line_array(i).status = C_Split) THEN

Line 3727: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(

3723: from AP_EXPENSE_REPORT_LINES
3724: where REPORT_LINE_ID = l_TempReportLineID;
3725: l_lines_total := l_lines_total+l_amount;
3726: -- Duplicate distribution lines associated with this line
3727: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(
3728: p_user_id,
3729: p_target_report_header_id,
3730: l_TempReportLineID,
3731: l_NewReportLineID);

Line 4130: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(

4126: l_NewReportLineID);
4127: end if;
4128:
4129: -- Duplicate distribution lines associated with this line
4130: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(
4131: p_user_id,
4132: p_target_report_header_id,
4133: l_TempReportLineID,
4134: l_NewReportLineID);