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_ITEMCOST_PVT dependencies on CM_CMPT_DTL

Line 47: --| cm_cmpt_dtl tables to avoid cartesian product. |

43: --| 24/DEC/2002 Uday Moogala Bug# 2722404 |
44: --| Removed creation_date and created_by from update stmts. |
45: --| 16-APR-2009 Uday Phadtare Bug 7631080. |
46: --| Code modified in PROCEDURE Get_Item_Cost. Joined cm_cmpt_mst and |
47: --| cm_cmpt_dtl tables to avoid cartesian product. |
48: --+==========================================================================+
49: -- End of comments
50:
51: /*******************

Line 121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

117: --+==========================================================================+
118: -- Func end of comments
119: FUNCTION check_records_exist
120: (
121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

Line 122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

118: -- Func end of comments
119: FUNCTION check_records_exist
120: (
121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

Line 123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,

119: FUNCTION check_records_exist
120: (
121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

Line 124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,

120: (
121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
128: )

Line 125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

121: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
128: )
129: RETURN BOOLEAN IS

Line 126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

122: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
128: )
129: RETURN BOOLEAN IS
130:

Line 127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

123: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
124: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE ,
125: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
126: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
127: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
128: )
129: RETURN BOOLEAN IS
130:
131:

Line 133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,

129: RETURN BOOLEAN IS
130:
131:
132: CURSOR Cur_cmpt_dtl
133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

Line 134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

130:
131:
132: CURSOR Cur_cmpt_dtl
133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,

Line 135: cp_period_id cm_cmpt_dtl.period_id%TYPE,

131:
132: CURSOR Cur_cmpt_dtl
133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE

Line 136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,

132: CURSOR Cur_cmpt_dtl
133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE
140: )

Line 137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

133: ( cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE
140: )
141: IS

Line 138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,

134: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE
140: )
141: IS
142: SELECT 'x'

Line 139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE

135: cp_period_id cm_cmpt_dtl.period_id%TYPE,
136: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE ,
137: cp_cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
138: cp_cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE
140: )
141: IS
142: SELECT 'x'
143: FROM cm_cmpt_dtl

Line 143: FROM cm_cmpt_dtl

139: cp_cost_level cm_cmpt_dtl.cost_level%TYPE
140: )
141: IS
142: SELECT 'x'
143: FROM cm_cmpt_dtl
144: WHERE organization_id = cp_organization_id
145: AND inventory_item_id = cp_inventory_item_id
146: AND period_id = cp_period_id
147: AND cost_type_id = cp_cost_type_id

Line 173: --| CM_CMPT_DTL |

169: --+========================================================================+
170: --| API Name : Create_Item_Cost |
171: --| TYPE : Public |
172: --| Function : Creates a new Item Cost based on the input into table |
173: --| CM_CMPT_DTL |
174: --| Pre-reqa : None. |
175: --| Parameters : |
176: --| IN : |
177: --| p_api_version IN NUMBER - Required |

Line 224: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;

220: * Local Variables *
221: ******************/
222: l_api_name CONSTANT VARCHAR2(30) := 'Create_Item_Cost' ;
223: l_api_version CONSTANT NUMBER := 3.0 ;
224: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;
225: l_idx NUMBER(10) := 0 ;
226:
227: BEGIN
228: /**********************************

Line 304: INSERT INTO cm_cmpt_dtl

300: * not done in public API because of the performance considerations. *
301: * In case of failure error msg will be logged and will continue with the next record *
302: ***********************************************************************************************/
303: BEGIN
304: INSERT INTO cm_cmpt_dtl
305: (
306: cmpntcost_id,
307: inventory_item_id,
308: organization_id,

Line 497: INSERT INTO cm_cmpt_dtl

493: * not done in public API because of the performance considerations. *
494: * In case of failure error msg will be logged and will continue with the next record *
495: ***********************************************************************************************/
496: BEGIN
497: INSERT INTO cm_cmpt_dtl
498: (
499: cmpntcost_id,
500: inventory_item_id,
501: organization_id,

Line 709: --| Function : Updates Item Cost based on the input into CM_CMPT_DTL |

705: --Start of comments
706: --+========================================================================+
707: --| API Name : Update_Item_Cost |
708: --| TYPE : Public |
709: --| Function : Updates Item Cost based on the input into CM_CMPT_DTL |
710: --| Pre-reqa : None. |
711: --| Parameters : |
712: --| IN : |
713: --| p_api_version IN NUMBER - Required |

Line 812: UPDATE cm_cmpt_dtl

808: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) AND (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
809: THEN
810: IF p_this_level_dtl_tbl(i).delete_mark = 0
811: THEN
812: UPDATE cm_cmpt_dtl
813: SET cmpnt_cost = decode(p_this_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_this_level_dtl_tbl(i).cmpnt_cost),
814: burden_ind = decode(p_this_level_dtl_tbl(i).burden_ind, FND_API.G_MISS_NUM, NULL, NULL, burden_ind, p_this_level_dtl_tbl(i).burden_ind),
815: total_qty = decode(p_this_level_dtl_tbl(i).total_qty, FND_API.G_MISS_NUM, NULL, NULL, total_qty, p_this_level_dtl_tbl(i).total_qty),
816: costcalc_orig= decode(p_this_level_dtl_tbl(i).costcalc_orig, FND_API.G_MISS_NUM, NULL, NULL, costcalc_orig, p_this_level_dtl_tbl(i).costcalc_orig),

Line 856: UPDATE cm_cmpt_dtl

852: last_update_login = FND_GLOBAL.LOGIN_ID
853: WHERE cmpntcost_id = p_this_level_dtl_tbl(i).cmpntcost_id
854: AND cost_level = 0;
855: ELSE -- delete the record i.e mark for purge
856: UPDATE cm_cmpt_dtl
857: SET delete_mark = 1,
858: last_update_date = sysdate,
859: last_updated_by = p_user_id,
860: last_update_login = FND_GLOBAL.LOGIN_ID

Line 896: UPDATE cm_cmpt_dtl

892: END IF ;
893: ELSE -- else if cmpntcost_id is not passed
894: IF p_this_level_dtl_tbl(i).delete_mark = 0
895: THEN
896: UPDATE cm_cmpt_dtl
897: SET cmpnt_cost = decode(p_this_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_this_level_dtl_tbl(i).cmpnt_cost),
898: burden_ind = decode(p_this_level_dtl_tbl(i).burden_ind, FND_API.G_MISS_NUM, NULL, NULL, burden_ind, p_this_level_dtl_tbl(i).burden_ind),
899: total_qty = decode(p_this_level_dtl_tbl(i).total_qty, FND_API.G_MISS_NUM, NULL, NULL, total_qty, p_this_level_dtl_tbl(i).total_qty),
900: costcalc_orig= decode(p_this_level_dtl_tbl(i).costcalc_orig, FND_API.G_MISS_NUM, NULL, NULL, costcalc_orig, p_this_level_dtl_tbl(i).costcalc_orig),

Line 945: UPDATE cm_cmpt_dtl

941: AND cost_cmpntcls_id = p_this_level_dtl_tbl(i).cost_cmpntcls_id
942: AND cost_analysis_code = p_this_level_dtl_tbl(i).cost_analysis_code
943: AND cost_level = 0;
944: ELSE
945: UPDATE cm_cmpt_dtl
946: SET delete_mark = 1,
947: last_update_date = sysdate,
948: last_updated_by = p_user_id,
949: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1033: UPDATE cm_cmpt_dtl

1029: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) AND (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1030: THEN
1031: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1032: THEN
1033: UPDATE cm_cmpt_dtl
1034: SET cmpnt_cost = decode(p_lower_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_lower_level_dtl_tbl(i).cmpnt_cost),
1035: delete_mark = 0,
1036: last_update_date = sysdate,
1037: last_updated_by = p_user_id,

Line 1042: UPDATE cm_cmpt_dtl

1038: last_update_login = FND_GLOBAL.LOGIN_ID
1039: WHERE cmpntcost_id = p_lower_level_dtl_tbl(i).cmpntcost_id
1040: AND cost_level = 1;
1041: ELSE
1042: UPDATE cm_cmpt_dtl
1043: SET delete_mark = 1,
1044: last_update_date = sysdate,
1045: last_updated_by = p_user_id,
1046: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1082: UPDATE cm_cmpt_dtl

1078: END IF ;
1079: ELSE -- cmpntcost_id is not passed
1080: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1081: THEN
1082: UPDATE cm_cmpt_dtl
1083: SET cmpnt_cost = decode(p_lower_level_dtl_tbl(i).cmpnt_cost, FND_API.G_MISS_NUM, NULL, NULL, cmpnt_cost, p_lower_level_dtl_tbl(i).cmpnt_cost ),
1084: delete_mark = 0,
1085: last_update_date = sysdate,
1086: last_updated_by = p_user_id,

Line 1097: UPDATE cm_cmpt_dtl

1093: AND cost_cmpntcls_id = p_lower_level_dtl_tbl(i).cost_cmpntcls_id
1094: AND cost_analysis_code = p_lower_level_dtl_tbl(i).cost_analysis_code
1095: AND cost_level = 1;
1096: ELSE
1097: UPDATE cm_cmpt_dtl
1098: SET delete_mark = 1,
1099: last_update_date = sysdate,
1100: last_updated_by = p_user_id,
1101: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1228: --| CM_CMPT_DTL |

1224: --+========================================================================+
1225: --| API Name : Get_Item_Cost |
1226: --| TYPE : Private |
1227: --| Function : Retrieve Item Cost based on the input from table |
1228: --| CM_CMPT_DTL |
1229: --| Pre-reqa : None. |
1230: --| Parameters : |
1231: --| IN : |
1232: --| p_api_version IN NUMBER - Required |

Line 1253: --| CURSOR cm_cmpt_dtl modified. Joined cm_cmpt_mst and cm_cmpt_dtl |

1249: --| HISTORY |
1250: --| 01-Mar-01 Uday Moogala - Created |
1251: --| |
1252: --| 16-APR-2009 Uday Phadtare Bug 7631080. |
1253: --| CURSOR cm_cmpt_dtl modified. Joined cm_cmpt_mst and cm_cmpt_dtl |
1254: --| tables to avoid cartesian product. |
1255: --+========================================================================+
1256: -- End of comments
1257: PROCEDURE Get_Item_Cost

Line 1282: CURSOR cm_cmpt_dtl

1278:
1279: /**********
1280: * Cursors *
1281: **********/
1282: CURSOR cm_cmpt_dtl
1283: IS
1284: SELECT cd.cmpntcost_id, cd.cost_cmpntcls_id, cm.cost_cmpntcls_code,
1285: cd.cost_analysis_code, cd.cmpnt_cost, cd.burden_ind,
1286: cd.total_qty, cd.costcalc_orig, cd.rmcalc_type, cd.cost_level,

Line 1295: FROM cm_cmpt_mst cm, cm_cmpt_dtl cd

1291: cd.attribute16, cd.attribute17, cd.attribute18, cd.attribute19,
1292: cd.attribute20, cd.attribute21, cd.attribute22, cd.attribute23,
1293: cd.attribute24, cd.attribute25, cd.attribute26, cd.attribute27,
1294: cd.attribute28, cd.attribute29, cd.attribute30, cd.attribute_category
1295: FROM cm_cmpt_mst cm, cm_cmpt_dtl cd
1296: WHERE cd.inventory_item_id = p_header_rec.inventory_item_id
1297: AND cd.organization_id = p_header_rec.organization_id
1298: AND cd.period_id = p_header_rec.period_id
1299: AND cd.cost_type_id = p_header_rec.cost_type_id

Line 1343: FOR cr_rec IN cm_cmpt_dtl

1339: ' Period Id' || p_header_rec.Period_id ||
1340: ' Cost Type Id ' || p_header_rec.cost_type_id) ;
1341: END IF;
1342:
1343: FOR cr_rec IN cm_cmpt_dtl
1344: LOOP
1345: IF cr_rec.cost_level = 0
1346: THEN
1347: l_idx := l_idx + 1 ;