451: ln_set_of_books_id number;
452: ld_accounting_date date;
453: lv_organization_code org_organization_definitions.organization_code%type;
454: lv_reference_entry varchar2(240) := 'India Localization Entry';
455: lv_reference_1 gl_interface.reference1%type;
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
452: ld_accounting_date date;
453: lv_organization_code org_organization_definitions.organization_code%type;
454: lv_reference_entry varchar2(240) := 'India Localization Entry';
455: lv_reference_1 gl_interface.reference1%type;
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
453: lv_organization_code org_organization_definitions.organization_code%type;
454: lv_reference_entry varchar2(240) := 'India Localization Entry';
455: lv_reference_1 gl_interface.reference1%type;
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
461: lv_reference_27 gl_interface.reference27%type;
454: lv_reference_entry varchar2(240) := 'India Localization Entry';
455: lv_reference_1 gl_interface.reference1%type;
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
461: lv_reference_27 gl_interface.reference27%type;
462:
455: lv_reference_1 gl_interface.reference1%type;
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
461: lv_reference_27 gl_interface.reference27%type;
462:
463: cursor cur_curr_code (cpn_Set_of_books_id fnd_currencies.currency_code%type )is
456: lv_reference_10 gl_interface.reference10%type;
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
461: lv_reference_27 gl_interface.reference27%type;
462:
463: cursor cur_curr_code (cpn_Set_of_books_id fnd_currencies.currency_code%type )is
464: select currency_Code
457: lv_reference_23 gl_interface.reference23%type;
458: lv_reference_24 gl_interface.reference24%type;
459: lv_reference_25 gl_interface.reference25%type;
460: lv_reference_26 gl_interface.reference26%type;
461: lv_reference_27 gl_interface.reference27%type;
462:
463: cursor cur_curr_code (cpn_Set_of_books_id fnd_currencies.currency_code%type )is
464: select currency_Code
465: from gl_Sets_of_books
526: IF NVL(pn_credit_amount, 0) <> 0 OR
527: NVL(pn_debit_amount, 0) <> 0
528: THEN
529:
530: INSERT into gl_interface
531: (status,
532: set_of_books_id,
533: user_je_source_name,
534: user_je_category_name,