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.

[Home] [Help]

APPS.GMF_RESOURCECOST_PUB dependencies on CM_RSRC_DTL

Line 72: though both organization_id and organization_code are NULL because organization_id in CM_RSRC_DTL is not mandatory.

68: --| 19-sep-2005 Prasad marada Inventory convergence modification, adding|
69: --| legal entity, organization id, period id, |
70: --| cost_type_id,usage_uom coulmns |
71: 08-APR-2011 Uday Phadtare. Bug 12333658. Modified code in Validate_Input_Params(). Do not raise ERROR even
72: though both organization_id and organization_code are NULL because organization_id in CM_RSRC_DTL is not mandatory.
73: --| 28-Apr-2011 Pramod B.H. Bug# 12404853
74: --| Modified cursor Cur_rsrc_dtl in function check_records_exist to |
75: --| handle the condition of Organization_id not mandatory in cm_rsrc_dtl|
76: --| 24-12-2011 Smukalla Bug13617803: Modified code to call the procedure, add_header_to_error_stack when

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

71: 08-APR-2011 Uday Phadtare. Bug 12333658. Modified code in Validate_Input_Params(). Do not raise ERROR even
72: though both organization_id and organization_code are NULL because organization_id in CM_RSRC_DTL is not mandatory.
73: --| 28-Apr-2011 Pramod B.H. Bug# 12404853
74: --| Modified cursor Cur_rsrc_dtl in function check_records_exist to |
75: --| handle the condition of Organization_id not mandatory in cm_rsrc_dtl|
76: --| 24-12-2011 Smukalla Bug13617803: Modified code to call the procedure, add_header_to_error_stack when
77: --| check_records_exist returns FALSE
78: --+==========================================================================+
79: End of comments */

Line 94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,

90: --
91: -- Modified the function parameter as per the inventory convergence
92: FUNCTION check_records_exist
93: (
94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
96: p_resources cm_rsrc_dtl.resources%TYPE,
97: p_period_id cm_rsrc_dtl.period_id%TYPE,
98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

Line 95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,

91: -- Modified the function parameter as per the inventory convergence
92: FUNCTION check_records_exist
93: (
94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
96: p_resources cm_rsrc_dtl.resources%TYPE,
97: p_period_id cm_rsrc_dtl.period_id%TYPE,
98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
99: )

Line 96: p_resources cm_rsrc_dtl.resources%TYPE,

92: FUNCTION check_records_exist
93: (
94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
96: p_resources cm_rsrc_dtl.resources%TYPE,
97: p_period_id cm_rsrc_dtl.period_id%TYPE,
98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
99: )
100:

Line 97: p_period_id cm_rsrc_dtl.period_id%TYPE,

93: (
94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
96: p_resources cm_rsrc_dtl.resources%TYPE,
97: p_period_id cm_rsrc_dtl.period_id%TYPE,
98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
99: )
100:
101: RETURN BOOLEAN ;

Line 98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

94: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
95: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
96: p_resources cm_rsrc_dtl.resources%TYPE,
97: p_period_id cm_rsrc_dtl.period_id%TYPE,
98: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
99: )
100:
101: RETURN BOOLEAN ;
102: --

Line 135: --| into table CM_RSRC_DTL |

131: --+========================================================================+
132: --| API Name : Create_Resource_Cost |
133: --| TYPE : Public |
134: --| Function : Creates a new Resource Cost based on the input |
135: --| into table CM_RSRC_DTL |
136: --| Pre-reqa : None. |
137: --| Parameters : |
138: --| IN : |
139: --| p_api_version IN NUMBER - Required |

Line 760: --| CM_RSRC_DTL |

756: --+========================================================================+
757: --| API Name : Get_Resource_Cost |
758: --| TYPE : Public |
759: --| Function : Retrive Resource Cost based on the input from table |
760: --| CM_RSRC_DTL |
761: --| Pre-reqa : None. |
762: --| Parameters : |
763: --| IN : |
764: --| p_api_version IN NUMBER - Required |

Line 931: and organization_code are NULL because organization_id in CM_RSRC_DTL is not mandatory.

927: --| entries |
928: --| 22/Nov/2005 Prasad Marada Bug 4689137,Modified input parameter |
929: --| validation as per datamodel changes |
930: 08-APR-2011 Uday Phadtare. Bug 12333658. Do not raise ERROR even though both organization_id
931: and organization_code are NULL because organization_id in CM_RSRC_DTL is not mandatory.
932: --+==========================================================================+
933: Proc end of comments */
934:
935: PROCEDURE Validate_Input_Params

Line 944: l_resources cm_rsrc_dtl.resources%TYPE ;

940: ,x_return_status OUT NOCOPY VARCHAR2
941: )
942: IS
943:
944: l_resources cm_rsrc_dtl.resources%TYPE ;
945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;

Line 945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;

941: )
942: IS
943:
944: l_resources cm_rsrc_dtl.resources%TYPE ;
945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;

Line 946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;

942: IS
943:
944: l_resources cm_rsrc_dtl.resources%TYPE ;
945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;

Line 948: l_period_id cm_rsrc_dtl.period_id%TYPE;

944: l_resources cm_rsrc_dtl.resources%TYPE ;
945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;

Line 949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;

945: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;

Line 950: l_period_code cm_rsrc_dtl.period_code%TYPE ;

946: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
947: l_organization_code mtl_parameters.organization_code%TYPE;
948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
954: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;

Line 952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;

948: l_period_id cm_rsrc_dtl.period_id%TYPE;
949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
954: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
955: l_nominal_cost NUMBER ;
956: l_delete_mark NUMBER ;

Line 953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;

949: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
954: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
955: l_nominal_cost NUMBER ;
956: l_delete_mark NUMBER ;
957: l_user_name fnd_user.user_name%TYPE ;

Line 954: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;

950: l_period_code cm_rsrc_dtl.period_code%TYPE ;
951: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
952: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
953: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
954: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
955: l_nominal_cost NUMBER ;
956: l_delete_mark NUMBER ;
957: l_user_name fnd_user.user_name%TYPE ;
958: l_user_id NUMBER ;

Line 1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

1440: -- Func end of comments
1441:
1442: FUNCTION check_records_exist
1443: (
1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1446: p_resources IN cm_rsrc_dtl.resources%TYPE,
1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE

Line 1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

1441:
1442: FUNCTION check_records_exist
1443: (
1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1446: p_resources IN cm_rsrc_dtl.resources%TYPE,
1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1449: )

Line 1446: p_resources IN cm_rsrc_dtl.resources%TYPE,

1442: FUNCTION check_records_exist
1443: (
1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1446: p_resources IN cm_rsrc_dtl.resources%TYPE,
1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1449: )
1450: RETURN BOOLEAN

Line 1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

1443: (
1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1446: p_resources IN cm_rsrc_dtl.resources%TYPE,
1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1449: )
1450: RETURN BOOLEAN
1451: IS

Line 1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE

1444: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1445: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1446: p_resources IN cm_rsrc_dtl.resources%TYPE,
1447: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1448: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1449: )
1450: RETURN BOOLEAN
1451: IS
1452: CURSOR Cur_rsrc_dtl

Line 1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,

1449: )
1450: RETURN BOOLEAN
1451: IS
1452: CURSOR Cur_rsrc_dtl
1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1455: cp_resources cm_rsrc_dtl.resources%TYPE ,
1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

Line 1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,

1450: RETURN BOOLEAN
1451: IS
1452: CURSOR Cur_rsrc_dtl
1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1455: cp_resources cm_rsrc_dtl.resources%TYPE ,
1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1458: ) IS

Line 1455: cp_resources cm_rsrc_dtl.resources%TYPE ,

1451: IS
1452: CURSOR Cur_rsrc_dtl
1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1455: cp_resources cm_rsrc_dtl.resources%TYPE ,
1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1458: ) IS
1459: SELECT 'x'

Line 1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,

1452: CURSOR Cur_rsrc_dtl
1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1455: cp_resources cm_rsrc_dtl.resources%TYPE ,
1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1458: ) IS
1459: SELECT 'x'
1460: FROM cm_rsrc_dtl

Line 1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

1453: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1454: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1455: cp_resources cm_rsrc_dtl.resources%TYPE ,
1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1458: ) IS
1459: SELECT 'x'
1460: FROM cm_rsrc_dtl
1461: WHERE legal_entity_id = cp_legal_entity_id

Line 1460: FROM cm_rsrc_dtl

1456: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1457: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1458: ) IS
1459: SELECT 'x'
1460: FROM cm_rsrc_dtl
1461: WHERE legal_entity_id = cp_legal_entity_id
1462: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
1463: AND organization_id = cp_organization_id */
1464: AND nvl(organization_id,0) = nvl(cp_organization_id,0) /*B12404853*/

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

1458: ) IS
1459: SELECT 'x'
1460: FROM cm_rsrc_dtl
1461: WHERE legal_entity_id = cp_legal_entity_id
1462: /*B12404853 - Added nvl as Organization_id is not mandatory in cm_rsrc_dtl (Refer B12333658)
1463: AND organization_id = cp_organization_id */
1464: AND nvl(organization_id,0) = nvl(cp_organization_id,0) /*B12404853*/
1465: AND resources = cp_resources
1466: AND period_id = cp_period_id