[Home] [Help]
3625: REM
3626: REM DESCRIPTION Called from trigger JAI_OM_WDD_ARIUD_T1
3627: REM
3628: REM NOTES Passing the accounting entries in the sub-ledger table
3629: REM jai_cmn_journal_entries.
3630: REM +======================================================================+
3631: */
3632:
3633: /* Changes for Bug 10213327 by abezgam START*/
3836: p_reference_25 => lv_reference_25 ,
3837: p_reference_26 => lv_reference_26
3838: );
3839:
3840: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
3841: (JOURNAL_ENTRY_ID,
3842: regime_code,
3843: organization_id,
3844: set_of_books_id,
3862: last_updated_by,
3863: last_update_login
3864: )
3865: VALUES
3866: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
3867: lv_regime_code,
3868: pr_trig_row.organization_id,
3869: v_set_of_books_id,
3870: NULL,
3913: p_reference_25 => lv_reference_25 ,
3914: p_reference_26 => lv_reference_26
3915: );
3916:
3917: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
3918: (JOURNAL_ENTRY_ID,
3919: regime_code,
3920: organization_id,
3921: set_of_books_id,
3939: last_updated_by,
3940: last_update_login
3941: )
3942: VALUES
3943: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
3944: lv_regime_code,
3945: pr_trig_row.organization_id,
3946: v_set_of_books_id,
3947: NULL,
3985: p_reference_25 => lv_reference_25 ,
3986: p_reference_26 => lv_reference_26
3987: );
3988:
3989: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
3990: (JOURNAL_ENTRY_ID,
3991: regime_code,
3992: organization_id,
3993: set_of_books_id,
4011: last_updated_by,
4012: last_update_login
4013: )
4014: VALUES
4015: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4016: lv_regime_code,
4017: pr_trig_row.organization_id,
4018: v_set_of_books_id,
4019: NULL,
4059: p_reference_25 => lv_reference_25 ,
4060: p_reference_26 => lv_reference_26
4061: );
4062:
4063: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
4064: (JOURNAL_ENTRY_ID,
4065: regime_code,
4066: organization_id,
4067: set_of_books_id,
4085: last_updated_by,
4086: last_update_login
4087: )
4088: VALUES
4089: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4090: lv_regime_code,
4091: pr_trig_row.organization_id,
4092: v_set_of_books_id,
4093: NULL,
4133: p_reference_25 => lv_reference_25 ,
4134: p_reference_26 => lv_reference_26
4135: );
4136:
4137: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
4138: (JOURNAL_ENTRY_ID,
4139: regime_code,
4140: organization_id,
4141: set_of_books_id,
4159: last_updated_by,
4160: last_update_login
4161: )
4162: VALUES
4163: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4164: lv_regime_code,
4165: pr_trig_row.organization_id,
4166: v_set_of_books_id,
4167: NULL,
4206: p_reference_25 => lv_reference_25 ,
4207: p_reference_26 => lv_reference_26
4208: );
4209:
4210: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
4211: (JOURNAL_ENTRY_ID,
4212: regime_code,
4213: organization_id,
4214: set_of_books_id,
4232: last_updated_by,
4233: last_update_login
4234: )
4235: VALUES
4236: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4237: lv_regime_code,
4238: pr_trig_row.organization_id,
4239: v_set_of_books_id,
4240: NULL,
4278: p_reference_25 => lv_reference_25 ,
4279: p_reference_26 => lv_reference_26
4280: );
4281:
4282: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
4283: (JOURNAL_ENTRY_ID,
4284: regime_code,
4285: organization_id,
4286: set_of_books_id,
4304: last_updated_by,
4305: last_update_login
4306: )
4307: VALUES
4308: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4309: lv_regime_code,
4310: pr_trig_row.organization_id,
4311: v_set_of_books_id,
4312: NULL,
4350: p_reference_25 => lv_reference_25 ,
4351: p_reference_26 => lv_reference_26
4352: );
4353:
4354: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
4355: (JOURNAL_ENTRY_ID,
4356: regime_code,
4357: organization_id,
4358: set_of_books_id,
4376: last_updated_by,
4377: last_update_login
4378: )
4379: VALUES
4380: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
4381: lv_regime_code,
4382: pr_trig_row.organization_id,
4383: v_set_of_books_id,
4384: NULL,