APPS.GMD_LM_MIGRATION dependencies on LM_SPRD_DTL

Line 88: * PROCEDURE populate_lm_sprd_dtl_sec_qty

84:
85: END generate_tech_parm_id;
86:
87: /* ***************************************************************
88: * PROCEDURE populate_lm_sprd_dtl_sec_qty
89: *
90: * Synopsis : populate_lm_sprd_dtl_sec_qty
91: *
92: * Description : Get all items from lm_sprd_dtl that has dual uom

Line 90: * Synopsis : populate_lm_sprd_dtl_sec_qty

86:
87: /* ***************************************************************
88: * PROCEDURE populate_lm_sprd_dtl_sec_qty
89: *
90: * Synopsis : populate_lm_sprd_dtl_sec_qty
91: *
92: * Description : Get all items from lm_sprd_dtl that has dual uom
93: * and derives the secondary qty a (i.e the qty value
94: * converted from primary to secondary uom).

Line 92: * Description : Get all items from lm_sprd_dtl that has dual uom

88: * PROCEDURE populate_lm_sprd_dtl_sec_qty
89: *
90: * Synopsis : populate_lm_sprd_dtl_sec_qty
91: *
92: * Description : Get all items from lm_sprd_dtl that has dual uom
93: * and derives the secondary qty a (i.e the qty value
94: * converted from primary to secondary uom).
95: *
96: *

Line 100: PROCEDURE populate_lm_sprd_dtl_sec_qty IS

96: *
97: * History :
98: * Shyam Sitaraman 03/10/03 Initial Implementation
99: * *************************************************************** */
100: PROCEDURE populate_lm_sprd_dtl_sec_qty IS
101: CURSOR C_check_Item_dual_ind(vItem_id NUMBER) IS
102: SELECT item_um2
103: FROM ic_item_mst_b
104: Where item_id = vItem_id

Line 107: CURSOR C_get_lm_sprd_dtl IS

103: FROM ic_item_mst_b
104: Where item_id = vItem_id
105: AND dualum_ind > 0;
106:
107: CURSOR C_get_lm_sprd_dtl IS
108: SELECT *
109: FROM lm_sprd_dtl;
110:
111: l_dual_um ic_item_mst_b.item_um2%TYPE;

Line 109: FROM lm_sprd_dtl;

105: AND dualum_ind > 0;
106:
107: CURSOR C_get_lm_sprd_dtl IS
108: SELECT *
109: FROM lm_sprd_dtl;
110:
111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN

Line 114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP

110:
111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl

Line 115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);

111: l_dual_um ic_item_mst_b.item_um2%TYPE;
112:
113: BEGIN
114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,

Line 118: UPDATE lm_sprd_dtl

114: FOR lm_sprd_dtl_rec IN C_get_lm_sprd_dtl LOOP
115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),

Line 119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,

115: OPEN C_check_Item_dual_ind(lm_sprd_dtl_rec.Item_id);
116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um

Line 120: lm_sprd_dtl_rec.qty,

116: FETCH C_check_Item_dual_ind INTO l_dual_um;
117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id

Line 121: lm_sprd_dtl_rec.item_um,

117: IF C_check_Item_dual_ind%FOUND THEN
118: UPDATE lm_sprd_dtl
119: SET secondary_qty = GMICUOM.UOM_CONVERSION (lm_sprd_dtl_rec.Item_id,0,
120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;

Line 124: WHERE line_id = lm_sprd_dtl_rec.line_id

120: lm_sprd_dtl_rec.qty,
121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;
126: END IF;
127: CLOSE C_check_Item_dual_ind;
128: END LOOP;

Line 125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;

121: lm_sprd_dtl_rec.item_um,
122: l_dual_um,0),
123: secondary_um = l_dual_um
124: WHERE line_id = lm_sprd_dtl_rec.line_id
125: AND sprd_id = lm_sprd_dtl_rec.sprd_id;
126: END IF;
127: CLOSE C_check_Item_dual_ind;
128: END LOOP;
129: EXCEPTION

Line 133: ,p_table_name => 'LM_SPRD_DTL'

129: EXCEPTION
130: WHEN OTHERS THEN
131: P_line_no := P_line_no + 1;
132: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
133: ,p_table_name => 'LM_SPRD_DTL'
134: ,p_db_error => sqlerrm
135: ,p_param1 => NULL
136: ,p_param2 => NULL
137: ,p_param3 => NULL

Line 145: END populate_lm_sprd_dtl_sec_qty;

141: ,p_message_type => 'D'
142: ,p_line_no => P_line_no
143: ,p_position=> 1
144: ,p_base_message=> NULL);
145: END populate_lm_sprd_dtl_sec_qty;
146:
147:
148: /* ***************************************************************
149: * PROCEDURE populate_parsed_expressions

Line 709: GMD_LM_MIGRATION.populate_lm_sprd_dtl_sec_qty;

705: P_run_id := GMA_MIGRATION.gma_migration_start
706: (p_app_short_name => 'GMD'
707: ,p_mig_name => 'GMD_LM_MIGRATION');
708: GMD_LM_MIGRATION.generate_tech_parm_id;
709: GMD_LM_MIGRATION.populate_lm_sprd_dtl_sec_qty;
710: GMD_LM_MIGRATION.populate_parsed_expressions;
711: GMD_LM_MIGRATION.insert_gmd_tech_seq_comps;
712: GMD_LM_MIGRATION.insert_gmd_tech_data_comps;
713: GMA_MIGRATION.gma_migration_end (l_run_id => p_run_id);