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 32: + Added paramerter pr_pa_draft_invoices_all to process_vat to fetch GL date of Draft Invoice

28: 6. 05-Jun-2011 Bug 12611009
29: Description: GL Date of PA Draft Invoice is not used to generate VAT Invoice Date, Excise Invoice Date
30: and GL Entry
31: Fix:
32: + Added paramerter pr_pa_draft_invoices_all to process_vat to fetch GL date of Draft Invoice
33: + Used the GL Date of PA Draft Invoice to generate Excise Invoice Date, VAT Invoice Date and
34: GL Interface Entry.
35: ------------------------------------------------------------------------------------------------------------------------------*/
36: --

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

140: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
143: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
144: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
145: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
146:
147:
148: Entry 2 for ExciseEducation Cess

Line 384: pr_draft_invoice IN PA_DRAFT_INVOICES_ALL%rowtype,

380:
381: procedure process_draft_invoice_release(
382: --pn_project_id IN NUMBER,
383: --pn_draft_invoice_num IN NUMBER,
384: pr_draft_invoice IN PA_DRAFT_INVOICES_ALL%rowtype,
385: pv_called_from IN VARCHAR2,
386: pv_process_flag OUT NOCOPY VARCHAR2,
387: pv_process_message OUT NOCOPY VARCHAR2
388: ) is

Line 463: pr_pa_draft_invoices_all => pr_draft_invoice ,

459: process_excise(
460: --pn_project_id => pr_draft_invoice.project_id ,
461: --pn_draft_invoice_num => pr_draft_invoice.draft_invoice_num ,
462: -- pn_draft_invoice_id => r_draft_invoice_dtls.draft_invoice_id ,
463: pr_pa_draft_invoices_all => pr_draft_invoice ,
464: pv_called_from => pv_called_from||'.process_draft_invoice_release' ,
465: pv_process_flag => pv_process_flag ,
466: pv_process_message => pv_process_message
467: ) ;

Line 493: pr_pa_draft_invoices_all => pr_draft_invoice , /Bug 12611009/

489: process_vat(
490: pn_project_id => pr_draft_invoice.project_id ,
491: pn_draft_invoice_num => pr_draft_invoice.draft_invoice_num ,
492: -- pn_draft_invoice_id => r_draft_invoice_dtls.draft_invoice_id ,
493: pr_pa_draft_invoices_all => pr_draft_invoice , /*Bug 12611009*/
494: pv_called_from => pv_called_from ,
495: pv_process_flag => pv_process_flag ,
496: pv_process_message => pv_process_message
497: ) ;

Line 537: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype, /Bug 12611009/

533:
534: procedure process_vat(
535: pn_project_id IN NUMBER,
536: pn_draft_invoice_num IN NUMBER,
537: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype, /*Bug 12611009*/
538: -- pn_draft_invoice_id IN NUMBER,
539: pv_called_from IN VARCHAR2,
540: pv_process_flag OUT NOCOPY VARCHAR2,
541: pv_process_message OUT NOCOPY VARCHAR2

Line 576: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /Bug 12611009 - Fetch GL Date of the PA Draft Invoice/

572: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');
573: end if;
574:
575: lv_credit_memo_flag := jai_constants.no;
576: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /*Bug 12611009 - Fetch GL Date of the PA Draft Invoice*/
577:
578: /* generate vat invoice no */
579: open c_draft_invoice_dtls(pn_project_id, pn_draft_invoice_num);
580: fetch c_draft_invoice_dtls into r_draft_invoice_dtls;

Line 710: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype ,

706:
707:
708: PROCEDURE process_excise
709: (
710: pr_pa_draft_invoices_all IN pa_draft_invoices_all%rowtype ,
711: pv_called_from IN varchar2 ,
712: pv_process_flag OUT nocopy varchar2 ,
713: pv_process_message OUT nocopy varchar2
714: )

Line 724: where project_id = pr_pa_draft_invoices_all.project_id

720: ,location_id
721: ,draft_invoice_num
722: ,project_id
723: from jai_pa_draft_invoices
724: where project_id = pr_pa_draft_invoices_all.project_id
725: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;
726:
727:
728: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is

Line 725: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;

721: ,draft_invoice_num
722: ,project_id
723: from jai_pa_draft_invoices
724: where project_id = pr_pa_draft_invoices_all.project_id
725: and draft_invoice_num = pr_pa_draft_invoices_all.draft_invoice_num;
726:
727:
728: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is
729: select 'Y'

Line 837: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /Bug 12611009 - Fetch GL Date of the PA Draft Invoice/

833: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'
834: lv_exists_excise_tax := jai_constants.no;
835: ld_transaction_date := sysdate;
836: lv_credit_memo_flag := jai_constants.no;
837: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /*Bug 12611009 - Fetch GL Date of the PA Draft Invoice*/
838:
839: /* Get IL related info for the project invoice. */
840: open c_draft_invoice_dtls(pr_pa_draft_invoices_all.project_id, pr_pa_draft_invoices_all.draft_invoice_num);
841: fetch c_draft_invoice_dtls into r_jai_pa_draft_invoices;

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

836: lv_credit_memo_flag := jai_constants.no;
837: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /*Bug 12611009 - Fetch GL Date of the PA Draft Invoice*/
838:
839: /* Get IL related info for the project invoice. */
840: open c_draft_invoice_dtls(pr_pa_draft_invoices_all.project_id, pr_pa_draft_invoices_all.draft_invoice_num);
841: fetch c_draft_invoice_dtls into r_jai_pa_draft_invoices;
842: close c_draft_invoice_dtls;
843:
844: if r_jai_pa_draft_invoices.parent_draft_invoice_id is not null then

Line 952: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then

948: end if;
949:
950: end if;
951:
952: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then

Line 953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;

949:
950: end if;
951:
952: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;

Line 954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;

950: end if;
951:
952: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
958: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;

Line 956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then

952: if pr_pa_draft_invoices_all.ship_to_customer_id is not null then
953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
958: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
959:
960: end if;

Line 957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;

953: ln_customer_id := pr_pa_draft_invoices_all.ship_to_customer_id;
954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
958: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
959:
960: end if;
961:

Line 958: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;

954: ln_customer_site_id := pr_pa_draft_invoices_all.ship_to_address_id;
955:
956: elsif pr_pa_draft_invoices_all.bill_to_customer_id is not null then
957: ln_customer_id := pr_pa_draft_invoices_all.bill_to_customer_id;
958: ln_customer_site_id := pr_pa_draft_invoices_all.bill_to_address_id;
959:
960: end if;
961:
962: /* Derive the required accounts */

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

982: else
983: lv_rg23_part_ii_reg_type := 'C';
984: end if;
985:
986: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
987:
988: if jai_pa_billing_pkg.gv_debug then
989: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
990: );

Line 1208: 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,

1204: /* r_gl_entry.je_source := 'Project Accounting'; -- gl_je_headers.je_source%type, */
1205: --r_gl_entry.je_source := 'Receivables India';
1206: r_gl_entry.je_source := jai_constants.pa_je_source; --Added by bgowrava for Bug#6012570
1207: r_gl_entry.je_category := jai_constants.je_category_rg_entry; -- gl_je_headers.je_category%type,
1208: 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,
1209: r_gl_entry.currency_code := jai_constants.func_curr; -- gl_currencies.currency_code%type,
1210: r_gl_entry.currency_conv_rate := null; -- number,
1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/