APPS.GMS_POR_API dependencies on GMS_IMPLEMENTATIONS

Line 48: FROM gms_implementations

44: and adl.award_id = a.award_id ;
45:
46: CURSOR c_check_award IS
47: SELECT default_dist_award_number
48: FROM gms_implementations
49: WHERE enabled ='Y'
50: and award_distribution_option = 'Y'
51: and default_dist_award_id = X_award_id ;
52:

Line 163: FROM gms_implementations

159: and adl.adl_line_num = 1 ;
160:
161: CURSOR c_check_award IS
162: SELECT default_dist_award_id
163: FROM gms_implementations
164: WHERE enabled ='Y'
165: and award_distribution_option = 'Y'
166: and default_dist_award_number = X_award_number ;
167:

Line 323: FROM gms_implementations

319: CURSOR c_check_award IS
320: SELECT default_dist_award_id,
321: award_distribution_option,
322: default_dist_award_number
323: FROM gms_implementations
324: WHERE enabled ='Y' ;
325:
326: cursor valid_award_csr is
327: select 'Y'

Line 1134: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;

1130: PROCEDURE get_award_dist_param (p_award_dist_option OUT NOCOPY VARCHAR2,
1131: p_dist_award_number OUT NOCOPY VARCHAR2,
1132: p_dist_award_id OUT NOCOPY NUMBER )
1133: IS
1134: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
1135: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
1136: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
1137: CURSOR c_default_award IS
1138: SELECT award_distribution_option,

Line 1135: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;

1131: p_dist_award_number OUT NOCOPY VARCHAR2,
1132: p_dist_award_id OUT NOCOPY NUMBER )
1133: IS
1134: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
1135: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
1136: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
1137: CURSOR c_default_award IS
1138: SELECT award_distribution_option,
1139: default_dist_award_number,

Line 1136: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;

1132: p_dist_award_id OUT NOCOPY NUMBER )
1133: IS
1134: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
1135: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
1136: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
1137: CURSOR c_default_award IS
1138: SELECT award_distribution_option,
1139: default_dist_award_number,
1140: default_dist_award_id

Line 1141: FROM gms_implementations

1137: CURSOR c_default_award IS
1138: SELECT award_distribution_option,
1139: default_dist_award_number,
1140: default_dist_award_id
1141: FROM gms_implementations
1142: WHERE enabled ='Y';
1143:
1144: BEGIN
1145:

Line 1191: FROM gms_implementations

1187: l_err_msg VARCHAR2(2000);
1188:
1189: CURSOR c_check_award IS
1190: SELECT default_dist_award_id
1191: FROM gms_implementations
1192: WHERE enabled ='Y'
1193: AND award_distribution_option ='Y';
1194:
1195: CURSOR check_fund_pattern is