DBA Data[Home] [Help]

APPS.GMIVILC dependencies on IC_ITEM_CNV

Line 78: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE

74: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
75: , p_item_cnv_rec IN GMIGAPI.conv_rec_typ
76: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
77: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
78: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
79: , x_return_status OUT NOCOPY VARCHAR2
80: , x_msg_count OUT NOCOPY NUMBER
81: , x_msg_data OUT NOCOPY VARCHAR2
82: )

Line 395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */

391: END IF;
392: END IF;
393:
394:
395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */
396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;

Line 397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;

393:
394:
395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */
396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;

Line 398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;

394:
395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */
396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

Line 399: x_ic_item_cnv_row.um_type := l_um_type;

395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */
396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;

Line 400: x_ic_item_cnv_row.type_factor := l_factor;

396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;

Line 401: x_ic_item_cnv_row.last_update_date := SYSDATE;

397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;

Line 402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;

Line 403: x_ic_item_cnv_row.trans_cnt := 1;

399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;

Line 404: x_ic_item_cnv_row.delete_mark := 0;

400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;

Line 405: x_ic_item_cnv_row.text_code := NULL;

401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

Line 406: x_ic_item_cnv_row.creation_date := SYSDATE;

402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
410:

Line 407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;

403: x_ic_item_cnv_row.trans_cnt := 1;
404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
410:
411:

Line 408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;

404: x_ic_item_cnv_row.delete_mark := 0;
405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
410:
411:
412: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;

405: x_ic_item_cnv_row.text_code := NULL;
406: x_ic_item_cnv_row.creation_date := SYSDATE;
407: x_ic_item_cnv_row.created_by := GMIGUTL.DEFAULT_USER_ID;
408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
410:
411:
412: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
413: , p_data => x_msg_data