APPS.GMD_SUBSTITUTION_PVT dependencies on GMD_ITEM_SUBSTITUTION_DTL

Line 223: ( p_substitution_line_id IN gmd_item_substitution_dtl.substitution_line_id%TYPE

219: /* History : */
220: /* Rajender Nalla 09-OCT-06 Initial implementation. */
221: /* =============================================================== */
222: PROCEDURE Create_substitution_detail
223: ( p_substitution_line_id IN gmd_item_substitution_dtl.substitution_line_id%TYPE
224: , p_substitution_id IN gmd_item_substitution_dtl.substitution_id%TYPE
225: , p_substitution_dtl_rec IN gmd_substitution_pub.gmd_substitution_dtl_rec_type
226: , x_message_count OUT NOCOPY NUMBER
227: , x_message_list OUT NOCOPY VARCHAR2

Line 224: , p_substitution_id IN gmd_item_substitution_dtl.substitution_id%TYPE

220: /* Rajender Nalla 09-OCT-06 Initial implementation. */
221: /* =============================================================== */
222: PROCEDURE Create_substitution_detail
223: ( p_substitution_line_id IN gmd_item_substitution_dtl.substitution_line_id%TYPE
224: , p_substitution_id IN gmd_item_substitution_dtl.substitution_id%TYPE
225: , p_substitution_dtl_rec IN gmd_substitution_pub.gmd_substitution_dtl_rec_type
226: , x_message_count OUT NOCOPY NUMBER
227: , x_message_list OUT NOCOPY VARCHAR2
228: , x_return_status OUT NOCOPY VARCHAR2

Line 240: GMD_ITEM_SUBSTITUTION_DTL_PKG.INSERT_ROW(

236: /* Set the return status to success initially */
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Call the table handler for insert of substitution details
240: GMD_ITEM_SUBSTITUTION_DTL_PKG.INSERT_ROW(
241: X_ROWID => l_row_id,
242: X_SUBSTITUTION_LINE_ID => p_substitution_line_id,
243: X_SUBSTITUTION_ID => p_substitution_id,
244: X_INVENTORY_ITEM_ID => p_substitution_dtl_rec.inventory_item_id,

Line 585: ( p_substitution_dtl_rec IN gmd_item_substitution_dtl%ROWTYPE

581: /* History : */
582: /* Rajender Nalla 09-OCT-06 Initial implementation. */
583: /* =============================================================== */
584: PROCEDURE Update_substitution_detail
585: ( p_substitution_dtl_rec IN gmd_item_substitution_dtl%ROWTYPE
586: , x_message_count OUT NOCOPY NUMBER
587: , x_message_list OUT NOCOPY VARCHAR2
588: , x_return_status OUT NOCOPY VARCHAR2
589: ) IS

Line 592: l_substitution_dtl_rec gmd_item_substitution_dtl%ROWTYPE;

588: , x_return_status OUT NOCOPY VARCHAR2
589: ) IS
590: /* Local variable section */
591: l_api_name CONSTANT VARCHAR2(30) := 'Update_substitution_detail';
592: l_substitution_dtl_rec gmd_item_substitution_dtl%ROWTYPE;
593: BEGIN
594: /* Set the return status to success initially */
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:

Line 598: GMD_ITEM_SUBSTITUTION_DTL_PKG.UPDATE_ROW(

594: /* Set the return status to success initially */
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: -- Call the table handler for update of substitution details
598: GMD_ITEM_SUBSTITUTION_DTL_PKG.UPDATE_ROW(
599: X_SUBSTITUTION_LINE_ID => p_substitution_dtl_rec.substitution_line_id,
600: X_SUBSTITUTION_ID => p_substitution_dtl_rec.substitution_id,
601: X_INVENTORY_ITEM_ID => p_substitution_dtl_rec.inventory_item_id,
602: X_UNIT_QTY => p_substitution_dtl_rec.unit_qty,

Line 829: FROM gmd_item_substitution_dtl

825: , created_by
826: , last_update_date
827: , last_updated_by
828: , last_update_login
829: FROM gmd_item_substitution_dtl
830: WHERE substitution_id = vSubstitution_id;
831:
832: Cursor get_fm_substitution_tbl(vSubstitution_id NUMBER) IS
833: SELECT formula_id

Line 901: select gmd_item_substitution_dtl_s.nextval

897: END IF;
898:
899: -- Insert substitution detail
900: -- set the primary key
901: select gmd_item_substitution_dtl_s.nextval
902: into l_substitution_line_id
903: from dual;
904:
905: Create_substitution_detail