APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PA_DRAFT_INVOICE_LINES

Line 1599: ,jai_pa_draft_invoice_lines jpadil

1595: PA_DRAFT_INVOICES_ALL padi,
1596: PA_PROJECTS_ALL p
1597: -- ,pa_draft_invoice_items padil Removed by Jia for FP Bug#6691866
1598: ,jai_pa_draft_invoices jpadi
1599: ,jai_pa_draft_invoice_lines jpadil
1600: ,PA_CUSTOMERS_V c
1601: where jpadi.draft_invoice_id = p_document_id
1602: and jpadil.draft_invoice_line_id = p_document_line_id
1603: and jpadi.draft_invoice_id = jpadil.draft_invoice_id

Line 3248: update jai_pa_draft_invoice_lines

3244:
3245: -- Begin 5876390, 6012570
3246: elsif rec.transaction_source = 'PROJECTS' then
3247:
3248: update jai_pa_draft_invoice_lines
3249: set service_type_code = rec.service_type_code
3250: , last_update_date = sysdate
3251: , last_updated_by = lv_user_id
3252: , last_update_login = lv_login_id

Line 3378: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type

3374: where customer_trx_id = cp_customer_trx_id ;
3375:
3376: -- Begin 5876390, 6012570
3377: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
3378: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
3379: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
3380: )
3381: is
3382: select draft_invoice_id

Line 3379: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type

3375:
3376: -- Begin 5876390, 6012570
3377: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
3378: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
3379: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
3380: )
3381: is
3382: select draft_invoice_id
3383: ,draft_invoice_line_id

Line 3384: from jai_pa_draft_invoice_lines jpdil

3380: )
3381: is
3382: select draft_invoice_id
3383: ,draft_invoice_line_id
3384: from jai_pa_draft_invoice_lines jpdil
3385: ,pa_projects_all ppa
3386: where ppa.segment1 = cp_project_number
3387: and ppa.project_id = jpdil.project_id
3388: and jpdil.draft_invoice_num = cp_draft_inv_num

Line 3391: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;

3387: and ppa.project_id = jpdil.project_id
3388: and jpdil.draft_invoice_num = cp_draft_inv_num
3389: and jpdil.line_num = cp_line_num;
3390:
3391: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;
3392: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;
3393:
3394: -- End 5876390, 6012570
3395:

Line 3392: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;

3388: and jpdil.draft_invoice_num = cp_draft_inv_num
3389: and jpdil.line_num = cp_line_num;
3390:
3391: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;
3392: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;
3393:
3394: -- End 5876390, 6012570
3395:
3396: /* Cursor Added by vkantamn for Bug#6083978 */