[Home] [Help]
17: # 08-OCT-97 Ravi Dasani , Rajeshwari Chellam Created.
18: # 11-MAY-98 Tony Ricci changes for GEMMS 5.0 database changes
19: # 07-JUL-98 Tony Ricci changes for GEMMS 5.0 nullable columns
20: # 11/10/98 T.Ricci added shipper_code_cur to retreive correct
21: # shipper_code 4 char value from op_ship_mst
22: # 11/11/98 T.Ricci added fob_code_cur to retreive correct
23: # fob_code 4 char value from op_fobc_mst
24: # 12/24/98 added defaults for who columns in cpg_oragems_mapping
25: # 05/13/99 T.Ricci removed checking of inventory_item_flag and
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:
83: v_shipper_code OP_SHIP_MST.SHIPPER_CODE%TYPE;
84: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
85: /** MC BUG# 1554088 **/
86: /** new variable to hold order um1. **/
87: v_order_um1 SY_UOMS_MST.UM_CODE%TYPE;
257: FROM ap_terms
258: WHERE term_id = v_terms_id;
259:
260: /* T.Ricci 11/10/98 added shipper_code_cur to retreive correct shipper_code
261: 4 char value from op_ship_mst*/
262: CURSOR shipper_code_cur
263: IS
264: SELECT shipper_code
265: FROM op_ship_mst
261: 4 char value from op_ship_mst*/
262: CURSOR shipper_code_cur
263: IS
264: SELECT shipper_code
265: FROM op_ship_mst
266: WHERE of_shipper_code = v_ship_via_lookup_code;
267:
268: /* T.Ricci 11/11/98 added fob_code_cur to retreive correct fob_code
269: 4 char value from op_fobc_mst*/
380: INTO v_terms_name;
381: CLOSE terms_name_cur;
382:
383: /* T.Ricci 11/10/98 added shipper_code_cur to retreive correct shipper_code
384: 4 char value from op_ship_mst*/
385: OPEN shipper_code_cur;
386: FETCH shipper_code_cur
387: INTO v_shipper_code;
388: CLOSE shipper_code_cur;