DBA Data[Home] [Help]

APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on OE_ORDER_LINES_ALL

Line 219: oe_order_lines_all oel

215: SELECT
216: oel.ato_line_id
217: FROM
218: oe_order_headers_all oeh,
219: oe_order_lines_all oel
220: WHERE
221: oeh.header_id = p_rec_new.header_id
222: AND oeh.header_id = oel.header_id
223: AND item_type_code = 'CONFIG' ;

Line 225: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS

221: oeh.header_id = p_rec_new.header_id
222: AND oeh.header_id = oel.header_id
223: AND item_type_code = 'CONFIG' ;
224:
225: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS
226: SELECT
227: oel.inventory_item_id
228: FROM
229: oe_order_lines_all oel

Line 229: oe_order_lines_all oel

225: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS
226: SELECT
227: oel.inventory_item_id
228: FROM
229: oe_order_lines_all oel
230: WHERE
231: oel.line_id = cp_ato_line_id
232: AND item_type_code = 'MODEL' ;
233:

Line 822: CURSOR cur_source_line_id_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,

818: FROM JAI_OM_OE_RMA_LINES
819: WHERE rma_header_id = p_header_id
820: AND rma_line_id = p_Line_Id;
821:
822: CURSOR cur_source_line_id_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
823: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
824: SELECT 'X'
825: FROM JAI_OM_OE_SO_LINES
826: WHERE line_id = p_line_id

Line 823: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS

819: WHERE rma_header_id = p_header_id
820: AND rma_line_id = p_Line_Id;
821:
822: CURSOR cur_source_line_id_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
823: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
824: SELECT 'X'
825: FROM JAI_OM_OE_SO_LINES
826: WHERE line_id = p_line_id
827: AND header_id = p_header_id;

Line 832: CURSOR cur_get_JAI_OM_OE_RMA_TAXES(p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS

828:
829: /*
830: Get the rma trax lines detail from the table JAI_OM_OE_RMA_TAXES
831: */
832: CURSOR cur_get_JAI_OM_OE_RMA_TAXES(p_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
833: SELECT tax_line_no,
834: tax_id,
835: tax_rate,
836: qty_rate,

Line 857: CURSOR cur_chk_tax_lines_exists(p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE,

853:
854: /*
855: code to check whether a record exists in the table JAI_OM_OE_SO_TAXES for a given line_id and tax_id.
856: */
857: CURSOR cur_chk_tax_lines_exists(p_line_id1 OE_ORDER_LINES_ALL.LINE_ID%TYPE,
858: p_tax_id JAI_OM_OE_SO_TAXES.TAX_ID%TYPE) IS
859: SELECT 'X'
860: FROM JAI_OM_OE_SO_TAXES
861: WHERE line_id = p_line_id1

Line 1103: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,

1099: px_return_code out nocopy varchar2,
1100: px_return_message out nocopy varchar2) IS
1101:
1102: -- get the details from JAI_OM_WSH_LINES_ALL table
1103: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1104: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1105: SELECT pl.inventory_item_id inventory_item_id,
1106: pl.unit_code unit_code,
1107: sum(pl.quantity) quantity,

Line 1104: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS

1100: px_return_message out nocopy varchar2) IS
1101:
1102: -- get the details from JAI_OM_WSH_LINES_ALL table
1103: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1104: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1105: SELECT pl.inventory_item_id inventory_item_id,
1106: pl.unit_code unit_code,
1107: sum(pl.quantity) quantity,
1108: pl.tax_category_id tax_category_id,

Line 1125: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,

1121: select quantity, service_type_code
1122: from JAI_OM_OE_SO_LINES
1123: where line_id = pr_order_line.reference_line_id;
1124:
1125: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
1126: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
1127: SELECT 'X'
1128: FROM JAI_OM_OE_RMA_LINES
1129: WHERE rma_line_id = p_line_id

Line 1126: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS

1122: from JAI_OM_OE_SO_LINES
1123: where line_id = pr_order_line.reference_line_id;
1124:
1125: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
1126: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
1127: SELECT 'X'
1128: FROM JAI_OM_OE_RMA_LINES
1129: WHERE rma_line_id = p_line_id
1130: AND rma_header_id = p_header_id;

Line 1210: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,

1206: FROM jai_regime_tax_types_v
1207: WHERE regime_code = jai_constants.vat_regime
1208: AND tax_type = cp_tax_type;
1209:
1210: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1211: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1212: select delivery_detail_id
1213: from JAI_OM_OE_RMA_LINES
1214: where rma_header_id = p_source_document_id

Line 1211: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is

1207: WHERE regime_code = jai_constants.vat_regime
1208: AND tax_type = cp_tax_type;
1209:
1210: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1211: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1212: select delivery_detail_id
1213: from JAI_OM_OE_RMA_LINES
1214: where rma_header_id = p_source_document_id
1215: AND rma_line_id = p_source_document_line_id;

Line 1852: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,

1848: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1850:
1851: -- get the details from JAI_OM_WSH_LINES_ALL table
1852: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1853: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1854: SELECT pl.inventory_item_id inventory_item_id,
1855: pl.unit_code unit_code,
1856: sum(pl.quantity) quantity,

Line 1853: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS

1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1850:
1851: -- get the details from JAI_OM_WSH_LINES_ALL table
1852: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1853: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS
1854: SELECT pl.inventory_item_id inventory_item_id,
1855: pl.unit_code unit_code,
1856: sum(pl.quantity) quantity,
1857: pl.tax_category_id tax_category_id,

Line 1874: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,

1870: select quantity, service_type_code
1871: from JAI_OM_OE_SO_LINES
1872: where line_id = pr_order_line.reference_line_id;
1873:
1874: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
1875: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
1876: SELECT 'X'
1877: FROM JAI_OM_OE_RMA_LINES
1878: WHERE rma_line_id = p_line_id

Line 1875: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS

1871: from JAI_OM_OE_SO_LINES
1872: where line_id = pr_order_line.reference_line_id;
1873:
1874: CURSOR cur_rma_entry_line_exists(p_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE,
1875: p_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE) IS
1876: SELECT 'X'
1877: FROM JAI_OM_OE_RMA_LINES
1878: WHERE rma_line_id = p_line_id
1879: AND rma_header_id = p_header_id;

Line 1966: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,

1962: FROM jai_regime_tax_types_v
1963: WHERE regime_code = jai_constants.vat_regime
1964: AND tax_type = cp_tax_type;
1965:
1966: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1967: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1968: select delivery_detail_id
1969: from JAI_OM_OE_RMA_LINES
1970: where rma_header_id = p_source_document_id

Line 1967: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is

1963: WHERE regime_code = jai_constants.vat_regime
1964: AND tax_type = cp_tax_type;
1965:
1966: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1967: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1968: select delivery_detail_id
1969: from JAI_OM_OE_RMA_LINES
1970: where rma_header_id = p_source_document_id
1971: AND rma_line_id = p_source_document_line_id;

Line 3739: FROM OE_ORDER_LINES_ALL

3735: xn_inventory_item_id OUT NOCOPY NUMBER) IS
3736:
3737: CURSOR Get_model_line_dtls_cur IS
3738: SELECT ship_from_org_id, inventory_item_id
3739: FROM OE_ORDER_LINES_ALL
3740: WHERE header_id = pn_header_id
3741: AND line_id = pn_line_id;
3742: BEGIN
3743: OPEN Get_model_line_dtls_cur;

Line 4139: FROM oe_order_lines_all

4135: PRAGMA AUTONOMOUS_TRANSACTION; --added for bug#16341712
4136:
4137: CURSOR cur_get_line_id IS
4138: SELECT line_id, inventory_item_id
4139: FROM oe_order_lines_all
4140: WHERE header_id = pr_new.Header_id
4141: and top_model_line_id = pr_new.top_model_line_id
4142: and item_type_code = 'CONFIG';
4143:

Line 4587: * The firing table is on OE_ORDER_LINES_ALL. The firing table accessing in the

4583: CLOSE cur_chk_item_dtls;
4584:
4585: IF nvl(ln_item_exists, 0) <> 1 THEN
4586: /*
4587: * The firing table is on OE_ORDER_LINES_ALL. The firing table accessing in the
4588: * trigger in the enven of UPDATING will cause table mutating error. So use an
4589: * AUTONOMOUS transaction to resolve the issue.
4590: */
4591:

Line 4617: Before inserting a record in the oe_order_lines_all table for a return order, check if the delivery detail_id i.e pr_new.attribute2 is null.

4613: RETURN;
4614: END IF;
4615:
4616: /*
4617: Before inserting a record in the oe_order_lines_all table for a return order, check if the delivery detail_id i.e pr_new.attribute2 is null.
4618: IF yes then
4619: 1. pick up the delivery_detail_id from the wsh_delivery_details table for records corresponding to the reference_header_id and
4620: reference_line_id in this table and populate the pr_new.attibute2 dff field
4621: 2.Set the pr_new.attribute3 = 'Y' and pr_new.attribute4 = 'Y'