DBA Data[Home] [Help]

APPS.GMS_POR_API dependencies on GMS_IMPLEMENTATIONS_ALL

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