DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_CMPT_MST

Line 959: --| on cm_cmpt_mst |

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

Line 975: ( p_Cost_Cmpntcls_Id IN cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE

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

Line 984: cm_cmpt_mst

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

Line 989: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;

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

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

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

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

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

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

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

Line 1038: x_usage_ind OUT NOCOPY cm_cmpt_mst.usage_ind%TYPE

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

Line 1046: cm_cmpt_mst

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

Line 1082: --| on cm_cmpt_mst |

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

Line 1098: ( p_Cost_Cmpntcls_Code IN cm_cmpt_mst.Cost_Cmpntcls_Code%TYPE

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

Line 1107: cm_cmpt_mst

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

Line 1112: l_Cost_Cmpntcls_Id cm_cmpt_mst.Cost_Cmpntcls_Id%TYPE ;

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

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

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

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

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

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

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

Line 1162: x_Usage_Ind OUT NOCOPY cm_cmpt_mst.Usage_Ind%TYPE

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

Line 1170: cm_cmpt_mst

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