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.

APPS.JAI_PA_BILLING_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,

127: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
128: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
129: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
130: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
132: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
133:
134:
135: Entry 2 for ExciseEducation Cess

Line 371: pr_draft_invoice IN PA_DRAFT_INVOICES_ALL%rowtype,

367:
368: procedure process_draft_invoice_release(
369: --pn_project_id IN NUMBER,
370: --pn_draft_invoice_num IN NUMBER,
371: pr_draft_invoice IN PA_DRAFT_INVOICES_ALL%rowtype,
372: pv_called_from IN VARCHAR2,
373: pv_process_flag OUT NOCOPY VARCHAR2,
374: pv_process_message OUT NOCOPY VARCHAR2
375: ) is

Line 433: pr_pa_draft_invoices_all => pr_draft_invoice ,

429: process_excise(
430: --pn_project_id => pr_draft_invoice.project_id ,
431: --pn_draft_invoice_num => pr_draft_invoice.draft_invoice_num ,
432: -- pn_draft_invoice_id => r_draft_invoice_dtls.draft_invoice_id ,
433: pr_pa_draft_invoices_all => pr_draft_invoice ,
434: pv_called_from => pv_called_from||'.process_draft_invoice_release' ,
435: pv_process_flag => pv_process_flag ,
436: pv_process_message => pv_process_message
437: ) ;

Line 676: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype ,

672:
673:
674: PROCEDURE process_excise
675: (
676: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype ,
677: pv_called_from IN varchar2 ,
678: pv_process_flag OUT nocopy varchar2 ,
679: pv_process_message OUT nocopy varchar2
680: )

Line 690: where project_id = pr_pa_draft_invoices_all.project_id

686: ,location_id
687: ,draft_invoice_num
688: ,project_id
689: from jai_pa_draft_invoices
690: where project_id = pr_pa_draft_invoices_all.project_id
691: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;
692:
693:
694: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is

Line 691: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;

687: ,draft_invoice_num
688: ,project_id
689: from jai_pa_draft_invoices
690: where project_id = pr_pa_draft_invoices_all.project_id
691: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;
692:
693:
694: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is
695: select 'Y'

Line 804: open c_draft_invoice_dtls(pr_pa_draft_invoices_all.project_id, pr_pa_draft_invoices_all.draft_invoice_num);

800: ld_transaction_date := sysdate;
801: lv_credit_memo_flag := jai_constants.no;
802:
803: /* Get IL related info for the project invoice. */
804: open c_draft_invoice_dtls(pr_pa_draft_invoices_all.project_id, pr_pa_draft_invoices_all.draft_invoice_num);
805: fetch c_draft_invoice_dtls into r_jai_pa_draft_invoices;
806: close c_draft_invoice_dtls;
807:
808: if r_jai_pa_draft_invoices.parent_draft_invoice_id is not null then

Line 916: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then

912: end if;
913:
914: end if;
915:
916: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then

Line 917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;

913:
914: end if;
915:
916: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;

Line 918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;

914: end if;
915:
916: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
922: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;

Line 920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then

916: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
922: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
923:
924: end if;

Line 921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;

917: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
922: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
923:
924: end if;
925:

Line 922: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;

918: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
919:
920: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
921: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
922: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
923:
924: end if;
925:
926: /* Derive the required accounts */

Line 950: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;

946: else
947: lv_rg23_part_ii_reg_type := 'C';
948: end if;
949:
950: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
951:
952: if jai_pa_billing_pkg.gv_debug then
953: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
954: );

Line 1172: r_gl_entry.set_of_books_id := get_sob_id(pr_pa_draft_invoices_all.org_id); -- gl_sets_of_books.set_of_books_id%type,

1168: /* r_gl_entry.je_source := 'Project Accounting'; -- gl_je_headers.je_source%type, */
1169: --r_gl_entry.je_source := 'Receivables India';
1170: r_gl_entry.je_source := jai_constants.pa_je_source; --Added by bgowrava for Bug#6012570
1171: r_gl_entry.je_category := jai_constants.je_category_rg_entry; -- gl_je_headers.je_category%type,
1172: r_gl_entry.set_of_books_id := get_sob_id(pr_pa_draft_invoices_all.org_id); -- gl_sets_of_books.set_of_books_id%type,
1173: r_gl_entry.currency_code := jai_constants.func_curr; -- gl_currencies.currency_code%type,
1174: r_gl_entry.currency_conv_rate := null; -- number,
1175: r_gl_entry.currency_conv_date := null; -- date,
1176: r_gl_entry.accounting_date := trunc(sysdate); -- date,