APPS.GMF_ITEMCOST_PUB dependencies on CM_CMPT_DTL

Line 199: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;

195: l_period_status gmf_period_statuses.period_status%TYPE ;
196: l_cost_type cm_mthd_mst.cost_type%TYPE ;
197: l_prodcalc_type cm_mthd_mst.prodcalc_type%TYPE ;
198: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
199: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;
200: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE ;
201: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ;
202: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;
203: l_rollover_ind cm_cmpt_dtl.rollover_ind%TYPE ;

Line 202: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;

198: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
199: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;
200: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE ;
201: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ;
202: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;
203: l_rollover_ind cm_cmpt_dtl.rollover_ind%TYPE ;
204: l_idx NUMBER(10) := 0 ;
205: e_this_level EXCEPTION ;
206: e_lower_level EXCEPTION ;

Line 203: l_rollover_ind cm_cmpt_dtl.rollover_ind%TYPE ;

199: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;
200: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE ;
201: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ;
202: l_cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE ;
203: l_rollover_ind cm_cmpt_dtl.rollover_ind%TYPE ;
204: l_idx NUMBER(10) := 0 ;
205: e_this_level EXCEPTION ;
206: e_lower_level EXCEPTION ;
207:

Line 482: FROM cm_cmpt_dtl

478: IF (l_period_status = 'F') AND (p_operation = 'INSERT')
479: THEN
480: SELECT NVL(MAX(rollover_ind),0)
481: INTO l_rollover_ind
482: FROM cm_cmpt_dtl
483: WHERE inventory_item_id = x_header_rec.inventory_item_id
484: AND organization_id = x_header_rec.organization_id
485: AND period_id = x_header_rec.period_id
486: AND cost_type_id = x_header_rec.cost_type_id;

Line 1159: --| CM_CMPT_DTL |

1155: --+========================================================================+
1156: --| API Name : Create_Item_Cost |
1157: --| TYPE : Public |
1158: --| Function : Creates a new Item Cost based on the input into table |
1159: --| CM_CMPT_DTL |
1160: --| Pre-reqa : None. |
1161: --| Parameters : |
1162: --| IN : |
1163: --| p_api_version IN NUMBER - Required |

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

1397: --Start of comments
1398: --+========================================================================+
1399: --| API Name : Update_Item_Cost |
1400: --| TYPE : Public |
1401: --| Function : Updates Item Cost based on the input into CM_CMPT_DTL |
1402: --| Pre-reqa : None. |
1403: --| Parameters : |
1404: --| IN : |
1405: --| p_api_version IN NUMBER - Required |

Line 1639: --| Function : Deletes Item Cost based on the input from CM_CMPT_DTL |

1635: --Start of comments
1636: --+========================================================================+
1637: --| API Name : Delete_Item_Cost |
1638: --| TYPE : Public |
1639: --| Function : Deletes Item Cost based on the input from CM_CMPT_DTL |
1640: --| Pre-reqa : None. |
1641: --| Parameters : |
1642: --| IN : |
1643: --| p_api_version IN NUMBER - Required |

Line 1880: --| CM_CMPT_DTL |

1876: --+========================================================================+
1877: --| API Name : Get_Item_Cost |
1878: --| TYPE : Public |
1879: --| Function : Retrieve Item Cost based on the input from table |
1880: --| CM_CMPT_DTL |
1881: --| Pre-reqa : None. |
1882: --| Parameters : |
1883: --| IN : |
1884: --| p_api_version IN NUMBER - Required |

Line 1931: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;

1927: l_data VARCHAR2(2000) ;
1928: l_header_rec Header_Rec_Type ;
1929: l_period_status gmf_period_statuses.period_status%TYPE ;
1930: l_cost_type cm_mthd_mst.cost_type%TYPE ;
1931: l_rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE ;
1932: l_prodcalc_type cm_mthd_mst.prodcalc_type%TYPE ;
1933: l_user_id fnd_user.user_id%TYPE ;
1934:
1935: BEGIN