[Home] [Help]
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
348: where cdl.request_id = g_request_id
2067: return;
2068: end if;
2069:
2070: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2071: update pa_expenditure_items
2072: set cost_distributed_flag = decode(cost_distributed_flag,'Y','N',cost_distributed_flag),
2073: cost_dist_rejection_code = fc_result_code(i) /*Added for bug 7047986 */
2074: /* decode(fc_result_code(i), -- Commented for bug 7047986
2075: 'F10','F143',
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
2317: and gbc.status_code = 'A'
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
2486: and cdl.expenditure_item_id = gbc.document_header_id
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
2605: and cdl.expenditure_item_id = gbc.document_header_id
3342: v_userid,
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