APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_OM_OE_SO_LINES

Line 74: rec_jsl JAI_OM_OE_SO_LINES%ROWTYPE;

70: le_error EXCEPTION;
71: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TAX()';
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:

Line 128: from JAI_OM_OE_SO_LINES joosl

124: from JAI_OM_OE_RMA_LINES joorl
125: where joorl.RMA_HEADER_ID = cp_header_id
126: and oola.LINE_ID = joorl.RMA_LINE_ID)
127: and not exists (select 1
128: from JAI_OM_OE_SO_LINES joosl
129: where joosl.HEADER_ID = cp_header_id
130: and oola.LINE_ID = joosl.LINE_ID);
131:
132: -- cursor to get existing SO Lines

Line 139: from JAI_OM_OE_SO_LINES joosl

135: select *
136: from OE_ORDER_LINES oola
137: where oola.HEADER_ID = cp_header_id
138: and ( exists (select 1
139: from JAI_OM_OE_SO_LINES joosl
140: where joosl.HEADER_ID = cp_header_id
141: and oola.LINE_ID = joosl.LINE_ID)
142: or exists (select 1
143: from JAI_OM_OE_RMA_LINES joorl

Line 147: cursor c_jai_so_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,

143: from JAI_OM_OE_RMA_LINES joorl
144: where joorl.RMA_HEADER_ID = cp_header_id
145: and oola.LINE_ID = joorl.RMA_LINE_ID));
146:
147: cursor c_jai_so_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
148: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
149: is
150: select *
151: from JAI_OM_OE_SO_LINES

Line 148: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)

144: where joorl.RMA_HEADER_ID = cp_header_id
145: and oola.LINE_ID = joorl.RMA_LINE_ID));
146:
147: cursor c_jai_so_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
148: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
149: is
150: select *
151: from JAI_OM_OE_SO_LINES
152: where HEADER_ID = cp_header_id

Line 151: from JAI_OM_OE_SO_LINES

147: cursor c_jai_so_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
148: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
149: is
150: select *
151: from JAI_OM_OE_SO_LINES
152: where HEADER_ID = cp_header_id
153: and LINE_ID = cp_line_id;
154:
155: cursor c_jai_rma_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,

Line 155: cursor c_jai_rma_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,

151: from JAI_OM_OE_SO_LINES
152: where HEADER_ID = cp_header_id
153: and LINE_ID = cp_line_id;
154:
155: cursor c_jai_rma_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
156: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
157: is
158: select *
159: from JAI_OM_OE_RMA_LINES

Line 156: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)

152: where HEADER_ID = cp_header_id
153: and LINE_ID = cp_line_id;
154:
155: cursor c_jai_rma_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
156: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
157: is
158: select *
159: from JAI_OM_OE_RMA_LINES
160: where RMA_HEADER_ID = cp_header_id