eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_DB_EXPDIST_PKG

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

1188: --------------------------------------------------------------------------------
1189: V_Temp VARCHAR2(20);
1190: BEGIN
1191:
1192: return AP_WEB_DB_EXPDIST_PKG.ContainsProjectRelatedDist(p_report_header_id => p_ReportHeaderID);
1193:
1194: EXCEPTION
1195: WHEN TOO_MANY_ROWS THEN
1196: return TRUE;

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

1211: --------------------------------------------------------------------------------
1212: V_Temp VARCHAR2(20);
1213: BEGIN
1214:
1215: return AP_WEB_DB_EXPDIST_PKG.ContainsNonProjectRelatedDist(p_report_header_id => p_ReportHeaderID);
1216:
1217: EXCEPTION
1218: WHEN TOO_MANY_ROWS THEN
1219: return TRUE;

Line 1579: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1575: creation_date = sysdate
1576: WHERE report_line_id = i.report_line_id;
1577:
1578: -- Move distribution lines associated with this child line
1579: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1580: p_target_report_header_id => p_new_expense_report_id,
1581: p_source_report_line_id => i.report_line_id,
1582: p_target_report_line_id => i.report_line_id);
1583:

Line 1593: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

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

Line 1696: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1692: creation_date = sysdate
1693: WHERE report_line_id = i.report_line_id;
1694:
1695: -- Move distribution lines associated with this child line
1696: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1697: p_target_report_header_id => p_new_expense_report_id,
1698: p_source_report_line_id => i.report_line_id,
1699: p_target_report_line_id => i.report_line_id);
1700:

Line 1710: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1706: /* Bug# 6131435 : Parent Line will not be having any distribution lines.
1707: So Distribution lines need not be moved for a parent line */
1708: /* Bug# 6632585 : Distribution lines of non-itemized lines should be moved */
1709: IF (l_itemization_parent_id <> -1 OR l_itemization_parent_id is NULL) THEN
1710: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1711: p_target_report_header_id => p_new_expense_report_id,
1712: p_source_report_line_id => l_OrigReportLineID,
1713: p_target_report_line_id => l_OrigReportLineID);
1714: END IF;

Line 1814: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1810: creation_date = sysdate
1811: WHERE report_line_id = i.report_line_id;
1812:
1813: -- Move distribution lines associated with this child line
1814: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1815: p_target_report_header_id => p_new_expense_report_id,
1816: p_source_report_line_id => i.report_line_id,
1817: p_target_report_line_id => i.report_line_id);
1818:

Line 1828: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1824: /* Bug# 6131435 : Parent Line will not be having any distribution lines.
1825: So Distribution lines need not be moved for a parent line */
1826: /* Bug# 6632585 : Distribution lines of non-itemized lines should be moved */
1827: IF (l_itemization_parent_id <> -1 OR l_itemization_parent_id is NULL) THEN
1828: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1829: p_target_report_header_id => p_new_expense_report_id,
1830: p_source_report_line_id => l_OrigReportLineID,
1831: p_target_report_line_id => l_OrigReportLineID);
1832: END IF;

Line 1933: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1929: creation_date = sysdate
1930: WHERE report_line_id = i.report_line_id;
1931:
1932: -- Move distribution lines associated with this child line
1933: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1934: p_target_report_header_id => p_new_expense_report_id,
1935: p_source_report_line_id => i.report_line_id,
1936: p_target_report_line_id => i.report_line_id);
1937:

Line 1947: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(

1943: /* Bug# 6131435 : Parent Line will not be having any distribution lines.
1944: So Distribution lines need not be moved for a parent line */
1945: /* Bug# 6632585 : Distribution lines of non-itemized lines should be moved */
1946: IF (l_itemization_parent_id <> -1 OR l_itemization_parent_id is NULL) THEN
1947: AP_WEB_DB_EXPDIST_PKG.MoveDistributions(
1948: p_target_report_header_id => p_new_expense_report_id,
1949: p_source_report_line_id => l_OrigReportLineID,
1950: p_target_report_line_id => l_OrigReportLineID);
1951: END IF;

Line 2567: AP_WEB_DB_EXPDIST_PKG.DeleteReportDistributions(P_ReportID);

2563: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
2564:
2565: BEGIN
2566: -- Delete distribution lines associated to this report first
2567: AP_WEB_DB_EXPDIST_PKG.DeleteReportDistributions(P_ReportID);
2568:
2569: -- Delete attendees
2570: AP_WEB_DB_EXP_ATTENDEES_PKG.deleteAttendees(P_ReportID);
2571:

Line 3036: AP_WEB_DB_EXPDIST_PKG.ResplitDistAmounts(l_report_line_id,

3032: WHERE report_header_id = p_report_header_id
3033: AND distribution_line_number = p_distribution_line_number;
3034:
3035: -- Bug: 8271275, Amount on Parent Line Distributions Not updated
3036: AP_WEB_DB_EXPDIST_PKG.ResplitDistAmounts(l_report_line_id,
3037: p_amount,
3038: l_currency_code);
3039:
3040: EXCEPTION

Line 3097: --AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(

3093: p_daily_amount => p_mileage_line_array(i).daily_amount,
3094: p_receipt_currency_amount => p_mileage_line_array(i).amount,
3095: x_report_line_id => l_new_report_line_id);
3096:
3097: --AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(
3098: -- p_report_line_id => l_new_report_line_id);
3099: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(null, p_mileage_line_array(i).report_header_id,
3100: l_parent_line_number, l_new_report_line_id);
3101: -- Re-Split the Amounts on the new Line

Line 3099: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(null, p_mileage_line_array(i).report_header_id,

3095: x_report_line_id => l_new_report_line_id);
3096:
3097: --AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(
3098: -- p_report_line_id => l_new_report_line_id);
3099: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(null, p_mileage_line_array(i).report_header_id,
3100: l_parent_line_number, l_new_report_line_id);
3101: -- Re-Split the Amounts on the new Line
3102: AP_WEB_DB_EXPDIST_PKG.ResplitDistAmounts(l_new_report_line_id, p_mileage_line_array(i).amount,
3103: l_currency_code);

Line 3102: AP_WEB_DB_EXPDIST_PKG.ResplitDistAmounts(l_new_report_line_id, p_mileage_line_array(i).amount,

3098: -- p_report_line_id => l_new_report_line_id);
3099: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(null, p_mileage_line_array(i).report_header_id,
3100: l_parent_line_number, l_new_report_line_id);
3101: -- Re-Split the Amounts on the new Line
3102: AP_WEB_DB_EXPDIST_PKG.ResplitDistAmounts(l_new_report_line_id, p_mileage_line_array(i).amount,
3103: l_currency_code);
3104:
3105: ELSIF (p_mileage_line_array(i).status = C_Modified
3106: OR p_mileage_line_array(i).status = C_Split) THEN

Line 4025: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(

4021: from AP_EXPENSE_REPORT_LINES
4022: where REPORT_LINE_ID = l_TempReportLineID;
4023: l_lines_total := l_lines_total+l_amount;
4024: -- Duplicate distribution lines associated with this line
4025: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(
4026: p_user_id,
4027: p_target_report_header_id,
4028: l_TempReportLineID,
4029: l_NewReportLineID);

Line 4444: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(

4440: l_NewReportLineID);
4441: end if;
4442:
4443: -- Duplicate distribution lines associated with this line
4444: AP_WEB_DB_EXPDIST_PKG.DuplicateDistributions(
4445: p_user_id,
4446: p_target_report_header_id,
4447: l_TempReportLineID,
4448: l_NewReportLineID);