APPS.GMI_LOTS_PUB dependencies on IC_LOTS_MST

Line 37: , lot_no ic_lots_mst.lot_no%TYPE

33: --
34: -- API specific parameters to be presented in SQL RECORD format
35: TYPE lot_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , lot_no ic_lots_mst.lot_no%TYPE
38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL

Line 38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL

34: -- API specific parameters to be presented in SQL RECORD format
35: TYPE lot_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , lot_no ic_lots_mst.lot_no%TYPE
38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL

Line 39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL

35: TYPE lot_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , lot_no ic_lots_mst.lot_no%TYPE
38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE

Line 40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL

36: ( item_no ic_item_mst.item_no%TYPE
37: , lot_no ic_lots_mst.lot_no%TYPE
38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL

Line 41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL

37: , lot_no ic_lots_mst.lot_no%TYPE
38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL

Line 42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL

38: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100

Line 43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE

39: , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0

Line 44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL

40: , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0

Line 45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL

41: , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL

Line 46: , strength ic_lots_mst.strength%TYPE DEFAULT 100

42: , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL

Line 47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0

43: , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL

Line 48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0

44: , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45: , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL

Line 50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL

46: , strength ic_lots_mst.strength%TYPE DEFAULT 100
47: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL

Line 53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL

49: , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL

Line 54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL

50: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL

Line 55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL

51: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL

Line 56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL

52: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL

Line 57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL

53: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL

Line 58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL

54: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL

Line 59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL

55: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL

Line 60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL

56: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL

Line 61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL

57: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL

Line 62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL

58: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL

Line 63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL

59: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL

Line 64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL

60: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL

Line 65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL

61: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL

Line 66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL

62: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL

Line 67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL

63: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL

Line 68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL

64: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL

Line 69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL

65: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL

Line 70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL

66: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL

Line 71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL

67: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL

Line 72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL

68: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL

Line 73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL

69: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL

Line 74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL

70: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL

Line 75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL

71: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL

Line 76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL

72: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL

Line 77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL

73: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL

Line 78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL

74: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL

Line 79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL

75: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL

Line 80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL

76: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
84: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

Line 81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL

77: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
84: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
85: );

Line 82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL

78: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
84: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
85: );
86: --

Line 83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL

79: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
84: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
85: );
86: --
87: PROCEDURE Create_Lot