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.PA_ACC_GEN_WF_PKG dependencies on AP_INVOICES_ALL

Line 1369: FROM AP_INVOICES_ALL

1365: BEGIN
1366: IF g_invoice_id IS NOT NULL THEN -- bug 13875781 start
1367: SELECT org_id
1368: INTO l_org_id
1369: FROM AP_INVOICES_ALL
1370: WHERE invoice_id = g_invoice_id;
1371: ELSE -- bug 13875781 end
1372: SELECT org_id
1373: INTO l_org_id

Line 1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,

1546: p_expenditure_item_date IN
1547: pa_expenditure_items_all.expenditure_item_date%TYPE,
1548: p_billable_flag IN pa_tasks.billable_flag%TYPE,
1549: p_chart_of_accounts_id IN NUMBER,
1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,

Line 1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,

1547: pa_expenditure_items_all.expenditure_item_date%TYPE,
1548: p_billable_flag IN pa_tasks.billable_flag%TYPE,
1549: p_chart_of_accounts_id IN NUMBER,
1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,

Line 1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,

1548: p_billable_flag IN pa_tasks.billable_flag%TYPE,
1549: p_chart_of_accounts_id IN NUMBER,
1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,

Line 1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,

1549: p_chart_of_accounts_id IN NUMBER,
1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,

Line 1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,

1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,

Line 1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,

1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,

Line 1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,

1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,

Line 1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,

1553: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,

Line 1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,

1554: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,

Line 1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,

1555: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,

Line 1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,

1556: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,

Line 1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,

1557: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,

Line 1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,

1558: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
1566: p_dist_attribute_category IN

Line 1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,

1559: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
1566: p_dist_attribute_category IN
1567: ap_invoice_distributions_all.attribute_category%TYPE,

Line 1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,

1560: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
1566: p_dist_attribute_category IN
1567: ap_invoice_distributions_all.attribute_category%TYPE,
1568: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,

Line 1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,

1561: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
1562: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
1563: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
1564: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
1565: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
1566: p_dist_attribute_category IN
1567: ap_invoice_distributions_all.attribute_category%TYPE,
1568: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
1569: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,

Line 2146: FROM AP_INVOICES_ALL

2142: BEGIN
2143: IF g_invoice_id IS NOT NULL THEN -- bug 13875781 start
2144: SELECT org_id
2145: INTO l_org_id
2146: FROM AP_INVOICES_ALL
2147: WHERE invoice_id = g_invoice_id;
2148: ELSE -- bug 13875781 end
2149: SELECT org_id
2150: INTO l_org_id