APPS.GMI_LOTS_PVT dependencies on IC_LOTS_MST

Line 20: --| Insert_Ic_Lots_Mst |

16: --| This package contains all utility functions that insert/update Lot |
17: --| related tables |
18: --| |
19: --| CONTENTS |
20: --| Insert_Ic_Lots_Mst |
21: --| Insert_Ic_Lots_Cpg |
22: --| |
23: --| HISTORY |
24: --| |

Line 33: --| Insert_Ic_Lots_Mst |

29: IC$DEFAULT_LOT VARCHAR2(255);
30: -- Func start of comments
31: --+==========================================================================+
32: --| FUNCTION NAME |
33: --| Insert_Ic_Lots_Mst |
34: --| |
35: --| USAGE |
36: --| Insert a row into ic_lots_mst |
37: --| |

Line 36: --| Insert a row into ic_lots_mst |

32: --| FUNCTION NAME |
33: --| Insert_Ic_Lots_Mst |
34: --| |
35: --| USAGE |
36: --| Insert a row into ic_lots_mst |
37: --| |
38: --| DESCRIPTION |
39: --| This procedure inserts a row into ic_lots_mst |
40: --| |

Line 39: --| This procedure inserts a row into ic_lots_mst |

35: --| USAGE |
36: --| Insert a row into ic_lots_mst |
37: --| |
38: --| DESCRIPTION |
39: --| This procedure inserts a row into ic_lots_mst |
40: --| |
41: --| PARAMETERS |
42: --| p_ic_lots_mst_rec IN RECORD - Lots Master Details |
43: --| |

Line 42: --| p_ic_lots_mst_rec IN RECORD - Lots Master Details |

38: --| DESCRIPTION |
39: --| This procedure inserts a row into ic_lots_mst |
40: --| |
41: --| PARAMETERS |
42: --| p_ic_lots_mst_rec IN RECORD - Lots Master Details |
43: --| |
44: --| RETURNS |
45: --| TRUE - If insert successful |
46: --| FALSE - If insert fails |

Line 54: FUNCTION Insert_Ic_Lots_Mst

50: --| 20-OCT-1999 H.Verdding Added Atribute Fields To Insert |
51: --| B1042722 |
52: --+==========================================================================+
53: -- Func end of comments
54: FUNCTION Insert_Ic_Lots_Mst
55: (p_ic_lots_mst_rec IN ic_lots_mst%ROWTYPE)
56: RETURN BOOLEAN
57: IS
58:

Line 55: (p_ic_lots_mst_rec IN ic_lots_mst%ROWTYPE)

51: --| B1042722 |
52: --+==========================================================================+
53: -- Func end of comments
54: FUNCTION Insert_Ic_Lots_Mst
55: (p_ic_lots_mst_rec IN ic_lots_mst%ROWTYPE)
56: RETURN BOOLEAN
57: IS
58:
59: BEGIN

Line 61: INSERT INTO ic_lots_mst

57: IS
58:
59: BEGIN
60:
61: INSERT INTO ic_lots_mst
62: ( item_id
63: , lot_no
64: , sublot_no
65: , lot_id

Line 118: ( p_ic_lots_mst_rec.item_id

114: , attribute30
115: , attribute_category
116: )
117: VALUES
118: ( p_ic_lots_mst_rec.item_id
119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc

Line 119: , p_ic_lots_mst_rec.lot_no

115: , attribute_category
116: )
117: VALUES
118: ( p_ic_lots_mst_rec.item_id
119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade

Line 120: , p_ic_lots_mst_rec.sublot_no

116: )
117: VALUES
118: ( p_ic_lots_mst_rec.item_id
119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code

Line 121: , p_ic_lots_mst_rec.lot_id

117: VALUES
118: ( p_ic_lots_mst_rec.item_id
119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date

Line 122: , p_ic_lots_mst_rec.lot_desc

118: ( p_ic_lots_mst_rec.item_id
119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created

Line 123: , p_ic_lots_mst_rec.qc_grade

119: , p_ic_lots_mst_rec.lot_no
120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date

Line 124: , p_ic_lots_mst_rec.expaction_code

120: , p_ic_lots_mst_rec.sublot_no
121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date

Line 125: , p_ic_lots_mst_rec.expaction_date

121: , p_ic_lots_mst_rec.lot_id
122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength

Line 126: , p_ic_lots_mst_rec.lot_created

122: , p_ic_lots_mst_rec.lot_desc
123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind

Line 127: , p_ic_lots_mst_rec.expire_date

123: , p_ic_lots_mst_rec.qc_grade
124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type

Line 128: , p_ic_lots_mst_rec.retest_date

124: , p_ic_lots_mst_rec.expaction_code
125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id

Line 129: , p_ic_lots_mst_rec.strength

125: , p_ic_lots_mst_rec.expaction_date
126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no

Line 130: , p_ic_lots_mst_rec.inactive_ind

126: , p_ic_lots_mst_rec.lot_created
127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date

Line 131: , p_ic_lots_mst_rec.origination_type

127: , p_ic_lots_mst_rec.expire_date
128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date

Line 132: , p_ic_lots_mst_rec.shipvend_id

128: , p_ic_lots_mst_rec.retest_date
129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by

Line 133: , p_ic_lots_mst_rec.vendor_lot_no

129: , p_ic_lots_mst_rec.strength
130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by

Line 134: , p_ic_lots_mst_rec.creation_date

130: , p_ic_lots_mst_rec.inactive_ind
131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt

Line 135: , p_ic_lots_mst_rec.last_update_date

131: , p_ic_lots_mst_rec.origination_type
132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark

Line 136: , p_ic_lots_mst_rec.created_by

132: , p_ic_lots_mst_rec.shipvend_id
133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code

Line 137: , p_ic_lots_mst_rec.last_updated_by

133: , p_ic_lots_mst_rec.vendor_lot_no
134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1

Line 138: , p_ic_lots_mst_rec.trans_cnt

134: , p_ic_lots_mst_rec.creation_date
135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2

Line 139: , p_ic_lots_mst_rec.delete_mark

135: , p_ic_lots_mst_rec.last_update_date
136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3

Line 140: , p_ic_lots_mst_rec.text_code

136: , p_ic_lots_mst_rec.created_by
137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4

Line 141: , p_ic_lots_mst_rec.attribute1

137: , p_ic_lots_mst_rec.last_updated_by
138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5

Line 142: , p_ic_lots_mst_rec.attribute2

138: , p_ic_lots_mst_rec.trans_cnt
139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6

Line 143: , p_ic_lots_mst_rec.attribute3

139: , p_ic_lots_mst_rec.delete_mark
140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7

Line 144: , p_ic_lots_mst_rec.attribute4

140: , p_ic_lots_mst_rec.text_code
141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8

Line 145: , p_ic_lots_mst_rec.attribute5

141: , p_ic_lots_mst_rec.attribute1
142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9

Line 146: , p_ic_lots_mst_rec.attribute6

142: , p_ic_lots_mst_rec.attribute2
143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10

Line 147: , p_ic_lots_mst_rec.attribute7

143: , p_ic_lots_mst_rec.attribute3
144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11

Line 148: , p_ic_lots_mst_rec.attribute8

144: , p_ic_lots_mst_rec.attribute4
145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12

Line 149: , p_ic_lots_mst_rec.attribute9

145: , p_ic_lots_mst_rec.attribute5
146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13

Line 150: , p_ic_lots_mst_rec.attribute10

146: , p_ic_lots_mst_rec.attribute6
147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14

Line 151: , p_ic_lots_mst_rec.attribute11

147: , p_ic_lots_mst_rec.attribute7
148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15

Line 152: , p_ic_lots_mst_rec.attribute12

148: , p_ic_lots_mst_rec.attribute8
149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16

Line 153: , p_ic_lots_mst_rec.attribute13

149: , p_ic_lots_mst_rec.attribute9
150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17

Line 154: , p_ic_lots_mst_rec.attribute14

150: , p_ic_lots_mst_rec.attribute10
151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18

Line 155: , p_ic_lots_mst_rec.attribute15

151: , p_ic_lots_mst_rec.attribute11
152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19

Line 156: , p_ic_lots_mst_rec.attribute16

152: , p_ic_lots_mst_rec.attribute12
153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20

Line 157: , p_ic_lots_mst_rec.attribute17

153: , p_ic_lots_mst_rec.attribute13
154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21

Line 158: , p_ic_lots_mst_rec.attribute18

154: , p_ic_lots_mst_rec.attribute14
155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22

Line 159: , p_ic_lots_mst_rec.attribute19

155: , p_ic_lots_mst_rec.attribute15
156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23

Line 160: , p_ic_lots_mst_rec.attribute20

156: , p_ic_lots_mst_rec.attribute16
157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24

Line 161: , p_ic_lots_mst_rec.attribute21

157: , p_ic_lots_mst_rec.attribute17
158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25

Line 162: , p_ic_lots_mst_rec.attribute22

158: , p_ic_lots_mst_rec.attribute18
159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26

Line 163: , p_ic_lots_mst_rec.attribute23

159: , p_ic_lots_mst_rec.attribute19
160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27

Line 164: , p_ic_lots_mst_rec.attribute24

160: , p_ic_lots_mst_rec.attribute20
161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28

Line 165: , p_ic_lots_mst_rec.attribute25

161: , p_ic_lots_mst_rec.attribute21
162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29

Line 166: , p_ic_lots_mst_rec.attribute26

162: , p_ic_lots_mst_rec.attribute22
163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30

Line 167: , p_ic_lots_mst_rec.attribute27

163: , p_ic_lots_mst_rec.attribute23
164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30
171: , p_ic_lots_mst_rec.attribute_category

Line 168: , p_ic_lots_mst_rec.attribute28

164: , p_ic_lots_mst_rec.attribute24
165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30
171: , p_ic_lots_mst_rec.attribute_category
172: );

Line 169: , p_ic_lots_mst_rec.attribute29

165: , p_ic_lots_mst_rec.attribute25
166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30
171: , p_ic_lots_mst_rec.attribute_category
172: );
173:

Line 170: , p_ic_lots_mst_rec.attribute30

166: , p_ic_lots_mst_rec.attribute26
167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30
171: , p_ic_lots_mst_rec.attribute_category
172: );
173:
174: RETURN TRUE;

Line 171: , p_ic_lots_mst_rec.attribute_category

167: , p_ic_lots_mst_rec.attribute27
168: , p_ic_lots_mst_rec.attribute28
169: , p_ic_lots_mst_rec.attribute29
170: , p_ic_lots_mst_rec.attribute30
171: , p_ic_lots_mst_rec.attribute_category
172: );
173:
174: RETURN TRUE;
175:

Line 183: , 'insert_ic_lots_mst'

179: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: -- THEN
181:
182: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
183: , 'insert_ic_lots_mst'
184: );
185: -- END IF;
186: RETURN FALSE;
187:

Line 188: END Insert_Ic_Lots_Mst;

184: );
185: -- END IF;
186: RETURN FALSE;
187:
188: END Insert_Ic_Lots_Mst;
189:
190: -- Func start of comments
191: --+==========================================================================+
192: --| FUNCTION NAME |