DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on OE_ORDER_LINES_ALL

Line 76: rec_old_ool OE_ORDER_LINES_ALL%ROWTYPE;

72:
73: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 begin.
74: rec_jsl JAI_OM_OE_SO_LINES%ROWTYPE;
75: rec_jrl JAI_OM_OE_RMA_LINES%ROWTYPE;
76: rec_old_ool OE_ORDER_LINES_ALL%ROWTYPE;
77: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 end.
78:
79:
80: --get distribution lines in one invoice

Line 118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)

114: --Added by Cholei for bug#14189751 end
115:
116: --Added by Zhiwei.xin for ZX integration of OM part begin
117: -- cursor to get newly created SO
118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)
119: is
120: select *
121: from OE_ORDER_LINES_ALL oola
122: where oola.HEADER_ID = cp_header_id

Line 121: from OE_ORDER_LINES_ALL oola

117: -- cursor to get newly created SO
118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)
119: is
120: select *
121: from OE_ORDER_LINES_ALL oola
122: where oola.HEADER_ID = cp_header_id
123: and not exists (select 1
124: from JAI_OM_OE_RMA_LINES joorl
125: where joorl.RMA_HEADER_ID = cp_header_id