DBA Data[Home] [Help]

APPS.GMI_ITEM_LOT_CONV_PVT dependencies on IC_ITEM_CNV

Line 20: --| Insert_Ic_Item_Cnv |

16: --| This package conatains all Utility functions pertaining to Item/Lot |
17: --| Conversion |
18: --| |
19: --| CONTENTS |
20: --| Insert_Ic_Item_Cnv |
21: --| |
22: --| HISTORY |
23: --| 25-FEB-1999 M.P.Godfrey Upgrade to R11 |
24: --| |

Line 35: --| Insert a row into IC_ITEM_CNV |

31: --| FUNCTION NAME |
32: --| Create_Item |
33: --| |
34: --| USAGE |
35: --| Insert a row into IC_ITEM_CNV |
36: --| |
37: --| DESCRIPTION |
38: --| This procedure creates a new row into IC_ITEM_CNV |
39: --| |

Line 38: --| This procedure creates a new row into IC_ITEM_CNV |

34: --| USAGE |
35: --| Insert a row into IC_ITEM_CNV |
36: --| |
37: --| DESCRIPTION |
38: --| This procedure creates a new row into IC_ITEM_CNV |
39: --| |
40: --| PARAMETERS |
41: --| p_ic_item_cnv_rec IN RECORD - Item Conversion Details |
42: --| |

Line 41: --| p_ic_item_cnv_rec IN RECORD - Item Conversion Details |

37: --| DESCRIPTION |
38: --| This procedure creates a new row into IC_ITEM_CNV |
39: --| |
40: --| PARAMETERS |
41: --| p_ic_item_cnv_rec IN RECORD - Item Conversion Details |
42: --| |
43: --| RETURNS |
44: --| TRUE - If Insert successful |
45: --| FALSE - If Insert Fails |

Line 51: FUNCTION Insert_Ic_Item_Cnv

47: --| HISTORY |
48: --| |
49: --+==========================================================================+
50: -- Func end of comments
51: FUNCTION Insert_Ic_Item_Cnv
52: ( p_ic_item_cnv_rec IN ic_item_cnv%ROWTYPE)
53: RETURN BOOLEAN
54: IS
55:

Line 52: ( p_ic_item_cnv_rec IN ic_item_cnv%ROWTYPE)

48: --| |
49: --+==========================================================================+
50: -- Func end of comments
51: FUNCTION Insert_Ic_Item_Cnv
52: ( p_ic_item_cnv_rec IN ic_item_cnv%ROWTYPE)
53: RETURN BOOLEAN
54: IS
55:
56: BEGIN

Line 58: INSERT INTO ic_item_cnv

54: IS
55:
56: BEGIN
57:
58: INSERT INTO ic_item_cnv
59: ( item_id
60: , lot_id
61: , um_type
62: , type_factor

Line 74: ( p_ic_item_cnv_rec.item_id

70: , type_factorrev
71: , last_update_login
72: )
73: VALUES
74: ( p_ic_item_cnv_rec.item_id
75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date

Line 75: , p_ic_item_cnv_rec.lot_id

71: , last_update_login
72: )
73: VALUES
74: ( p_ic_item_cnv_rec.item_id
75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date

Line 76: , p_ic_item_cnv_rec.um_type

72: )
73: VALUES
74: ( p_ic_item_cnv_rec.item_id
75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by

Line 77: , p_ic_item_cnv_rec.type_factor

73: VALUES
74: ( p_ic_item_cnv_rec.item_id
75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by

Line 78: , p_ic_item_cnv_rec.creation_date

74: ( p_ic_item_cnv_rec.item_id
75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt

Line 79: , p_ic_item_cnv_rec.last_update_date

75: , p_ic_item_cnv_rec.lot_id
76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark

Line 80: , p_ic_item_cnv_rec.created_by

76: , p_ic_item_cnv_rec.um_type
77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code

Line 81: , p_ic_item_cnv_rec.last_updated_by

77: , p_ic_item_cnv_rec.type_factor
78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev

Line 82: , p_ic_item_cnv_rec.trans_cnt

78: , p_ic_item_cnv_rec.creation_date
79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev
86: , p_ic_item_cnv_rec.last_update_login

Line 83: , p_ic_item_cnv_rec.delete_mark

79: , p_ic_item_cnv_rec.last_update_date
80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev
86: , p_ic_item_cnv_rec.last_update_login
87: );

Line 84: , p_ic_item_cnv_rec.text_code

80: , p_ic_item_cnv_rec.created_by
81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev
86: , p_ic_item_cnv_rec.last_update_login
87: );
88:

Line 85: , p_ic_item_cnv_rec.type_factorrev

81: , p_ic_item_cnv_rec.last_updated_by
82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev
86: , p_ic_item_cnv_rec.last_update_login
87: );
88:
89: RETURN TRUE;

Line 86: , p_ic_item_cnv_rec.last_update_login

82: , p_ic_item_cnv_rec.trans_cnt
83: , p_ic_item_cnv_rec.delete_mark
84: , p_ic_item_cnv_rec.text_code
85: , p_ic_item_cnv_rec.type_factorrev
86: , p_ic_item_cnv_rec.last_update_login
87: );
88:
89: RETURN TRUE;
90:

Line 98: , 'Insert_Ic_Item_Cnv'

94: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
95: -- THEN
96:
97: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
98: , 'Insert_Ic_Item_Cnv'
99: );
100: -- END IF;
101: RETURN FALSE;
102:

Line 103: END Insert_Ic_Item_Cnv;

99: );
100: -- END IF;
101: RETURN FALSE;
102:
103: END Insert_Ic_Item_Cnv;
104:
105: END GMI_ITEM_LOT_CONV_PVT;