[Home] [Help]
418:
419: Exit when get_project_attr%NOTFOUND;
420:
421: /*
422: EBS Projects provides an interface table PA_TRANSACTION_INTERFACE_ALL as a staging location for project transactions before they can be
423: physically loaded into EBS Projects. Every row in the interface table constitutes an expenditure line in Projects.
424: During the import process, EBS Projects will validate the data before they are imported.
425: The validation to be performed varies, depending on the expenditure type class chosen for the row.
426:
1529: THEN
1530: FND_LOG.String
1531: (
1532: FND_LOG.level_procedure
1533: , L_LOG_MODULE || 'Before inserting into PA_TRANSACTION_INTERFACE_ALL table'
1534: , 'Begins'
1535: );
1536:
1537: End if;
1537: End if;
1538:
1539:
1540:
1541: Insert into PA_TRANSACTION_INTERFACE_ALL
1542: (
1543: transaction_source, --1
1544: batch_name , --2
1545: expenditure_ending_date, --3
1803: THEN
1804: FND_LOG.String
1805: (
1806: FND_LOG.level_procedure
1807: , L_LOG_MODULE || 'After inserting into PA_TRANSACTION_INTERFACE_ALL table'
1808: , 'ends'
1809: );
1810:
1811: End if;
2276:
2277:
2278: CURSOR get_interface_status IS
2279: SELECT transaction_status_code ,orig_transaction_reference
2280: FROM pa_transaction_interface_all
2281: WHERE transaction_source = P_transaction_source
2282: AND batch_name = P_batch
2283: AND created_by = P_user_id
2284: AND txn_interface_id = P_xface_id;
2296: where cost_id = l_cost_id;
2297:
2298: If l_status_code ='I' then
2299:
2300: UPDATE pa_transaction_interface_all
2301: set transaction_status_code ='A'
2302: where orig_transaction_reference = to_char(l_cost_id);
2303:
2304: End if;