[Home] [Help]
63: --+========================================================================+
64: --| API Name : Create_Resource_Cost |
65: --| TYPE : Private |
66: --| Function : Creates a new Resource Cost based on the input |
67: --| into table CM_RSRC_DTL |
68: --| Pre-reqa : None. |
69: --| Parameters : |
70: --| IN : |
71: --| p_api_version IN NUMBER - Required |
138: ' Period Id : ' || p_resource_cost_rec.period_id ||
139: ' Cost type id : '|| p_resource_cost_rec.cost_type_id);
140: END IF;
141:
142: INSERT INTO cm_rsrc_dtl
143: (
144: resources
145: , nominal_cost
146: , text_code
231: --+========================================================================+
232: --| API Name : Update_Resource_Cost |
233: --| TYPE : Private |
234: --| Function : Updates Resource Cost based on the input |
235: --| into CM_RSRC_DTL |
236: --| Pre-reqa : None. |
237: --| Parameters : |
238: --| IN : |
239: --| p_api_version IN NUMBER - Required |
306: ' Period Id : ' || p_resource_cost_rec.period_id ||
307: ' Cost type id : '|| p_resource_cost_rec.cost_type_id);
308: END IF;
309:
310: UPDATE cm_rsrc_dtl
311: SET
312: -- Modified uage_um to usage_uom by pmarada
313: usage_uom = decode(p_resource_cost_rec.usage_uom,
314: FND_API.G_MISS_CHAR, NULL,
381: --+========================================================================+
382: --| API Name : Get_Resource_Cost |
383: --| TYPE : Private |
384: --| Function : Retrive Resource Cost based on the input from table |
385: --| CM_RSRC_DTL |
386: --| Pre-reqa : None. |
387: --| Parameters : |
388: --| IN : |
389: --| p_api_version IN NUMBER - Required |
479: , x_resource_cost_rec.nominal_cost
480: , x_resource_cost_rec.delete_mark
481: , x_resource_cost_rec.user_name
482: FROM
483: fnd_user f, cm_rsrc_dtl r
484: WHERE
485: legal_entity_id = p_resource_cost_rec.legal_entity_id
486: AND organization_id = p_resource_cost_rec.organization_id
487: AND resources = p_resource_cost_rec.resources