APPS.GMS_BILLING_ADJUSTMENTS dependencies on PA_DRAFT_INVOICE_ITEMS

Line 238: from pa_draft_invoice_items pdii,

234: X_Err_Buff IN OUT NOCOPY VARCHAR2) IS
235: Cursor c_invoice_lines is
236: select pdii.event_num event_num,
237: -1*pdii.amount amount
238: from pa_draft_invoice_items pdii,
239: pa_draft_invoices pdi
240: where pdi.project_id = X_Award_Project_Id
241: and pdi.request_id = g_request_id
242: and pdii.project_id = pdi.project_id

Line 382: from pa_draft_invoice_items

378: Cursor Get_Invoice_Items is
379: Select project_id,
380: event_num,
381: -1*amount
382: from pa_draft_invoice_items
383: where draft_invoice_num = X_Draft_Invoice_Num
384: and project_id = X_Award_Project_Id;
385:
386: F_invoice_project_id pa_draft_invoice_items.project_id%type;

Line 386: F_invoice_project_id pa_draft_invoice_items.project_id%type;

382: from pa_draft_invoice_items
383: where draft_invoice_num = X_Draft_Invoice_Num
384: and project_id = X_Award_Project_Id;
385:
386: F_invoice_project_id pa_draft_invoice_items.project_id%type;
387: F_invoice_event_num pa_draft_invoice_items.event_num%type;
388: F_invoice_amount pa_draft_invoice_items.amount%type;
389:
390: Cursor Get_Gms_Event_Lines is

Line 387: F_invoice_event_num pa_draft_invoice_items.event_num%type;

383: where draft_invoice_num = X_Draft_Invoice_Num
384: and project_id = X_Award_Project_Id;
385:
386: F_invoice_project_id pa_draft_invoice_items.project_id%type;
387: F_invoice_event_num pa_draft_invoice_items.event_num%type;
388: F_invoice_amount pa_draft_invoice_items.amount%type;
389:
390: Cursor Get_Gms_Event_Lines is
391: Select project_id,

Line 388: F_invoice_amount pa_draft_invoice_items.amount%type;

384: and project_id = X_Award_Project_Id;
385:
386: F_invoice_project_id pa_draft_invoice_items.project_id%type;
387: F_invoice_event_num pa_draft_invoice_items.event_num%type;
388: F_invoice_amount pa_draft_invoice_items.amount%type;
389:
390: Cursor Get_Gms_Event_Lines is
391: Select project_id,
392: event_num,

Line 1166: pa_draft_invoice_items

1162: line_num,
1163: event_num,
1164: amount
1165: from
1166: pa_draft_invoice_items
1167: where
1168: draft_invoice_num = St_Draft_Invoice_Num and
1169: project_id = St_Award_Project_Id;
1170:

Line 1302: LOOP -- Loop for PA_DRAFT_INVOICE_ITEMS

1298: ,x_message =>'In WRITE_OFF_FLAG = N'
1299: ,x_error_message => X_Err_Msg
1300: ,x_status => X_Status); */
1301:
1302: LOOP -- Loop for PA_DRAFT_INVOICE_ITEMS
1303: FETCH
1304: GET_INV_ITEMS
1305: into
1306: F_Award_Project_Id,

Line 1561: End LOOP; -- End Loop for PA_DRAFT_INVOICE_ITEMS

1557: End;
1558:
1559: End If; -- End of If for Event_Type_Classification('Manual' or 'Automatic')
1560:
1561: End LOOP; -- End Loop for PA_DRAFT_INVOICE_ITEMS
1562:
1563: CLOSE GET_INV_ITEMS;
1564:
1565: X_Err_Code := 0;