APPS.GMF_RESOURCECOST_PVT dependencies on CM_RSRC_DTL

Line 45: --| handle the condition of Organization_id not mandatory in cm_rsrc_dtl|

41: --| number to find the fixes. |
42: --| 22/Nov/2005 Prasad Marada Bug 4689137, API changes for convergence |
43: --| 28-Apr-2011 Pramod B.H. Bug# 12404853 |
44: --| Modified procedures Update_Resource_Cost and Get_Resource_Cost to |
45: --| handle the condition of Organization_id not mandatory in cm_rsrc_dtl|
46: --+==========================================================================+
47: -- End of comments
48:
49: --

Line 70: --| into table CM_RSRC_DTL |

66: --+========================================================================+
67: --| API Name : Create_Resource_Cost |
68: --| TYPE : Private |
69: --| Function : Creates a new Resource Cost based on the input |
70: --| into table CM_RSRC_DTL |
71: --| Pre-reqa : None. |
72: --| Parameters : |
73: --| IN : |
74: --| p_api_version IN NUMBER - Required |

Line 145: INSERT INTO cm_rsrc_dtl

141: ' Period Id : ' || p_resource_cost_rec.period_id ||
142: ' Cost type id : '|| p_resource_cost_rec.cost_type_id);
143: END IF;
144:
145: INSERT INTO cm_rsrc_dtl
146: (
147: resources
148: , nominal_cost
149: , text_code

Line 238: --| into CM_RSRC_DTL |

234: --+========================================================================+
235: --| API Name : Update_Resource_Cost |
236: --| TYPE : Private |
237: --| Function : Updates Resource Cost based on the input |
238: --| into CM_RSRC_DTL |
239: --| Pre-reqa : None. |
240: --| Parameters : |
241: --| IN : |
242: --| p_api_version IN NUMBER - Required |

Line 313: UPDATE cm_rsrc_dtl

309: ' Period Id : ' || p_resource_cost_rec.period_id ||
310: ' Cost type id : '|| p_resource_cost_rec.cost_type_id);
311: END IF;
312:
313: UPDATE cm_rsrc_dtl
314: SET
315: -- Modified uage_um to usage_uom by pmarada
316: usage_uom = decode(p_resource_cost_rec.usage_uom,
317: FND_API.G_MISS_CHAR, NULL,

Line 333: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)

329: ,last_updated_by = p_user_id
330: ,last_update_login = FND_GLOBAL.LOGIN_ID
331: WHERE
332: legal_entity_id = p_resource_cost_rec.legal_entity_id
333: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
334: AND organization_id = p_resource_cost_rec.organization_id */
335: AND nvl(organization_id,0) = nvl(p_resource_cost_rec.organization_id, 0) /*B12404853*/
336: AND resources = p_resource_cost_rec.resources
337: AND period_id = p_resource_cost_rec.period_id

Line 390: --| CM_RSRC_DTL |

386: --+========================================================================+
387: --| API Name : Get_Resource_Cost |
388: --| TYPE : Private |
389: --| Function : Retrive Resource Cost based on the input from table |
390: --| CM_RSRC_DTL |
391: --| Pre-reqa : None. |
392: --| Parameters : |
393: --| IN : |
394: --| p_api_version IN NUMBER - Required |

Line 488: fnd_user f, cm_rsrc_dtl r

484: , x_resource_cost_rec.nominal_cost
485: , x_resource_cost_rec.delete_mark
486: , x_resource_cost_rec.user_name
487: FROM
488: fnd_user f, cm_rsrc_dtl r
489: WHERE
490: legal_entity_id = p_resource_cost_rec.legal_entity_id
491: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
492: AND organization_id = p_resource_cost_rec.organization_id */

Line 491: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)

487: FROM
488: fnd_user f, cm_rsrc_dtl r
489: WHERE
490: legal_entity_id = p_resource_cost_rec.legal_entity_id
491: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
492: AND organization_id = p_resource_cost_rec.organization_id */
493: AND nvl(organization_id,0) = nvl(p_resource_cost_rec.organization_id,0) /*B12404853*/
494: AND resources = p_resource_cost_rec.resources
495: AND period_id = p_resource_cost_rec.period_id