3534: ---------------------------------------------------------------
3535:
3536: ---------------------------------------------------------------
3537: -- for bug 781967, make sure that txn within the same project
3538: -- will not get posted into pa_transaction_interface_all
3539: -- bug 862689
3540: -- bug 1036822
3541: -- with DEFAULT
3542: -- PROJECT OPTION set, the WIP COMPLETION from a common job
3791:
3792: ---------------------------------------------------------------
3793: -- for bug 781967, make sure that txn within the same
3794: -- project won't
3795: -- get posted into pa_transaction_interface_all
3796: -- bug 930565, added nvl to take care sub-inventory transaction
3797: -- from common subinventory to project subinventory
3798: ---------------------------------------------------------------
3799:
5832:
5833: l_stmt_num := 62;
5834:
5835:
5836: /* This following insert statement into pa_transaction_interface will be changes to insert into pa_transaction_interface_all */
5837:
5838: /* modify the insert statement to insert the wip_resource_id and primary UOM code bug 3298023 */
5839:
5840: /* get the primary UOM code directly from the transaction */
5848: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);
5849: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);
5850: end If;
5851:
5852: /* This following insert statement into pa_transaction_interface will be changes to insert into pa_transaction_interface_all */
5853:
5854: INSERT INTO pa_transaction_interface_all
5855: ( transaction_source,
5856: batch_name,
5850: end If;
5851:
5852: /* This following insert statement into pa_transaction_interface will be changes to insert into pa_transaction_interface_all */
5853:
5854: INSERT INTO pa_transaction_interface_all
5855: ( transaction_source,
5856: batch_name,
5857: expenditure_ending_date,
5858: employee_number,
7551: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Inserting transaction into PTI ');
7552: end if;
7553:
7554:
7555: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7556:
7557:
7558: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7559:
7554:
7555: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7556:
7557:
7558: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7559:
7560: /* Modified the insert to insert the Inventory_item_id and basic UOM code bug 3298023 */
7561:
7562: /*Get the primary UOM code of the item from mtl_system_items */
7571: end If;
7572:
7573:
7574:
7575: INSERT INTO pa_transaction_interface_all
7576: ( transaction_source,
7577: batch_name,
7578: expenditure_ending_date,
7579: employee_number,