[Home] [Help]
248: | -- All wip transaction records that refer to a non-project costed job |
249: | -- All wt records with transaction type as other than (1,2,3) and refer |
250: | to a project costed job |
251: | -- All wt records with transaction type as (1,2,3) but have no records |
252: | in WTA because their standard_rate_flag was 2 and auto_charge_type as|
253: | any thing other than manual resulting in the resource having no cost.|
254: | -- All ipv transfer transactions (source_code = 'IPV' |
255: | |
256: | PARAMETERS |
1752: | -- get the project costed flag for job if the txn is a job related |
1753: | -- assign transaction org as expenditure org |
1754: | -- get the schedule close date from acct_periods |
1755: | |
1756: | All Transactions in a Standard Costing Organization with transaction |
1757: | type having its type_class set to 1 implying that it refers to a Capital|
1758: | Project. Cost Collection is done at the specified cost at transaction |
1759: | time. |
1760: | |
1938: l_operating_unit NUMBER;
1939:
1940:
1941:
1942: /* Cursor for STANDARD ORG Proj. Misc Txn */
1943: /* If the user does not specify an expenditure_type, it will be derived */
1944: /* from the Cost Element Associations */
1945: /* PJMSTD SUPPORT------------------------------ */
1946: /* This cursor is for Std Orgs which are not PJ enabled and hence only */
2493: -- borrow /payback end
2494:
2495: ----------------------------------------------------------------------------
2496: -- PJMSTD
2497: -- This Cursor is for PO and IO Organization of Standard Cost Organizations
2498: -- The PPV is passed to project under Inventory system linkage (Material)
2499: -- Need to see how this will work for IO transactions
2500: -- For IO MMT.Variance_amount will be NOT NULL depending on FOB Point
2501: ----------------------------------------------------------------------------
2944:
2945: ----------------------------------------------------------------
2946: /* START:CC ALL ELE AS PER FROZEN COST IN STD COST ORG */
2947:
2948: -- All Transactions in a Standard Costing Organization with
2949: -- transaction type having its type_class set to 1 implying that
2950: -- it refers to a Capital Project.
2951:
2952: -- If no expenditure_type is specified at the time of txn
4378: O_err_code =>l_err_code,
4379: O_err_msg =>l_err_msg
4380: );
4381:
4382: /* For standard costing orgs, the borrow payback variance has to
4383: be applied to both the borrowing and the lending projects*/
4384: /* Patchset J - Borrow Payback Enhancements - In actual organizations, BPV
4385: against payback transactions across the same cost group has to be collected
4386: against both the borrowing and lending project Adding OR condition*/
4533: /* Consigned ownership transfer transaction */
4534: p_transaction_action_id = 6
4535: ))
4536: THEN
4537: /* For direct interorg transfers from standard org to a standard org,
4538: the PPV is always generated against the sending organization.
4539: For direct interorg transfers from average org to a standard org,
4540: the PPV is always generated against the receiving organization.
4541: */
4535: ))
4536: THEN
4537: /* For direct interorg transfers from standard org to a standard org,
4538: the PPV is always generated against the sending organization.
4539: For direct interorg transfers from average org to a standard org,
4540: the PPV is always generated against the receiving organization.
4541: */
4542: IF (
4543: (p_primary_cost_method=1 AND l_primary_cost_method_snd = 1 AND
6588: FROM mtl_parameters
6589: WHERE organization_id = l_organization_id;
6590:
6591: l_stmt_num := 40;
6592: /* Check for standard to standard direct interorg transfers. In this case
6593: the accounting entries are all made against the sending transaction_id. */
6594: IF (l_xfer_organization_id IS NOT NULL) THEN
6595: SELECT primary_cost_method
6596: INTO l_xfer_cost_method
6623: l_accounting_line_type := 1; -- Project CG is Dr
6624: l_wip_txn_source_type := 13; --INV txn SRC
6625: l_cost_element_id := NVL(p_cost_element_id, -99);
6626: ELSIF (l_transaction_action_id = 3) THEN
6627: /* If direct interorg is between standard costing orgs,
6628: no need for this as all mta entries will be against
6629: the sending transaction */
6630: IF ( l_cost_method <> 1 OR
6631: l_xfer_cost_method <> 1 OR
6723: /* sub as MTA will have the Dr entry with cost element id of NULL for expense */
6724: /* item receipts */
6725: /* Exclude Internal Order Issues to Expense */
6726: /* I know that's messed up.. But. */
6727: /* bugs 4655264 and 4651130. In consistencies between standard and Average costing orgs. THe cost processor stamps a
6728: cost element ID against the AL of 2 in the case of Average costing orgs and in the case of std costing orgs
6729: there is no CE stamped against the AL 2.Need to handle them separately. */
6730:
6731: