[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
2122: return;
2123: end if;
2124:
2125: forall i in fc_expenditure_item_id.FIRST..fc_expenditure_item_id.LAST
2126: update pa_expenditure_items
2127: set cost_distributed_flag = decode(cost_distributed_flag,'Y','N',cost_distributed_flag),
2128: cost_dist_rejection_code = fc_result_code(i) /*Added for bug 7047986 */
2129: /* decode(fc_result_code(i), -- Commented for bug 7047986
2130: 'F10','F143',
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
2397: and gbc.status_code = 'A'
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
2566: and cdl.expenditure_item_id = gbc.document_header_id
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
2685: and cdl.expenditure_item_id = gbc.document_header_id
3425: v_userid,
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