[Home] [Help]
339: AND adl.expenditure_item_id = cdl.expenditure_item_id
340: AND adl.document_type = 'EXP'
341: AND adl.adl_status = 'A'
342: AND cdl.line_num_reversed IS NOT NULL ) burdenable_raw_cost
343: from pa_cost_distribution_lines cdl,
344: pa_expenditure_items exp,
345: gms_award_distributions adl,
346: pa_expenditures_all pae,
347: pa_expenditure_types et
2166: where expenditure_item_id = fc_expenditure_item_id(i)
2167: and request_id = g_request_id;
2168:
2169: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2170: delete from pa_cost_distribution_lines
2171: where expenditure_item_id = fc_expenditure_item_id(i)
2172: and request_id = g_request_id
2173: and line_num in (select document_distribution_id
2174: from gms_bc_packets
2181: gms_error_pkg.gms_debug ('Updating reversed flag on CDLs..in mark exp item as failed', 'C');
2182: END IF;
2183:
2184: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2185: update pa_cost_distribution_lines
2186: set reversed_flag = NULL
2187: where expenditure_item_id = fc_expenditure_item_id(i)
2188: and nvl(reversed_flag, 'N') = 'Y'
2189: and request_id = g_request_id;
2388: p_request_id IN NUMBER) is
2389:
2390: cursor reversed_cur is
2391: select cdl.expenditure_item_id, cdl.line_num
2392: from pa_cost_distribution_lines cdl,
2393: --pa_expenditure_items_all exp,
2394: gms_bc_packets gbc
2395: where gbc.packet_id = g_packet_id
2396: and gbc.parent_bc_packet_id is null
2401: and mod(gbc.document_distribution_id,2) = 0
2402: --and exp.cost_distributed_flag = 'Y'
2403: and cdl.reversed_flag = 'Y';
2404:
2405: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2406: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2407: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2408: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2409: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2402: --and exp.cost_distributed_flag = 'Y'
2403: and cdl.reversed_flag = 'Y';
2404:
2405: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2406: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2407: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2408: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2409: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2410: Type tab_row_id is table of varchar2(30);
2442: gbc.status_code,
2443: gbc.ind_compiled_set_id,
2444: gbc.burdenable_raw_cost
2445: from gms_bc_packets gbc,
2446: pa_cost_distribution_lines cdl
2447: where gbc.packet_id = g_packet_id
2448: and gbc.document_header_id = cdl.expenditure_item_id
2449: and gbc.document_distribution_id = cdl.line_num
2450: and gbc.document_distribution_id = 1
2557: v_userid,
2558: v_userid,
2559: v_date,
2560: v_login
2561: from pa_cost_distribution_lines cdl,
2562: pa_expenditure_items_all exp,
2563: gms_bc_packets gbc
2564: where gbc.packet_id = g_packet_id
2565: and exp.expenditure_item_id = cdl.expenditure_item_id
2676: v_userid,
2677: v_userid,
2678: v_date,
2679: v_login
2680: from pa_cost_distribution_lines cdl,
2681: pa_expenditure_items_all exp,
2682: gms_bc_packets gbc
2683: where gbc.rowid = v_rowid(i)
2684: and exp.expenditure_item_id = cdl.expenditure_item_id
3426: v_date,
3427: v_login
3428: from pa_transaction_interface_all txn,
3429: pa_expenditure_items_all ei,
3430: pa_cost_distribution_lines_all cdl,
3431: ap_invoice_distributions_all apd,
3432: gms_award_distributions adl
3433: where txn.interface_id = p_xface_id
3434: and nvl(txn.transaction_status_code, 'Z') <> 'R'