[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION Insert_Ic_Item_Mst
(p_ic_item_mst_rec IN ic_item_mst%ROWTYPE)
RETURN BOOLEAN
IS
BEGIN
INSERT INTO ic_item_mst
( item_id
, item_no
, item_desc1
, item_desc2
, alt_itema
, alt_itemb
, item_um
, dualum_ind
, item_um2
, deviation_lo
, deviation_hi
, level_code
, lot_ctl
, lot_indivisible
, sublot_ctl
, loct_ctl
, noninv_ind
, match_type
, inactive_ind
, inv_type
, shelf_life
, retest_interval
, item_abccode
, gl_class
, inv_class
, sales_class
, ship_class
, frt_class
, price_class
, storage_class
, purch_class
, tax_class
, customs_class
, alloc_class
, planning_class
, itemcost_class
, cost_mthd_code
, upc_code
, grade_ctl
, status_ctl
, qc_grade
, lot_status
, bulk_id
, pkg_id
, qcitem_id
, qchold_res_code
, expaction_code
, fill_qty
, fill_um
, expaction_interval
, phantom_type
, whse_item_id
, experimental_ind
, exported_date
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, trans_cnt
, delete_mark
, text_code
, seq_dpnd_class
, commodity_code
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute16
, attribute17
, attribute18
, attribute19
, attribute20
, attribute21
, attribute22
, attribute23
, attribute24
, attribute25
, attribute26
, attribute27
, attribute28
, attribute29
, attribute30
, attribute_category
)
VALUES
( p_ic_item_mst_rec.item_id
, p_ic_item_mst_rec.item_no
, p_ic_item_mst_rec.item_desc1
, p_ic_item_mst_rec.item_desc2
, p_ic_item_mst_rec.alt_itema
, p_ic_item_mst_rec.alt_itemb
, p_ic_item_mst_rec.item_um
, p_ic_item_mst_rec.dualum_ind
, p_ic_item_mst_rec.item_um2
, p_ic_item_mst_rec.deviation_lo
, p_ic_item_mst_rec.deviation_hi
, p_ic_item_mst_rec.level_code
, p_ic_item_mst_rec.lot_ctl
, p_ic_item_mst_rec.lot_indivisible
, p_ic_item_mst_rec.sublot_ctl
, p_ic_item_mst_rec.loct_ctl
, p_ic_item_mst_rec.noninv_ind
, p_ic_item_mst_rec.match_type
, p_ic_item_mst_rec.inactive_ind
, p_ic_item_mst_rec.inv_type
, p_ic_item_mst_rec.shelf_life
, p_ic_item_mst_rec.retest_interval
, p_ic_item_mst_rec.item_abccode
, p_ic_item_mst_rec.gl_class
, p_ic_item_mst_rec.inv_class
, p_ic_item_mst_rec.sales_class
, p_ic_item_mst_rec.ship_class
, p_ic_item_mst_rec.frt_class
, p_ic_item_mst_rec.price_class
, p_ic_item_mst_rec.storage_class
, p_ic_item_mst_rec.purch_class
, p_ic_item_mst_rec.tax_class
, p_ic_item_mst_rec.customs_class
, p_ic_item_mst_rec.alloc_class
, p_ic_item_mst_rec.planning_class
, p_ic_item_mst_rec.itemcost_class
, p_ic_item_mst_rec.cost_mthd_code
, p_ic_item_mst_rec.upc_code
, p_ic_item_mst_rec.grade_ctl
, p_ic_item_mst_rec.status_ctl
, p_ic_item_mst_rec.qc_grade
, p_ic_item_mst_rec.lot_status
, p_ic_item_mst_rec.bulk_id
, p_ic_item_mst_rec.pkg_id
, p_ic_item_mst_rec.qcitem_id
, p_ic_item_mst_rec.qchold_res_code
, p_ic_item_mst_rec.expaction_code
, p_ic_item_mst_rec.fill_qty
, p_ic_item_mst_rec.fill_um
, p_ic_item_mst_rec.expaction_interval
, p_ic_item_mst_rec.phantom_type
, p_ic_item_mst_rec.whse_item_id
, p_ic_item_mst_rec.experimental_ind
, p_ic_item_mst_rec.exported_date
, p_ic_item_mst_rec.created_by
, p_ic_item_mst_rec.creation_date
, p_ic_item_mst_rec.last_updated_by
, p_ic_item_mst_rec.last_update_date
, p_ic_item_mst_rec.last_update_login
, p_ic_item_mst_rec.trans_cnt
, p_ic_item_mst_rec.delete_mark
, p_ic_item_mst_rec.text_code
, p_ic_item_mst_rec.seq_dpnd_class
, p_ic_item_mst_rec.commodity_code
, p_ic_item_mst_rec.attribute1
, p_ic_item_mst_rec.attribute2
, p_ic_item_mst_rec.attribute3
, p_ic_item_mst_rec.attribute4
, p_ic_item_mst_rec.attribute5
, p_ic_item_mst_rec.attribute6
, p_ic_item_mst_rec.attribute7
, p_ic_item_mst_rec.attribute8
, p_ic_item_mst_rec.attribute9
, p_ic_item_mst_rec.attribute10
, p_ic_item_mst_rec.attribute11
, p_ic_item_mst_rec.attribute12
, p_ic_item_mst_rec.attribute13
, p_ic_item_mst_rec.attribute14
, p_ic_item_mst_rec.attribute15
, p_ic_item_mst_rec.attribute16
, p_ic_item_mst_rec.attribute17
, p_ic_item_mst_rec.attribute18
, p_ic_item_mst_rec.attribute19
, p_ic_item_mst_rec.attribute20
, p_ic_item_mst_rec.attribute21
, p_ic_item_mst_rec.attribute22
, p_ic_item_mst_rec.attribute23
, p_ic_item_mst_rec.attribute24
, p_ic_item_mst_rec.attribute25
, p_ic_item_mst_rec.attribute26
, p_ic_item_mst_rec.attribute27
, p_ic_item_mst_rec.attribute28
, p_ic_item_mst_rec.attribute29
, p_ic_item_mst_rec.attribute30
, p_ic_item_mst_rec.attribute_category
);
, 'insert_ic_item_mst'
);
END Insert_Ic_Item_Mst;
FUNCTION Insert_Ic_Item_Cpg
(p_ic_item_cpg_rec IN ic_item_cpg%ROWTYPE)
RETURN BOOLEAN
IS
BEGIN
INSERT INTO ic_item_cpg
( item_id
, ic_matr_days
, ic_hold_days
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
)
VALUES
( p_ic_item_cpg_rec.item_id
, p_ic_item_cpg_rec.ic_matr_days
, p_ic_item_cpg_rec.ic_hold_days
, p_ic_item_cpg_rec.created_by
, p_ic_item_cpg_rec.creation_date
, p_ic_item_cpg_rec.last_updated_by
, p_ic_item_cpg_rec.last_update_date
, p_ic_item_cpg_rec.last_update_login
);
, 'insert_ic_item_cpg'
);
END Insert_Ic_Item_Cpg;