DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_RGM_INVOICE_GEN_T

Line 4216: REM Populate JAI tables JAI_RGM_INVOICE_GEN_T, JAI_OM_WSH_LINES_ALL,

4212: REM +======================================================================+
4213: REM NAME ARIU_T2
4214: REM
4215: REM DESCRIPTION Called from trigger JAI_OE_OLA_ARIUD_T1
4216: REM Populate JAI tables JAI_RGM_INVOICE_GEN_T, JAI_OM_WSH_LINES_ALL,
4217: REM and JAI_OM_WSH_LINE_TAXES for fulfilled non-shippable items.
4218: REM
4219: REM NOTES
4220: REM

Line 4376: FROM JAI_RGM_INVOICE_GEN_T

4372:
4373: CURSOR cur_chk_vat_proc_entry (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)
4374: IS
4375: SELECT 1
4376: FROM JAI_RGM_INVOICE_GEN_T
4377: WHERE order_line_id = cp_order_line_id;
4378:
4379: -- Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
4380: CURSOR c_chk_vat_reversal (cp_order_line_id JAI_OM_WSH_LINES_ALL.order_line_id%TYPE

Line 4728: INSERT INTO JAI_RGM_INVOICE_GEN_T ( regime_id

4724: INTO ln_regime_id
4725: , lv_regns_num;
4726: CLOSE cur_get_regime_info;
4727:
4728: INSERT INTO JAI_RGM_INVOICE_GEN_T ( regime_id
4729: , delivery_id
4730: , delivery_date
4731: , order_line_id
4732: , order_number