DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_CMPT_MST

Line 961: --| on cm_cmpt_mst |

957: --| Validates Cost Component Class ID |
958: --| |
959: --| DESCRIPTION |
960: --| This function validates that the Cost Component Class Id exists |
961: --| on cm_cmpt_mst |
962: --| |
963: --| PARAMETERS |
964: --| p_Cost_Cmpntcls_Id IN NUMBER(10) -- Cost Component Class Id |
965: --| |

Line 977: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE

973: --+==========================================================================+
974: -- Func end of comments
975:
976: FUNCTION Validate_Cost_Cmpntcls_Id
977: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE
978: )
979: RETURN BOOLEAN
980: IS
981: CURSOR Cur_Cost_Cmpntcls_Id

Line 986: cm_cmpt_mst

982: IS
983: SELECT
984: Cost_Cmpntcls_Id
985: FROM
986: cm_cmpt_mst
987: WHERE
988: Cost_Cmpntcls_Id = p_Cost_Cmpntcls_Id
989: AND delete_mark = 0 ;
990:

Line 991: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;

987: WHERE
988: Cost_Cmpntcls_Id = p_Cost_Cmpntcls_Id
989: AND delete_mark = 0 ;
990:
991: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;
992:
993: BEGIN
994:
995: OPEN Cur_Cost_Cmpntcls_Id;

Line 1023: --| on cm_cmpt_mst and returns usage_ind |

1019: --| Validates Cost Component Class ID |
1020: --| |
1021: --| DESCRIPTION |
1022: --| This function validates that the Cost Component Class Id exists |
1023: --| on cm_cmpt_mst and returns usage_ind |
1024: --| |
1025: --| PARAMETERS |
1026: --| p_Cost_Cmpntcls_Id IN NUMBER(10) -- Cost Component Class Id |
1027: --| |

Line 1038: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,

1034: --+==========================================================================+
1035: -- Func end of comments
1036:
1037: PROCEDURE Validate_Cost_Cmpntcls_Id
1038: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1039: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1040: x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE
1041: )
1042: IS

Line 1039: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,

1035: -- Func end of comments
1036:
1037: PROCEDURE Validate_Cost_Cmpntcls_Id
1038: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1039: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1040: x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE
1041: )
1042: IS
1043: CURSOR Cur_Cost_Cmpntcls_Id

Line 1040: x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE

1036:
1037: PROCEDURE Validate_Cost_Cmpntcls_Id
1038: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1039: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1040: x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE
1041: )
1042: IS
1043: CURSOR Cur_Cost_Cmpntcls_Id
1044: IS

Line 1048: cm_cmpt_mst

1044: IS
1045: SELECT
1046: cost_cmpntcls_code, usage_ind
1047: FROM
1048: cm_cmpt_mst
1049: WHERE
1050: Cost_Cmpntcls_Id = p_Cost_Cmpntcls_Id
1051: AND delete_mark = 0 ;
1052:

Line 1084: --| on cm_cmpt_mst |

1080: --| Validates Cost Component Class Code |
1081: --| |
1082: --| DESCRIPTION |
1083: --| This function validates that the Cost Component Class Code exists |
1084: --| on cm_cmpt_mst |
1085: --| |
1086: --| PARAMETERS |
1087: --| p_Cost_Cmpntcls_Code IN NUMBER(10) -- Cost Component Class Code |
1088: --| |

Line 1100: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE

1096: --+==========================================================================+
1097: -- Func end of comments
1098:
1099: FUNCTION Validate_Cost_Cmpntcls_Code
1100: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE
1101: )
1102: RETURN NUMBER
1103: IS
1104: CURSOR Cur_Cost_Cmpntcls_Id

Line 1109: cm_cmpt_mst

1105: IS
1106: SELECT
1107: Cost_Cmpntcls_Id
1108: FROM
1109: cm_cmpt_mst
1110: WHERE
1111: Cost_Cmpntcls_Code = p_Cost_Cmpntcls_Code
1112: AND delete_mark = 0 ;
1113:

Line 1114: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;

1110: WHERE
1111: Cost_Cmpntcls_Code = p_Cost_Cmpntcls_Code
1112: AND delete_mark = 0 ;
1113:
1114: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;
1115:
1116: BEGIN
1117:
1118: OPEN Cur_Cost_Cmpntcls_Id;

Line 1146: --| on cm_cmpt_mst and returns Component Class Id and Usage Indicator. |

1142: --| Validates Cost Component Class Code |
1143: --| |
1144: --| DESCRIPTION |
1145: --| This function validates that the Cost Component Class Code exists |
1146: --| on cm_cmpt_mst and returns Component Class Id and Usage Indicator. |
1147: --| |
1148: --| PARAMETERS |
1149: --| p_Cost_Cmpntcls_Code IN NUMBER(10) -- Cost Component Class Code |
1150: --| |

Line 1162: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,

1158: --+==========================================================================+
1159: -- Func end of comments
1160:
1161: PROCEDURE Validate_Cost_Cmpntcls_Code
1162: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1163: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1164: x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE
1165: )
1166: IS

Line 1163: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,

1159: -- Func end of comments
1160:
1161: PROCEDURE Validate_Cost_Cmpntcls_Code
1162: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1163: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1164: x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE
1165: )
1166: IS
1167: CURSOR Cur_Cost_Cmpntcls_Id

Line 1164: x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE

1160:
1161: PROCEDURE Validate_Cost_Cmpntcls_Code
1162: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE,
1163: x_Cost_Cmpntcls_Id OUT NOCOPY cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE,
1164: x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE
1165: )
1166: IS
1167: CURSOR Cur_Cost_Cmpntcls_Id
1168: IS

Line 1172: cm_cmpt_mst

1168: IS
1169: SELECT
1170: Cost_Cmpntcls_Id, Usage_Ind
1171: FROM
1172: cm_cmpt_mst
1173: WHERE
1174: Cost_Cmpntcls_Code = p_Cost_Cmpntcls_Code
1175: AND delete_mark = 0 ;
1176: