DBA Data[Home] [Help]

APPS.PA_RES_LIST_ASSIGNMENTS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 67: x_err_stage := 'Select pa_resource_list_assignments_s.nextval';

63: X_err_code,
64: X_err_stage,
65: x_err_stack);
66: If W_Assgmt_Id = 0 Then
67: x_err_stage := 'Select pa_resource_list_assignments_s.nextval';
68: Select Pa_Resource_list_Assignments_s.nextval into W_num
69: from Dual;
70: x_err_stage := 'Insert into Pa_Resource_list_assignments ';
71: Insert into Pa_Resource_list_Assignments

Line 68: Select Pa_Resource_list_Assignments_s.nextval into W_num

64: X_err_stage,
65: x_err_stack);
66: If W_Assgmt_Id = 0 Then
67: x_err_stage := 'Select pa_resource_list_assignments_s.nextval';
68: Select Pa_Resource_list_Assignments_s.nextval into W_num
69: from Dual;
70: x_err_stage := 'Insert into Pa_Resource_list_assignments ';
71: Insert into Pa_Resource_list_Assignments
72: (RESOURCE_LIST_ASSIGNMENT_ID,RESOURCE_LIST_ID,PROJECT_ID,

Line 70: x_err_stage := 'Insert into Pa_Resource_list_assignments ';

66: If W_Assgmt_Id = 0 Then
67: x_err_stage := 'Select pa_resource_list_assignments_s.nextval';
68: Select Pa_Resource_list_Assignments_s.nextval into W_num
69: from Dual;
70: x_err_stage := 'Insert into Pa_Resource_list_assignments ';
71: Insert into Pa_Resource_list_Assignments
72: (RESOURCE_LIST_ASSIGNMENT_ID,RESOURCE_LIST_ID,PROJECT_ID,
73: RESOURCE_LIST_CHANGED_FLAG,LAST_UPDATED_BY,LAST_UPDATE_DATE,
74: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,

Line 71: Insert into Pa_Resource_list_Assignments

67: x_err_stage := 'Select pa_resource_list_assignments_s.nextval';
68: Select Pa_Resource_list_Assignments_s.nextval into W_num
69: from Dual;
70: x_err_stage := 'Insert into Pa_Resource_list_assignments ';
71: Insert into Pa_Resource_list_Assignments
72: (RESOURCE_LIST_ASSIGNMENT_ID,RESOURCE_LIST_ID,PROJECT_ID,
73: RESOURCE_LIST_CHANGED_FLAG,LAST_UPDATED_BY,LAST_UPDATE_DATE,
74: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,
75: RESOURCE_LIST_ACCUMULATED_FLAG) Values

Line 101: Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_ASSIGNMENTS

97: x_err_stack IN Out NOCOPY Varchar2 ) Is --File.Sql.39 bug 4440895
98: W_Num Number := 0;
99: Old_stack varchar2(630);
100: Cursor Res_List_Asgmt_Cur is
101: Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_ASSIGNMENTS
102: where Resource_list_Id = X_Resource_List_id and
103: Project_id = X_Project_id;
104: Begin
105: X_err_code := 0;

Line 109: ' PA_RESOURCE_LIST_ASSIGNMENTS '||

105: X_err_code := 0;
106: Old_Stack := X_Err_Stack;
107: X_err_stack := X_err_stack ||'->PA_RES_LIST_ASSIGNMENTS.Get_Rl_Asgmt';
108: x_err_stage := ' Select Resource_List_Assignment_id from '||
109: ' PA_RESOURCE_LIST_ASSIGNMENTS '||
110: To_Char(X_Resource_List_Id);
111: Open Res_List_Asgmt_Cur;
112: Fetch Res_List_Asgmt_Cur into W_Num;
113: If Res_List_Asgmt_Cur%NOTFOUND Then

Line 150: PA_RESOURCE_LIST_ASSIGNMENTS

146: W_Found_Flag Char(1) := 'N';
147: X_row_id Varchar2(19);
148: Cursor Res_List_Asgmt_Cur is
149: Select Project_id,Resource_list_Id from
150: PA_RESOURCE_LIST_ASSIGNMENTS
151: Where Resource_list_Assignment_Id = X_Resource_list_Assgmt_id;
152: Cursor Res_List_Use_Code_Cur is
153: Select Budget_Type_Yn from PA_RESOURCE_LIST_USE_CODES_V where
154: List_Use_Code = X_Use_Code;

Line 167: ' from Pa_Resource_list_Assignments '||

163: X_err_code := 0;
164: Old_Stack := X_Err_Stack;
165: X_err_stack := X_err_stack ||'->PA_RES_LIST_ASSIGNMENTS.Create_Rl_Uses';
166: x_err_stage := 'Select Project_id,Resource_list_Id '||
167: ' from Pa_Resource_list_Assignments '||
168: To_Char(X_Resource_list_Assgmt_id);
169: Open Res_List_Asgmt_Cur;
170: Fetch Res_List_Asgmt_Cur into W_Project_id,W_Asgmt_Res_list_id;
171: If Res_List_Asgmt_Cur%NOTFOUND Then

Line 191: ' PA_RESOURCE_LIST_ASSIGNMENTS '||

187: Return;
188: End If;
189: Close Res_List_Use_Code_Cur;
190: x_err_stage := ' Select Row_id,Resource_List_id from '||
191: ' PA_RESOURCE_LIST_ASSIGNMENTS '||
192: To_Char(X_Project_Id);
193: Open Res_list_uses_cur;
194: Fetch Res_list_uses_cur into W_Row_id,W_usage_Res_list_id;
195: If Res_list_uses_cur%NOTFOUND Then

Line 265: x_err_stage := 'Delete from Pa_Resource_list_assignments ';

261: || To_Char(X_Resource_list_Assgmt_id);
262: Open Res_List_Asgmt_Cur;
263: Fetch Res_List_Asgmt_Cur into W_Assgmt_Id;
264: If Res_List_Asgmt_Cur%NOTFOUND Then
265: x_err_stage := 'Delete from Pa_Resource_list_assignments ';
266: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
267: RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;
268: End If;
269: Close Res_List_Asgmt_Cur;

Line 266: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where

262: Open Res_List_Asgmt_Cur;
263: Fetch Res_List_Asgmt_Cur into W_Assgmt_Id;
264: If Res_List_Asgmt_Cur%NOTFOUND Then
265: x_err_stage := 'Delete from Pa_Resource_list_assignments ';
266: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
267: RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;
268: End If;
269: Close Res_List_Asgmt_Cur;
270: X_err_stack := Old_Stack;

Line 298: x_err_stage := 'Delete from Pa_Resource_list_assignments ';

294: || To_Char(X_Resource_list_Assgmt_id);
295: Open Res_List_Asgmt_Cur;
296: Fetch Res_List_Asgmt_Cur into W_Assgmt_Id;
297: If Res_List_Asgmt_Cur%NOTFOUND Then
298: x_err_stage := 'Delete from Pa_Resource_list_assignments ';
299: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
300: RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;
301: Else
302: x_err_code := 10;

Line 299: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where

295: Open Res_List_Asgmt_Cur;
296: Fetch Res_List_Asgmt_Cur into W_Assgmt_Id;
297: If Res_List_Asgmt_Cur%NOTFOUND Then
298: x_err_stage := 'Delete from Pa_Resource_list_assignments ';
299: Delete from PA_RESOURCE_LIST_ASSIGNMENTS where
300: RESOURCE_LIST_ASSIGNMENT_ID = X_Resource_list_Assgmt_id;
301: Else
302: x_err_code := 10;
303: x_err_stage := 'PA_RE_RL_USES_FOUND';