DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 3538: -- will not get posted into pa_transaction_interface_all

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

Line 3795: -- get posted into pa_transaction_interface_all

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:

Line 5836: /* This following insert statement into pa_transaction_interface will be changes to insert into pa_transaction_interface_all */

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 */

Line 5852: /* This following insert statement into pa_transaction_interface will be changes to insert into pa_transaction_interface_all */

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,

Line 5854: INSERT INTO pa_transaction_interface_all

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,

Line 7555: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */

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:

Line 7558: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */

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 */

Line 7575: INSERT INTO pa_transaction_interface_all

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,