eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PA_DRAFT_INVOICE_LINES

Line 931: ,jai_pa_draft_invoice_lines jpadil

927: PA_DRAFT_INVOICES_ALL padi,
928: PA_PROJECTS_ALL p
929: ,pa_draft_invoice_items padil
930: ,jai_pa_draft_invoices jpadi
931: ,jai_pa_draft_invoice_lines jpadil
932: ,PA_CUSTOMERS_V c
933: where jpadi.draft_invoice_id = p_document_id
934: and jpadil.draft_invoice_line_id = p_document_line_id
935: and jpadi.draft_invoice_id = jpadil.draft_invoice_id

Line 1833: update jai_pa_draft_invoice_lines

1829:
1830: -- Begin 5876390, 6012570
1831: elsif rec.transaction_source = 'PROJECTS' then
1832:
1833: update jai_pa_draft_invoice_lines
1834: set service_type_code = rec.service_type_code
1835: , last_update_date = sysdate
1836: , last_updated_by = lv_user_id
1837: , last_update_login = lv_login_id

Line 1978: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type

1974: where customer_trx_id = cp_customer_trx_id ;
1975:
1976: -- Begin 5876390, 6012570
1977: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
1978: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
1979: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
1980: )
1981: is
1982: select draft_invoice_id

Line 1979: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type

1975:
1976: -- Begin 5876390, 6012570
1977: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
1978: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
1979: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
1980: )
1981: is
1982: select draft_invoice_id
1983: ,draft_invoice_line_id

Line 1984: from jai_pa_draft_invoice_lines jpdil

1980: )
1981: is
1982: select draft_invoice_id
1983: ,draft_invoice_line_id
1984: from jai_pa_draft_invoice_lines jpdil
1985: ,pa_projects_all ppa
1986: where ppa.segment1 = cp_project_number
1987: and ppa.project_id = jpdil.project_id
1988: and jpdil.draft_invoice_num = cp_draft_inv_num

Line 1991: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;

1987: and ppa.project_id = jpdil.project_id
1988: and jpdil.draft_invoice_num = cp_draft_inv_num
1989: and jpdil.line_num = cp_line_num;
1990:
1991: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;
1992: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;
1993:
1994: -- End 5876390, 6012570
1995:

Line 1992: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;

1988: and jpdil.draft_invoice_num = cp_draft_inv_num
1989: and jpdil.line_num = cp_line_num;
1990:
1991: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type;
1992: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type;
1993:
1994: -- End 5876390, 6012570
1995:
1996: /* Cursor Added by vkantamn for Bug#6083978 */