APPS.PA_PROJECT_CORE1 dependencies on PA_UTILS_SQNUM_PKG

Line 66: PA_UTILS_SQNUM_PKG.get_unique_proj_num('PA_PROJECTS',

62: x_err_code := 10;
63: x_err_stage := 'PA_NO_GEN_MODE';
64: return;
65: elsif proj_number_gen_mode = 'AUTOMATIC' then
66: PA_UTILS_SQNUM_PKG.get_unique_proj_num('PA_PROJECTS',
67: FND_GLOBAL.USER_ID,
68: unique_id,
69: status);
70: if status = 0 then

Line 138: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',

134: PROCEDURE revert_proj_number(p_proj_number_gen_mode IN VARCHAR2,
135: p_project_number IN VARCHAR2 ) IS
136: BEGIN
137: IF p_proj_number_gen_mode = 'AUTOMATIC' THEN
138: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
139: p_user_id => FND_GLOBAL.USER_ID,
140: p_unique_number => TO_NUMBER(p_project_number));
141: END IF;
142: END revert_proj_number;