[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
2111: where expenditure_item_id = fc_expenditure_item_id(i)
2112: and request_id = g_request_id;
2113:
2114: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2115: delete from pa_cost_distribution_lines
2116: where expenditure_item_id = fc_expenditure_item_id(i)
2117: and request_id = g_request_id
2118: and line_num in (select document_distribution_id
2119: from gms_bc_packets
2126: gms_error_pkg.gms_debug ('Updating reversed flag on CDLs..in mark exp item as failed', 'C');
2127: END IF;
2128:
2129: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2130: update pa_cost_distribution_lines
2131: set reversed_flag = NULL
2132: where expenditure_item_id = fc_expenditure_item_id(i)
2133: and nvl(reversed_flag, 'N') = 'Y'
2134: and request_id = g_request_id;
2308: p_request_id IN NUMBER) is
2309:
2310: cursor reversed_cur is
2311: select cdl.expenditure_item_id, cdl.line_num
2312: from pa_cost_distribution_lines cdl,
2313: --pa_expenditure_items_all exp,
2314: gms_bc_packets gbc
2315: where gbc.packet_id = g_packet_id
2316: and gbc.parent_bc_packet_id is null
2321: and mod(gbc.document_distribution_id,2) = 0
2322: --and exp.cost_distributed_flag = 'Y'
2323: and cdl.reversed_flag = 'Y';
2324:
2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2327: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2328: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2329: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2322: --and exp.cost_distributed_flag = 'Y'
2323: and cdl.reversed_flag = 'Y';
2324:
2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2327: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2328: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2329: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2330: Type tab_row_id is table of varchar2(30);
2362: gbc.status_code,
2363: gbc.ind_compiled_set_id,
2364: gbc.burdenable_raw_cost
2365: from gms_bc_packets gbc,
2366: pa_cost_distribution_lines cdl
2367: where gbc.packet_id = g_packet_id
2368: and gbc.document_header_id = cdl.expenditure_item_id
2369: and gbc.document_distribution_id = cdl.line_num
2370: and gbc.document_distribution_id = 1
2477: v_userid,
2478: v_userid,
2479: v_date,
2480: v_login
2481: from pa_cost_distribution_lines cdl,
2482: pa_expenditure_items_all exp,
2483: gms_bc_packets gbc
2484: where gbc.packet_id = g_packet_id
2485: and exp.expenditure_item_id = cdl.expenditure_item_id
2596: v_userid,
2597: v_userid,
2598: v_date,
2599: v_login
2600: from pa_cost_distribution_lines cdl,
2601: pa_expenditure_items_all exp,
2602: gms_bc_packets gbc
2603: where gbc.rowid = v_rowid(i)
2604: and exp.expenditure_item_id = cdl.expenditure_item_id
3343: v_date,
3344: v_login
3345: from pa_transaction_interface_all txn,
3346: pa_expenditure_items_all ei,
3347: pa_cost_distribution_lines_all cdl,
3348: ap_invoice_distributions_all apd,
3349: gms_award_distributions adl
3350: where txn.interface_id = p_xface_id
3351: and nvl(txn.transaction_status_code, 'Z') <> 'R'