APPS.PA_IC_INV_UTILS dependencies on PA_DRAFT_INVOICES

Line 116: FROM pa_draft_invoices DI

112: X_new_invoice_num OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
113:
114: CURSOR C_NEW_INVOICE_NUM IS
115: SELECT nvl(MAX(draft_invoice_num),0) + 1
116: FROM pa_draft_invoices DI
117: WHERE DI.project_id = P_project_id;
118:
119: CURSOR C_ERR_INVOICE_NUM IS
120: SELECT DI.draft_invoice_num

Line 121: FROM pa_draft_invoices DI

117: WHERE DI.project_id = P_project_id;
118:
119: CURSOR C_ERR_INVOICE_NUM IS
120: SELECT DI.draft_invoice_num
121: FROM pa_draft_invoices DI
122: WHERE DI.Project_ID = P_project_id
123: AND DI.draft_invoice_num
124: =
125: ( select min(draft_invoice_num)

Line 126: from pa_draft_invoices

122: WHERE DI.Project_ID = P_project_id
123: AND DI.draft_invoice_num
124: =
125: ( select min(draft_invoice_num)
126: from pa_draft_invoices
127: where project_id = P_project_id
128: AND request_id = P_request_id
129: AND generation_error_flag = 'Y'
130: );

Line 195: Update pa_draft_invoices

191: IF g1_debug_mode = 'Y' THEN
192: pa_ic_inv_utils.log_message('Get_Next_Draft_Inv_Num: ' || 'error invoice_num = '||l_err_invoice_num);
193: END IF;
194:
195: Update pa_draft_invoices
196: set draft_invoice_num = l_new_invoice_num,
197: last_update_date = SYSDATE,
198: last_update_login = l_user_id
199: where project_id = P_Project_Id

Line 370: delete pa_draft_invoices_all

366: IF (P_REJN_LOOKUP_CODE = 'NO_INV_LINES' and l_cnt = 0 ) THEN
367: pa_ic_inv_utils.log_message('Deleting invoice');
368: /*pa_ic_inv_del.delete_invoices(p_project_id);*/
369: /*Fix for Bug 7433201*/
370: delete pa_draft_invoices_all
371: where project_id = p_project_id
372: AND draft_invoice_num = P_DRAFT_INVOICE_NUM;
373: /*End of fix for Bug 7433201*/
374: pa_ic_inv_utils.log_message('Done Deleting invoice');

Line 396: Update pa_draft_invoices

392: when OTHERS then
393: raise;
394: end;
395:
396: Update pa_draft_invoices
397: set generation_error_flag = 'Y',
398: last_update_date = SYSDATE,
399: last_update_login = l_user_id,
400: request_id = l_request_id,

Line 599: FROM PA_DRAFT_INVOICES DI

595: WHERE DID.PROJECT_ID = P_PROJECT_ID
596: AND DID.INVOICED_FLAG = 'N'
597: AND NOT EXISTS
598: ( SELECT 'X'
599: FROM PA_DRAFT_INVOICES DI
600: WHERE DI.PROJECT_ID = P_PROJECT_ID
601: AND DI.RELEASED_BY_PERSON_ID IS NULL
602: AND DI.CC_PROJECT_ID = DID.CC_PROJECT_ID )
603: ;

Line 607: FROM PA_DRAFT_INVOICES DI

603: ;
604:
605: CURSOR C_UNREL_INV IS
606: SELECT 'X'
607: FROM PA_DRAFT_INVOICES DI
608: WHERE DI.PROJECT_ID = P_PROJECT_ID
609: AND DI.RELEASED_BY_PERSON_ID IS NULL
610: ;
611:

Line 673: -- Update pa_draft_invoices with creation date so that the

669: P_REQUEST_ID IN NUMBER ,
670: P_PROJECT_ID IN NUMBER) AS
671: begin
672:
673: -- Update pa_draft_invoices with creation date so that the
674: -- trigger on this table is fired and creates MRC rows
675: pa_debug.g_err_stage := ' In Update_DI_for_MRC ';
676: IF g1_debug_mode = 'Y' THEN
677: pa_ic_inv_utils.log_message('Update_DI_for_MRC: ' || pa_debug.g_err_stage);

Line 680: update pa_draft_invoices

676: IF g1_debug_mode = 'Y' THEN
677: pa_ic_inv_utils.log_message('Update_DI_for_MRC: ' || pa_debug.g_err_stage);
678: END IF;
679:
680: update pa_draft_invoices
681: set creation_date = creation_date
682: where project_id = P_PROJECT_ID
683: and request_id = P_request_id
684: and draft_invoice_num = P_draft_invoice_num;