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_RESOURCECOST_PUB dependencies on CM_RSRC_DTL

Line 87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,

83: --
84: -- Modified the function parameter as per the inventory convergence
85: FUNCTION check_records_exist
86: (
87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
89: p_resources cm_rsrc_dtl.resources%TYPE,
90: p_period_id cm_rsrc_dtl.period_id%TYPE,
91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

Line 88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,

84: -- Modified the function parameter as per the inventory convergence
85: FUNCTION check_records_exist
86: (
87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
89: p_resources cm_rsrc_dtl.resources%TYPE,
90: p_period_id cm_rsrc_dtl.period_id%TYPE,
91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
92: )

Line 89: p_resources cm_rsrc_dtl.resources%TYPE,

85: FUNCTION check_records_exist
86: (
87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
89: p_resources cm_rsrc_dtl.resources%TYPE,
90: p_period_id cm_rsrc_dtl.period_id%TYPE,
91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
92: )
93:

Line 90: p_period_id cm_rsrc_dtl.period_id%TYPE,

86: (
87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
89: p_resources cm_rsrc_dtl.resources%TYPE,
90: p_period_id cm_rsrc_dtl.period_id%TYPE,
91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
92: )
93:
94: RETURN BOOLEAN ;

Line 91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

87: p_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
88: p_organization_id cm_rsrc_dtl.organization_id%TYPE,
89: p_resources cm_rsrc_dtl.resources%TYPE,
90: p_period_id cm_rsrc_dtl.period_id%TYPE,
91: p_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
92: )
93:
94: RETURN BOOLEAN ;
95: --

Line 128: --| into table CM_RSRC_DTL |

124: --+========================================================================+
125: --| API Name : Create_Resource_Cost |
126: --| TYPE : Public |
127: --| Function : Creates a new Resource Cost based on the input |
128: --| into table CM_RSRC_DTL |
129: --| Pre-reqa : None. |
130: --| Parameters : |
131: --| IN : |
132: --| p_api_version IN NUMBER - Required |

Line 752: --| CM_RSRC_DTL |

748: --+========================================================================+
749: --| API Name : Get_Resource_Cost |
750: --| TYPE : Public |
751: --| Function : Retrive Resource Cost based on the input from table |
752: --| CM_RSRC_DTL |
753: --| Pre-reqa : None. |
754: --| Parameters : |
755: --| IN : |
756: --| p_api_version IN NUMBER - Required |

Line 934: l_resources cm_rsrc_dtl.resources%TYPE ;

930: ,x_return_status OUT NOCOPY VARCHAR2
931: )
932: IS
933:
934: l_resources cm_rsrc_dtl.resources%TYPE ;
935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;

Line 935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;

931: )
932: IS
933:
934: l_resources cm_rsrc_dtl.resources%TYPE ;
935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;

Line 936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;

932: IS
933:
934: l_resources cm_rsrc_dtl.resources%TYPE ;
935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;

Line 938: l_period_id cm_rsrc_dtl.period_id%TYPE;

934: l_resources cm_rsrc_dtl.resources%TYPE ;
935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;

Line 939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;

935: l_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE;
936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;

Line 940: l_period_code cm_rsrc_dtl.period_code%TYPE ;

936: l_organization_id cm_rsrc_dtl.organization_id%TYPE;
937: l_organization_code mtl_parameters.organization_code%TYPE;
938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
944: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;

Line 942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;

938: l_period_id cm_rsrc_dtl.period_id%TYPE;
939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
944: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
945: l_nominal_cost NUMBER ;
946: l_delete_mark NUMBER ;

Line 943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;

939: l_calendar_code cm_rsrc_dtl.calendar_code%TYPE ;
940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
944: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
945: l_nominal_cost NUMBER ;
946: l_delete_mark NUMBER ;
947: l_user_name fnd_user.user_name%TYPE ;

Line 944: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;

940: l_period_code cm_rsrc_dtl.period_code%TYPE ;
941: -- l_period_status cm_cldr_dtl.period_status%TYPE ;
942: l_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE;
943: l_cost_type_code cm_rsrc_dtl.cost_mthd_code%TYPE ;
944: l_usage_uom cm_rsrc_dtl.usage_uom%TYPE ;
945: l_nominal_cost NUMBER ;
946: l_delete_mark NUMBER ;
947: l_user_name fnd_user.user_name%TYPE ;
948: l_user_id NUMBER ;

Line 1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,

1406: -- Func end of comments
1407:
1408: FUNCTION check_records_exist
1409: (
1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1412: p_resources IN cm_rsrc_dtl.resources%TYPE,
1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE

Line 1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,

1407:
1408: FUNCTION check_records_exist
1409: (
1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1412: p_resources IN cm_rsrc_dtl.resources%TYPE,
1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1415: )

Line 1412: p_resources IN cm_rsrc_dtl.resources%TYPE,

1408: FUNCTION check_records_exist
1409: (
1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1412: p_resources IN cm_rsrc_dtl.resources%TYPE,
1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1415: )
1416: RETURN BOOLEAN

Line 1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,

1409: (
1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1412: p_resources IN cm_rsrc_dtl.resources%TYPE,
1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1415: )
1416: RETURN BOOLEAN
1417: IS

Line 1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE

1410: p_legal_entity_id IN cm_rsrc_dtl.legal_entity_id%TYPE,
1411: p_organization_id IN cm_rsrc_dtl.organization_id%TYPE,
1412: p_resources IN cm_rsrc_dtl.resources%TYPE,
1413: p_period_id IN cm_rsrc_dtl.period_id%TYPE,
1414: p_cost_type_id IN cm_rsrc_dtl.cost_type_id%TYPE
1415: )
1416: RETURN BOOLEAN
1417: IS
1418: CURSOR Cur_rsrc_dtl

Line 1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,

1415: )
1416: RETURN BOOLEAN
1417: IS
1418: CURSOR Cur_rsrc_dtl
1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1421: cp_resources cm_rsrc_dtl.resources%TYPE ,
1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

Line 1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,

1416: RETURN BOOLEAN
1417: IS
1418: CURSOR Cur_rsrc_dtl
1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1421: cp_resources cm_rsrc_dtl.resources%TYPE ,
1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1424: ) IS

Line 1421: cp_resources cm_rsrc_dtl.resources%TYPE ,

1417: IS
1418: CURSOR Cur_rsrc_dtl
1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1421: cp_resources cm_rsrc_dtl.resources%TYPE ,
1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1424: ) IS
1425: SELECT 'x'

Line 1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,

1418: CURSOR Cur_rsrc_dtl
1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1421: cp_resources cm_rsrc_dtl.resources%TYPE ,
1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1424: ) IS
1425: SELECT 'x'
1426: FROM cm_rsrc_dtl

Line 1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE

1419: ( cp_legal_entity_id cm_rsrc_dtl.legal_entity_id%TYPE,
1420: cp_organization_id cm_rsrc_dtl.organization_id%TYPE ,
1421: cp_resources cm_rsrc_dtl.resources%TYPE ,
1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1424: ) IS
1425: SELECT 'x'
1426: FROM cm_rsrc_dtl
1427: WHERE legal_entity_id = cp_legal_entity_id

Line 1426: FROM cm_rsrc_dtl

1422: cp_period_id cm_rsrc_dtl.period_id%TYPE,
1423: cp_cost_type_id cm_rsrc_dtl.cost_type_id%TYPE
1424: ) IS
1425: SELECT 'x'
1426: FROM cm_rsrc_dtl
1427: WHERE legal_entity_id = cp_legal_entity_id
1428: AND organization_id = cp_organization_id
1429: AND resources = cp_resources
1430: AND period_id = cp_period_id