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.PO_INVOICES_SV2 dependencies on PO_DISTRIBUTIONS

Line 1137: update rcv_txns, po_line_locations and po_distributions accordingly *****/

1133:
1134: END IF; /** change in one of the curr_ variables **/
1135:
1136: /**** Create invoice distribution(s) , tax distribution(s) and
1137: update rcv_txns, po_line_locations and po_distributions accordingly *****/
1138:
1139:
1140: X_progress := '140'; -- receipt_invoices
1141:

Line 2097: CURSOR c_po_distributions(X_po_header_id NUMBER,

2093:
2094:
2095: /*** Cursor Declaration ***/
2096: /* Bug 3338268 - removed X_receipt_event */
2097: CURSOR c_po_distributions(X_po_header_id NUMBER,
2098: X_po_line_id NUMBER,
2099: X_po_line_location_id NUMBER,
2100: X_po_distribution_id NUMBER
2101: )

Line 2136: po_distributions_ap_v pod

2132: pod.expenditure_organization_id,
2133: pod.project_accounting_context,
2134: pod.recovery_rate
2135: FROM gl_code_combinations gcc,
2136: po_distributions_ap_v pod
2137: WHERE pod.po_header_id = X_po_header_id
2138: AND pod.po_line_id = X_po_line_id
2139: AND pod.line_location_id = X_po_line_location_id
2140: AND pod.code_combination_id = gcc.code_combination_id

Line 2148: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;

2144:
2145: /**** Variable declarations ****/
2146:
2147: /* Bug 3338268 */
2148: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;

Line 2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;

2145: /**** Variable declarations ****/
2146:
2147: /* Bug 3338268 */
2148: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;

Line 2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;

2146:
2147: /* Bug 3338268 */
2148: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;

Line 2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;

2148: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;

Line 2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;

2149: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;

Line 2154: x_pod_rate po_distributions.rate%TYPE := NULL;

2150: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;

Line 2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;

2151: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;

Line 2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;

2152: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;

Line 2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;

2153: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;

Line 2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;

2154: x_pod_rate po_distributions.rate%TYPE := NULL;
2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;

Line 2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;

2155: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;

Line 2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;

2156: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;

Line 2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;

2157: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;

Line 2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;

2158: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;

Line 2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;

2159: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;

Line 2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;

2160: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;

Line 2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;

2161: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;

Line 2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;

2162: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;

Line 2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;

2163: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;

Line 2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;

2164: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;

Line 2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;

2165: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;

Line 2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;

2166: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;

Line 2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;

2167: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;

Line 2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;

2168: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;

Line 2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;

2169: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;

Line 2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;

2170: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;

Line 2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;

2171: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2179: /* End Bug 3338268 */

Line 2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;

2172: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2179: /* End Bug 3338268 */
2180: /* Bug3875677 */

Line 2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;

2173: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2179: /* End Bug 3338268 */
2180: /* Bug3875677 */
2181: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;

Line 2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;

2174: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2175: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2176: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2179: /* End Bug 3338268 */
2180: /* Bug3875677 */
2181: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2182:

Line 2181: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;

2177: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2178: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2179: /* End Bug 3338268 */
2180: /* Bug3875677 */
2181: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2182:
2183: X_rowid VARCHAR2(50);
2184: X_po_distributions c_po_distributions%ROWTYPE;
2185:

Line 2184: X_po_distributions c_po_distributions%ROWTYPE;

2180: /* Bug3875677 */
2181: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2182:
2183: X_rowid VARCHAR2(50);
2184: X_po_distributions c_po_distributions%ROWTYPE;
2185:
2186: X_invoice_distribution_id NUMBER;
2187:
2188: X_curr_qty NUMBER; /*Qty billed to a particular dist*/

Line 2261: FROM po_distributions

2257: /***Amount remaining for each po distribution***/
2258: INTO X_count,
2259: X_sum_order_qty,
2260: X_sum_order_amt
2261: FROM po_distributions
2262: WHERE po_header_id = X_po_header_id
2263: AND po_line_id = X_po_line_id
2264: AND line_location_id = X_po_line_location_id
2265: AND DECODE(X_receipt_event, 'DELIVER', po_distribution_id,1)=

Line 2290: OPEN c_po_distributions(X_po_header_id,

2286:
2287:
2288: --Bug 3338268 call only if x_receipt_event='DELIVER', remove x_receipt_event, fetch only one record
2289: IF (x_receipt_event = 'DELIVER') THEN
2290: OPEN c_po_distributions(X_po_header_id,
2291: X_po_line_id,
2292: X_po_line_location_id,
2293: X_po_distribution_id
2294: );

Line 2295: FETCH c_po_distributions INTO

2291: X_po_line_id,
2292: X_po_line_location_id,
2293: X_po_distribution_id
2294: );
2295: FETCH c_po_distributions INTO
2296: x_pod_distribution_id,
2297: x_pod_set_of_books_id,
2298: x_pod_code_combinations_id,
2299: x_pod_assets_tracking_flag,

Line 2328: CLOSE c_po_distributions;

2324: x_pod_expenditure_type,
2325: x_pod_expenditure_org_id,
2326: x_pod_proj_accounting_context,
2327: x_pod_recovery_rate;
2328: CLOSE c_po_distributions;
2329:
2330: /* Bug3493515 (3) - Start */
2331: IF X_matching_basis = 'AMOUNT' THEN
2332: X_curr_amount:= (X_amount * X_pod_amount_remaining )/X_sum_order_amt;

Line 2396: ** x_po_distributions.project_id, x_po_distributions.task_id,

2392: ** to AP bas for some reason the AP import program fails
2393: ** with inconsistent distribution info error.
2394: ** This is being removed based on APs suggestion.
2395: ** PROJECT_ID, TASK_ID,
2396: ** x_po_distributions.project_id, x_po_distributions.task_id,
2397: */
2398:
2399: /* Bug 2664078 - Since the accounting date is passed as the invoice date
2400: the Payables Open Interface import program is no considering the

Line 2503: -- x_po_distributions.code_combination_id,

2499: --x_invoice_date, Bug 2664078
2500: x_item_description,
2501: x_tax_code_id,
2502: NULL,
2503: -- x_po_distributions.code_combination_id,
2504: x_po_header_id,
2505: x_po_line_id,
2506: x_po_line_location_id,
2507: x_pod_distribution_id,

Line 2568: 'PO_DISTRIBUTIONS',

2564: X_batch_id,
2565: X_unique_id, -- header_id
2566: NULL, -- line_id
2567: 'PO_INV_CR_NO_DISTR',
2568: 'PO_DISTRIBUTIONS',
2569: NULL,
2570: NULL,
2571: NULL,
2572: NULL,

Line 3543: po_distributions pod,

3539: p_consumption.unit_meas_lookup_code(i), --5100177
3540: l_ship_to_location_id,
3541: l_tax_classification_code
3542: FROM
3543: po_distributions pod,
3544: gl_code_combinations gcc
3545: WHERE
3546: pod.po_distribution_id = p_consumption.po_distribution_id(i)
3547: AND pod.code_combination_id = gcc.code_combination_id;