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 1194: update rcv_txns, po_line_locations and po_distributions accordingly *****/

1190:
1191: END IF; /** change in one of the curr_ variables **/
1192:
1193: /**** Create invoice distribution(s) , tax distribution(s) and
1194: update rcv_txns, po_line_locations and po_distributions accordingly *****/
1195:
1196:
1197: X_progress := '140'; -- receipt_invoices
1198:

Line 2162: CURSOR c_po_distributions(X_po_header_id NUMBER,

2158:
2159:
2160: /*** Cursor Declaration ***/
2161: /* Bug 3338268 - removed X_receipt_event */
2162: CURSOR c_po_distributions(X_po_header_id NUMBER,
2163: X_po_line_id NUMBER,
2164: X_po_line_location_id NUMBER,
2165: X_po_distribution_id NUMBER
2166: )

Line 2201: po_distributions_ap_v pod

2197: pod.expenditure_organization_id,
2198: pod.project_accounting_context,
2199: pod.recovery_rate
2200: FROM gl_code_combinations gcc,
2201: po_distributions_ap_v pod
2202: WHERE pod.po_header_id = X_po_header_id
2203: AND pod.po_line_id = X_po_line_id
2204: AND pod.line_location_id = X_po_line_location_id
2205: AND pod.code_combination_id = gcc.code_combination_id

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

2209:
2210: /**** Variable declarations ****/
2211:
2212: /* Bug 3338268 */
2213: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2214: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;

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

2210: /**** Variable declarations ****/
2211:
2212: /* Bug 3338268 */
2213: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2214: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;

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

2211:
2212: /* Bug 3338268 */
2213: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2214: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;

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

2213: x_pod_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
2214: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;

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

2214: x_pod_set_of_books_id po_distributions.set_of_books_id%TYPE := NULL;
2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;

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

2215: x_pod_code_combinations_id po_distributions.code_combination_id%TYPE := NULL;
2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;

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

2216: x_pod_assets_tracking_flag VARCHAR2(1) := NULL;
2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;

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

2217: x_pod_quantity_remaining po_distributions.quantity_ordered%TYPE := NULL;
2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;

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

2218: x_pod_amount_remaining po_distributions.amount_ordered%TYPE := NULL;
2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;

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

2219: x_pod_rate po_distributions.rate%TYPE := NULL;
2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;

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

2220: x_pod_rate_date po_distributions.rate_date%TYPE := NULL;
2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;

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

2221: x_pod_variance_account_id po_distributions.variance_account_id%TYPE := NULL;
2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;

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

2222: x_pod_attribute_category po_distributions.attribute_category%TYPE := NULL;
2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;

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

2223: x_pod_attribute1 po_distributions.attribute1%TYPE := NULL;
2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;

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

2224: x_pod_attribute2 po_distributions.attribute2%TYPE := NULL;
2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;

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

2225: x_pod_attribute3 po_distributions.attribute3%TYPE := NULL;
2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;

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

2226: x_pod_attribute4 po_distributions.attribute4%TYPE := NULL;
2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;

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

2227: x_pod_attribute5 po_distributions.attribute5%TYPE := NULL;
2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;

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

2228: x_pod_attribute6 po_distributions.attribute6%TYPE := NULL;
2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;

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

2229: x_pod_attribute7 po_distributions.attribute7%TYPE := NULL;
2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;

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

2230: x_pod_attribute8 po_distributions.attribute8%TYPE := NULL;
2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;

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

2231: x_pod_attribute9 po_distributions.attribute9%TYPE := NULL;
2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;

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

2232: x_pod_attribute10 po_distributions.attribute10%TYPE := NULL;
2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;

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

2233: x_pod_attribute11 po_distributions.attribute11%TYPE := NULL;
2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;

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

2234: x_pod_attribute12 po_distributions.attribute12%TYPE := NULL;
2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;

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

2235: x_pod_attribute13 po_distributions.attribute13%TYPE := NULL;
2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;

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

2236: x_pod_attribute14 po_distributions.attribute14%TYPE := NULL;
2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2244: /* End Bug 3338268 */

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

2237: x_pod_attribute15 po_distributions.attribute15%TYPE := NULL;
2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2244: /* End Bug 3338268 */
2245: /* Bug3875677 */

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

2238: x_pod_project_id po_distributions.project_id%TYPE := NULL;
2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2244: /* End Bug 3338268 */
2245: /* Bug3875677 */
2246: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;

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

2239: x_pod_task_id po_distributions.task_id%TYPE := NULL;
2240: x_pod_expenditure_item_date po_distributions.expenditure_item_date%TYPE := NULL;
2241: x_pod_expenditure_type po_distributions.expenditure_type%TYPE := NULL;
2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2244: /* End Bug 3338268 */
2245: /* Bug3875677 */
2246: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2247:

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

2242: x_pod_expenditure_org_id po_distributions.expenditure_organization_id%TYPE := NULL;
2243: x_pod_proj_accounting_context po_distributions.project_accounting_context%TYPE := NULL;
2244: /* End Bug 3338268 */
2245: /* Bug3875677 */
2246: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2247:
2248: X_rowid VARCHAR2(50);
2249: X_po_distributions c_po_distributions%ROWTYPE;
2250:

Line 2249: X_po_distributions c_po_distributions%ROWTYPE;

2245: /* Bug3875677 */
2246: x_pod_recovery_rate po_distributions.recovery_rate%TYPE := NULL;
2247:
2248: X_rowid VARCHAR2(50);
2249: X_po_distributions c_po_distributions%ROWTYPE;
2250:
2251: X_invoice_distribution_id NUMBER;
2252:
2253: X_curr_qty NUMBER; /*Qty billed to a particular dist*/

Line 2358: FROM po_distributions

2354: /***Amount remaining for each po distribution***/
2355: INTO X_count,
2356: X_sum_order_qty,
2357: X_sum_order_amt
2358: FROM po_distributions
2359: WHERE po_header_id = X_po_header_id
2360: AND po_line_id = X_po_line_id
2361: AND line_location_id = X_po_line_location_id
2362: AND DECODE(X_receipt_event, 'DELIVER', po_distribution_id,1)=

Line 2394: OPEN c_po_distributions(X_po_header_id,

2390:
2391:
2392: --Bug 3338268 call only if x_receipt_event='DELIVER', remove x_receipt_event, fetch only one record
2393: IF (x_receipt_event = 'DELIVER') THEN
2394: OPEN c_po_distributions(X_po_header_id,
2395: X_po_line_id,
2396: X_po_line_location_id,
2397: X_po_distribution_id
2398: );

Line 2399: FETCH c_po_distributions INTO

2395: X_po_line_id,
2396: X_po_line_location_id,
2397: X_po_distribution_id
2398: );
2399: FETCH c_po_distributions INTO
2400: x_pod_distribution_id,
2401: x_pod_set_of_books_id,
2402: x_pod_code_combinations_id,
2403: x_pod_assets_tracking_flag,

Line 2432: CLOSE c_po_distributions;

2428: x_pod_expenditure_type,
2429: x_pod_expenditure_org_id,
2430: x_pod_proj_accounting_context,
2431: x_pod_recovery_rate;
2432: CLOSE c_po_distributions;
2433:
2434: /* Bug3493515 (3) - Start */
2435: IF X_matching_basis = 'AMOUNT' THEN
2436: X_curr_amount:= (X_amount * X_pod_amount_remaining )/X_sum_order_amt;

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

2517: ** to AP bas for some reason the AP import program fails
2518: ** with inconsistent distribution info error.
2519: ** This is being removed based on APs suggestion.
2520: ** PROJECT_ID, TASK_ID,
2521: ** x_po_distributions.project_id, x_po_distributions.task_id,
2522: */
2523:
2524: /* Bug 2664078 - Since the accounting date is passed as the invoice date
2525: the Payables Open Interface import program is no considering the

Line 2654: -- x_po_distributions.code_combination_id,

2650: --x_invoice_date, Bug 2664078
2651: x_item_description,
2652: x_tax_code_id,
2653: NULL,
2654: -- x_po_distributions.code_combination_id,
2655: x_po_header_id,
2656: x_po_line_id,
2657: x_po_line_location_id,
2658: x_pod_distribution_id,

Line 2721: 'PO_DISTRIBUTIONS',

2717: X_batch_id,
2718: X_unique_id, -- header_id
2719: NULL, -- line_id
2720: 'PO_INV_CR_NO_DISTR',
2721: 'PO_DISTRIBUTIONS',
2722: NULL,
2723: NULL,
2724: NULL,
2725: NULL,

Line 3705: po_distributions pod,

3701: p_consumption.unit_meas_lookup_code(i), --5100177
3702: l_ship_to_location_id,
3703: l_tax_classification_code
3704: FROM
3705: po_distributions pod,
3706: gl_code_combinations gcc
3707: WHERE
3708: pod.po_distribution_id = p_consumption.po_distribution_id(i)
3709: AND pod.code_combination_id = gcc.code_combination_id;