[Home] [Help]
1997: REM
1998: REM DESCRIPTION Called from BE_INTERFACED
1999: REM
2000: REM NOTES Come from JAI_OM_WDD_TRIGGER_PKG.RG23D_REV_ACCOUNTING
2001: REM Passing the accounting entries in the sub-ledger table jai_cmn_journal_entries.
2002: REM +========================================================================================+
2003: */
2004: PROCEDURE RG23D_REV_ACCOUNTING(pr_trig_row IN wsh_delivery_details%ROWTYPE,
2005: pv_return_code out nocopy VARCHAR2,
2206: p_reference_24 => lv_reference_24,
2207: p_reference_25 => lv_reference_25,
2208: p_reference_26 => lv_reference_26);
2209:
2210: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2211: (JOURNAL_ENTRY_ID,
2212: regime_code,
2213: organization_id,
2214: set_of_books_id,
2231: last_update_date,
2232: last_updated_by,
2233: last_update_login)
2234: VALUES
2235: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2236: lv_regime_code,
2237: pr_trig_row.organization_id,
2238: v_set_of_books_id,
2239: NULL,
2274: p_reference_24 => lv_reference_24,
2275: p_reference_25 => lv_reference_25,
2276: p_reference_26 => lv_reference_26);
2277:
2278: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2279: (JOURNAL_ENTRY_ID,
2280: regime_code,
2281: organization_id,
2282: set_of_books_id,
2299: last_update_date,
2300: last_updated_by,
2301: last_update_login)
2302: VALUES
2303: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2304: lv_regime_code,
2305: pr_trig_row.organization_id,
2306: v_set_of_books_id,
2307: NULL,
2343: p_reference_24 => lv_reference_24,
2344: p_reference_25 => lv_reference_25,
2345: p_reference_26 => lv_reference_26);
2346:
2347: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2348: (JOURNAL_ENTRY_ID,
2349: regime_code,
2350: organization_id,
2351: set_of_books_id,
2368: last_update_date,
2369: last_updated_by,
2370: last_update_login)
2371: VALUES
2372: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2373: lv_regime_code,
2374: pr_trig_row.organization_id,
2375: v_set_of_books_id,
2376: NULL,
2411: p_reference_24 => lv_reference_24,
2412: p_reference_25 => lv_reference_25,
2413: p_reference_26 => lv_reference_26);
2414:
2415: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2416: (JOURNAL_ENTRY_ID,
2417: regime_code,
2418: organization_id,
2419: set_of_books_id,
2436: last_update_date,
2437: last_updated_by,
2438: last_update_login)
2439: VALUES
2440: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2441: lv_regime_code,
2442: pr_trig_row.organization_id,
2443: v_set_of_books_id,
2444: NULL,
2479: p_reference_24 => lv_reference_24,
2480: p_reference_25 => lv_reference_25,
2481: p_reference_26 => lv_reference_26);
2482:
2483: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2484: (JOURNAL_ENTRY_ID,
2485: regime_code,
2486: organization_id,
2487: set_of_books_id,
2504: last_update_date,
2505: last_updated_by,
2506: last_update_login)
2507: VALUES
2508: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2509: lv_regime_code,
2510: pr_trig_row.organization_id,
2511: v_set_of_books_id,
2512: NULL,
2547: p_reference_24 => lv_reference_24,
2548: p_reference_25 => lv_reference_25,
2549: p_reference_26 => lv_reference_26);
2550:
2551: INSERT INTO JAI_CMN_JOURNAL_ENTRIES
2552: (JOURNAL_ENTRY_ID,
2553: regime_code,
2554: organization_id,
2555: set_of_books_id,
2572: last_update_date,
2573: last_updated_by,
2574: last_update_login)
2575: VALUES
2576: (JAI_CMN_JOURNAL_ENTRIES_S.nextval,
2577: lv_regime_code,
2578: pr_trig_row.organization_id,
2579: v_set_of_books_id,
2580: NULL,