APPS.GML_PO_SYNCH dependencies on SY_ORGN_MST

Line 541: v_co_code SY_ORGN_MST.CO_CODE%TYPE;

537:
538: RETURN BOOLEAN
539: IS
540: v_result BOOLEAN := TRUE;
541: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
542: v_line_num NUMBER;
543: v_shipment_num NUMBER;
544:
545: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS

Line 545: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS

541: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
542: v_line_num NUMBER;
543: v_shipment_num NUMBER;
544:
545: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS
546: SELECT co_code
547: FROM sy_orgn_mst
548: WHERE orgn_code = v_orgn_code;
549:

Line 547: FROM sy_orgn_mst

543: v_shipment_num NUMBER;
544:
545: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS
546: SELECT co_code
547: FROM sy_orgn_mst
548: WHERE orgn_code = v_orgn_code;
549:
550: CURSOR line_no_cur IS
551: SELECT line_num

Line 1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;

1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;
1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;

Line 1602: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS

1598: SELECT item_id, nvl(item_desc1,' '), item_um, item_um2, dualum_ind, noninv_ind
1599: FROM ic_item_mst
1600: WHERE item_no = v_item_no;
1601:
1602: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS
1603: SELECT co_code
1604: FROM sy_orgn_mst
1605: WHERE orgn_code = v_orgn_code;
1606:

Line 1604: FROM sy_orgn_mst

1600: WHERE item_no = v_item_no;
1601:
1602: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS
1603: SELECT co_code
1604: FROM sy_orgn_mst
1605: WHERE orgn_code = v_orgn_code;
1606:
1607: CURSOR order_qty_price_cur(v_po_id NUMBER, v_line_id NUMBER) IS
1608: SELECT order_qty1, order_qty2,order_um1,order_um2, extended_price, line_no