DBA Data[Home] [Help]

APPS.GMD_SUBSTITUTION_PVT dependencies on GMD_ITEM_SUBSTITUTION_DTL_S

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 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