eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_COST_TYPE

Line 118: --* 25-Feb-2004 PJS Added burden_ind to gmf_cost_type. *

114: --* 17-Feb-2004 PJS Set the final flag in the cost heder if mode is not draft. *
115: --* *
116: --* 24-Feb-2004 PJS Fixed indexing when writing burdens for a CREI *
117: --* *
118: --* 25-Feb-2004 PJS Added burden_ind to gmf_cost_type. *
119: --* *
120: --* 25-Feb-2004 PJS Added handling for replenishing negative onhand quantities. *
121: --* *
122: --* 03-Mar-2004 umoogala Bug 3476508: setting status to show normal/warning/error on process req *

Line 394: TYPE l_cost_tab_type IS TABLE OF SYSTEM.gmf_cost_type INDEX BY PLS_INTEGER;

390: l_debug_level_low PLS_INTEGER;
391: l_debug_level_medium PLS_INTEGER;
392: l_debug_level_high PLS_INTEGER;
393:
394: TYPE l_cost_tab_type IS TABLE OF SYSTEM.gmf_cost_type INDEX BY PLS_INTEGER;
395:
396: old_cost gmf_lot_costs%ROWTYPE;
397: old_cost_tab l_cost_tab_type; -- Existing lot costs of lot being rolled up
398:

Line 618: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

614: , SYSTEM.gmf_step_type
615: ( grsd.dep_step_id, gbs.actual_step_qty, gbs.step_qty_um, 0
616: , CAST
617: ( MULTISET
618: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
619: FROM DUAL
620: ) AS SYSTEM.gmf_cost_tab
621: )
622: , CAST

Line 624: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

620: ) AS SYSTEM.gmf_cost_tab
621: )
622: , CAST
623: ( MULTISET
624: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
625: FROM DUAL
626: ) AS SYSTEM.gmf_cost_tab
627: )
628: , CAST

Line 630: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

626: ) AS SYSTEM.gmf_cost_tab
627: )
628: , CAST
629: ( MULTISET
630: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
631: FROM DUAL
632: ) AS SYSTEM.gmf_cost_tab
633: )
634: , NULL, NULL

Line 665: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

661: , SYSTEM.gmf_step_type
662: ( g.batchstep_id, g.actual_step_qty, g.step_qty_um, 0
663: , CAST
664: ( MULTISET
665: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
666: FROM DUAL
667: ) AS SYSTEM.gmf_cost_tab
668: )
669: , CAST

Line 671: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

667: ) AS SYSTEM.gmf_cost_tab
668: )
669: , CAST
670: ( MULTISET
671: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
672: FROM DUAL
673: ) AS SYSTEM.gmf_cost_tab
674: )
675: , CAST

Line 677: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

673: ) AS SYSTEM.gmf_cost_tab
674: )
675: , CAST
676: ( MULTISET
677: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
678: FROM DUAL
679: ) AS SYSTEM.gmf_cost_tab
680: )
681: , NULL, NULL

Line 715: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

711: , SYSTEM.gmf_step_type
712: ( 1, 0, NULL, 0
713: , CAST
714: ( MULTISET
715: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
716: FROM DUAL
717: ) AS SYSTEM.gmf_cost_tab
718: )
719: , CAST

Line 721: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

717: ) AS SYSTEM.gmf_cost_tab
718: )
719: , CAST
720: ( MULTISET
721: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
722: FROM DUAL
723: ) AS SYSTEM.gmf_cost_tab
724: )
725: , CAST

Line 727: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

723: ) AS SYSTEM.gmf_cost_tab
724: )
725: , CAST
726: ( MULTISET
727: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)
728: FROM DUAL
729: ) AS SYSTEM.gmf_cost_tab
730: )
731: , NULL, NULL

Line 757: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)

753: (gbs.batchstep_id,
754: gbs.actual_step_qty,
755: gbs.step_qty_um,
756: 0,
757: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
758: FROM DUAL) AS SYSTEM.gmf_cost_tab
759: ),
760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab

Line 760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)

756: 0,
757: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
758: FROM DUAL) AS SYSTEM.gmf_cost_tab
759: ),
760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab
762: ),
763: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
764: FROM DUAL) AS SYSTEM.gmf_cost_tab

Line 763: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)

759: ),
760: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
761: FROM DUAL) AS SYSTEM.gmf_cost_tab
762: ),
763: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
764: FROM DUAL) AS SYSTEM.gmf_cost_tab
765: ),
766: NULL,
767: NULL,

Line 1086: SELECT SYSTEM.gmf_cost_type

1082:
1083: CURSOR lot_cost_detail_cursor
1084: ( p_header_id NUMBER )
1085: IS
1086: SELECT SYSTEM.gmf_cost_type
1087: ( glcd.cost_cmpntcls_id,
1088: glcd.cost_analysis_code,
1089: glcd.cost_level,
1090: glcd.component_cost,

Line 1141: SELECT SYSTEM.gmf_cost_type

1137: , p_item_id VARCHAR2
1138: , p_date DATE
1139: )
1140: IS
1141: SELECT SYSTEM.gmf_cost_type
1142: (cst.cost_cmpntcls_id,
1143: cst.cost_analysis_code,
1144: cst.cost_level,
1145: cst.cmpnt_cost,

Line 1187: SELECT SYSTEM.gmf_cost_type

1183: , p_batch_id NUMBER
1184: , p_batchstep_id NUMBER
1185: )
1186: IS
1187: SELECT SYSTEM.gmf_cost_type
1188: (gct.cost_cmpntcls_id,
1189: gct.cost_analysis_code,
1190: 0,
1191: gct.nominal_cost,

Line 1532: new_cost_tab(l) := SYSTEM.gmf_cost_type

1528: IF NOT l_cost_accrued
1529: THEN
1530:
1531: l := new_cost_tab.count+1;
1532: new_cost_tab(l) := SYSTEM.gmf_cost_type
1533: ( costs_table(k).cost_cmpntcls_id
1534: , costs_table(k).cost_analysis_code
1535: , 0
1536: , costs_table(k).component_cost

Line 1707: l_burden_costs_tab(i) := SYSTEM.gmf_cost_type

1703: l_return_status := 'E';
1704: RETURN;
1705: END IF;
1706:
1707: l_burden_costs_tab(i) := SYSTEM.gmf_cost_type
1708: ( l_burdens_tab(i).cost_cmpntcls_id
1709: , l_burdens_tab(i).cost_analysis_code
1710: , 0
1711: , l_burdens_tab(i).burden_cost

Line 2322: l_acqui_cost_tab(i) := SYSTEM.gmf_cost_type(l_cmpntcls_id,

2318: l_component_cost := NVL(l_acq_tab(i).component_cost,0);
2319:
2320:
2321:
2322: l_acqui_cost_tab(i) := SYSTEM.gmf_cost_type(l_cmpntcls_id,
2323: l_cost_analysis_code,
2324: 0,
2325: l_component_cost,
2326: 0);

Line 3127: new_cost_tab(i) := SYSTEM.gmf_cost_type ( l_ccc_id, l_a_code, 0, l_unit_cost, 0);

3123: (fnd_file.log,'ERROR: Failed to retrieve single cost component in source organization '||l_org_tab(p_source_orgn));
3124: RETURN;
3125: ELSE
3126: -- Procedure doesn't return burden ind so coerce it to zero.
3127: new_cost_tab(i) := SYSTEM.gmf_cost_type ( l_ccc_id, l_a_code, 0, l_unit_cost, 0);
3128: END IF;
3129: END LOOP;
3130: ELSE
3131: IF new_cost_tab.EXISTS(1)

Line 3762: new_cost_tab(1) := SYSTEM.gmf_cost_type

3758: fnd_file.put_line
3759: (fnd_file.log,'Initialising new_cost_tab(1)' || to_char(lot_unit_cost));
3760: END IF;
3761:
3762: new_cost_tab(1) := SYSTEM.gmf_cost_type
3763: ( component_class_id
3764: , cost_analysis_code
3765: , 0
3766: , lot_unit_cost

Line 6614: SELECT SYSTEM.gmf_cost_type

6610:
6611: PROCEDURE process_lot_cost_adjustments
6612: IS
6613: CURSOR adjustments_cursor IS
6614: SELECT SYSTEM.gmf_cost_type
6615: ( lcad.cost_cmpntcls_id
6616: , lcad.cost_analysis_code
6617: , 0
6618: , lcad.adjustment_cost

Line 7086: new_cost_tab(l_new_row) := SYSTEM.gmf_cost_type(costs_table(k).cost_cmpntcls_id,costs_table(k).cost_analysis_code,costs_table(k).cost_level,costs_table(k).component_cost,0);

7082: IF (new_cost_tab.COUNT = 0) THEN
7083: l_new_row := 1;
7084: FOR k IN 1..costs_table.COUNT
7085: LOOP
7086: new_cost_tab(l_new_row) := SYSTEM.gmf_cost_type(costs_table(k).cost_cmpntcls_id,costs_table(k).cost_analysis_code,costs_table(k).cost_level,costs_table(k).component_cost,0);
7087: l_new_row := l_new_row + 1;
7088: END LOOP;
7089: ELSE
7090: merge_costs(costs_table,

Line 7134: SELECT SYSTEM.gmf_cost_type(nct.cost_cmpntcls_id,

7130: )
7131: IS
7132: l_cost_table SYSTEM.gmf_cost_tab := new SYSTEM.gmf_cost_tab();
7133: CURSOR final_cmpnt_cur IS
7134: SELECT SYSTEM.gmf_cost_type(nct.cost_cmpntcls_id,
7135: nct.cost_analysis_code,
7136: nct.cost_level,
7137: sum(nct.component_cost),
7138: nct.burden_ind)

Line 7155: l_cost_table(i) := SYSTEM.gmf_cost_type(p_cost_tab(i).cost_cmpntcls_id,

7151:
7152: IF (p_cost_tab.COUNT > 0) THEN
7153: FOR i IN 1..p_cost_tab.COUNT LOOP
7154: l_cost_table.extend;
7155: l_cost_table(i) := SYSTEM.gmf_cost_type(p_cost_tab(i).cost_cmpntcls_id,
7156: p_cost_tab(i).cost_analysis_code,
7157: p_cost_tab(i).cost_level,
7158: p_cost_tab(i).component_cost,
7159: p_cost_tab(i).burden_ind);

Line 7911: new_cost_tab(1):= SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,transaction_row.transaction_cost,0);

7907: FETCH component_class_cursor INTO l_ccc_id,l_a_code,dummy;
7908: CLOSE component_class_cursor;
7909:
7910: IF (l_ccc_id IS NOT NULL) THEN
7911: new_cost_tab(1):= SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,transaction_row.transaction_cost,0);
7912: new_cost.unit_cost := transaction_row.transaction_cost;
7913: ELSE
7914: RETURN;
7915: END IF;

Line 8049: l_cost_tab(1) := SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,l_new_cost,0);

8045: END IF;
8046:
8047: IF (old_cost_tab.EXISTS(1)) THEN
8048: IF (l_ccc_id IS NOT NULL) THEN
8049: l_cost_tab(1) := SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,l_new_cost,0);
8050: ELSE
8051: l_return_status := 'E';
8052: -- PK added this message as above
8053: fnd_file.put_line

Line 8067: l_cost_tab(2) := SYSTEM.gmf_cost_type(l_cmpntcls_id,l_cost_analysis_code,l_cost_level,l_component_cost,l_burden_ind);

8063:
8064: IF(l_cmpntcls_id IS NULL OR l_cost_analysis_code IS NULL) THEN
8065: fnd_file.put_line (fnd_file.log,'Procedure : '||procedure_name||' Overhead default component/analysis code in fiscal policies table is not defined. Ignoring the transportation cost');
8066: ELSE
8067: l_cost_tab(2) := SYSTEM.gmf_cost_type(l_cmpntcls_id,l_cost_analysis_code,l_cost_level,l_component_cost,l_burden_ind);
8068: END IF;
8069: END IF;
8070:
8071: l_onhand_qty := old_cost.onhand_qty + transaction_row.trans_qty;

Line 8089: new_cost_tab(1) := SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,l_new_cost,0);

8085: ELSE
8086: -- This is a new lot with new cost in the target organization
8087: IF (l_ccc_id IS NOT NULL) THEN
8088: l_onhand_qty := transaction_row.trans_qty;
8089: new_cost_tab(1) := SYSTEM.gmf_cost_type(l_ccc_id,l_a_code,0,l_new_cost,0);
8090: ELSE
8091: l_return_status := 'E';
8092: fnd_file.put_line
8093: (fnd_file.log,'ERROR Procedure : '||procedure_name||' loc2 l_ccc_id has value NULL. Cannot proceed');