[Home] [Help]
249: | -- All wip transaction records that refer to a non-project costed job |
250: | -- All wt records with transaction type as other than (1,2,3) and refer |
251: | to a project costed job |
252: | -- All wt records with transaction type as (1,2,3) but have no records |
253: | in WTA because their standard_rate_flag was 2 and auto_charge_type as|
254: | any thing other than manual resulting in the resource having no cost.|
255: | -- All ipv transfer transactions (source_code = 'IPV' |
256: | |
257: | PARAMETERS |
1813: | -- get the project costed flag for job if the txn is a job related |
1814: | -- assign transaction org as expenditure org |
1815: | -- get the schedule close date from acct_periods |
1816: | |
1817: | All Transactions in a Standard Costing Organization with transaction |
1818: | type having its type_class set to 1 implying that it refers to a Capital|
1819: | Project. Cost Collection is done at the specified cost at transaction |
1820: | time. |
1821: | |
1999: l_operating_unit NUMBER;
2000:
2001:
2002:
2003: /* Cursor for STANDARD ORG Proj. Misc Txn */
2004: /* If the user does not specify an expenditure_type, it will be derived */
2005: /* from the Cost Element Associations */
2006: /* PJMSTD SUPPORT------------------------------ */
2007: /* This cursor is for Std Orgs which are not PJ enabled and hence only */
2554: -- borrow /payback end
2555:
2556: ----------------------------------------------------------------------------
2557: -- PJMSTD
2558: -- This Cursor is for PO and IO Organization of Standard Cost Organizations
2559: -- The PPV is passed to project under Inventory system linkage (Material)
2560: -- Need to see how this will work for IO transactions
2561: -- For IO MMT.Variance_amount will be NOT NULL depending on FOB Point
2562: ----------------------------------------------------------------------------
3005:
3006: ----------------------------------------------------------------
3007: /* START:CC ALL ELE AS PER FROZEN COST IN STD COST ORG */
3008:
3009: -- All Transactions in a Standard Costing Organization with
3010: -- transaction type having its type_class set to 1 implying that
3011: -- it refers to a Capital Project.
3012:
3013: -- If no expenditure_type is specified at the time of txn
4439: O_err_code =>l_err_code,
4440: O_err_msg =>l_err_msg
4441: );
4442:
4443: /* For standard costing orgs, the borrow payback variance has to
4444: be applied to both the borrowing and the lending projects*/
4445: /* Patchset J - Borrow Payback Enhancements - In actual organizations, BPV
4446: against payback transactions across the same cost group has to be collected
4447: against both the borrowing and lending project Adding OR condition*/
4594: /* Consigned ownership transfer transaction */
4595: p_transaction_action_id = 6
4596: ))
4597: THEN
4598: /* For direct interorg transfers from standard org to a standard org,
4599: the PPV is always generated against the sending organization.
4600: For direct interorg transfers from average org to a standard org,
4601: the PPV is always generated against the receiving organization.
4602: */
4596: ))
4597: THEN
4598: /* For direct interorg transfers from standard org to a standard org,
4599: the PPV is always generated against the sending organization.
4600: For direct interorg transfers from average org to a standard org,
4601: the PPV is always generated against the receiving organization.
4602: */
4603: IF (
4604: (p_primary_cost_method=1 AND l_primary_cost_method_snd = 1 AND
6725: FROM mtl_parameters
6726: WHERE organization_id = l_organization_id;
6727:
6728: l_stmt_num := 40;
6729: /* Check for standard to standard direct interorg transfers. In this case
6730: the accounting entries are all made against the sending transaction_id. */
6731: IF (l_xfer_organization_id IS NOT NULL) THEN
6732: SELECT primary_cost_method
6733: INTO l_xfer_cost_method
6760: l_accounting_line_type := 1; -- Project CG is Dr
6761: l_wip_txn_source_type := 13; --INV txn SRC
6762: l_cost_element_id := NVL(p_cost_element_id, -99);
6763: ELSIF (l_transaction_action_id = 3) THEN
6764: /* If direct interorg is between standard costing orgs,
6765: no need for this as all mta entries will be against
6766: the sending transaction */
6767: IF ( l_cost_method <> 1 OR
6768: l_xfer_cost_method <> 1 OR
6796: -- =====================================================
6797: -- FP BUG 8614146 fix : set l_cost_element_id to -99 when
6798: -- source flag is 1, txn_action_id in 2,28 and
6799: -- expense flag is 1 (expense item or expense sub inv)
6800: -- for standard costing method
6801: -- NOTE: In MTA, it is OK to have cost_element_id NULL
6802: -- for accounting_line_type 2 for expense destination
6803: -- =====================================================
6804: If (l_xfer_exp_flag = 1 AND l_cost_method = 1) then
6873: /* sub as MTA will have the Dr entry with cost element id of NULL for expense */
6874: /* item receipts */
6875: /* Exclude Internal Order Issues to Expense */
6876: /* I know that's messed up.. But. */
6877: /* bugs 4655264 and 4651130. In consistencies between standard and Average costing orgs. THe cost processor stamps a
6878: cost element ID against the AL of 2 in the case of Average costing orgs and in the case of std costing orgs
6879: there is no CE stamped against the AL 2.Need to handle them separately. */
6880:
6881: