eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_API_GRP

Line 55: gmd_api_grp.fetch_parm_values ( P_orgn_id => p_recipe_detail_rec.organization_id,

51: /* provided */
52: /* ==================================== */
53: IF (p_recipe_detail_rec.organization_id IS NOT NULL) THEN
54:
55: gmd_api_grp.fetch_parm_values ( P_orgn_id => p_recipe_detail_rec.organization_id,
56: X_out_rec => l_out_rec,
57: X_return_status => l_return_stat);
58:
59: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN

Line 101: gmd_api_grp.user_id)

97: ,NVL(p_recipe_detail_rec.contiguous_ind,0)
98: ,p_recipe_detail_rec.text_code
99: ,NVL(p_recipe_detail_rec.creation_date,SYSDATE)
100: ,NVL(p_recipe_detail_rec.created_by,
101: gmd_api_grp.user_id)
102: ,NVL(p_recipe_detail_rec.last_updated_by ,
103: gmd_api_grp.user_id)
104: ,NVL(p_recipe_detail_rec.last_update_date,
105: SYSDATE)

Line 103: gmd_api_grp.user_id)

99: ,NVL(p_recipe_detail_rec.creation_date,SYSDATE)
100: ,NVL(p_recipe_detail_rec.created_by,
101: gmd_api_grp.user_id)
102: ,NVL(p_recipe_detail_rec.last_updated_by ,
103: gmd_api_grp.user_id)
104: ,NVL(p_recipe_detail_rec.last_update_date,
105: SYSDATE)
106: ,NVL(p_recipe_detail_rec.last_update_login,
107: gmd_api_grp.login_id)

Line 107: gmd_api_grp.login_id)

103: gmd_api_grp.user_id)
104: ,NVL(p_recipe_detail_rec.last_update_date,
105: SYSDATE)
106: ,NVL(p_recipe_detail_rec.last_update_login,
107: gmd_api_grp.login_id)
108: ,p_recipe_detail_rec.fixed_process_loss
109: ,p_recipe_detail_rec.fixed_process_loss_uom
110: );
111:

Line 195: gmd_api_grp.user_id) ,

191: p_recipe_detail_rec.text_code ,
192: NVL(p_recipe_detail_rec.creation_date,
193: SYSDATE) ,
194: NVL(p_recipe_detail_rec.created_by,
195: gmd_api_grp.user_id) ,
196: p_recipe_detail_rec.last_updated_by ,
197: NVL(p_recipe_detail_rec.last_update_date,
198: SYSDATE) ,
199: NVL(p_recipe_detail_rec.last_update_login,

Line 200: gmd_api_grp.login_id)

196: p_recipe_detail_rec.last_updated_by ,
197: NVL(p_recipe_detail_rec.last_update_date,
198: SYSDATE) ,
199: NVL(p_recipe_detail_rec.last_update_login,
200: gmd_api_grp.login_id)
201: );
202: END IF;
203:
204: EXCEPTION

Line 261: IF NOT gmd_api_grp.setup_done THEN

257: /* Initialization of all status */
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: /* Intialize the setup fields */
261: IF NOT gmd_api_grp.setup_done THEN
262: gmd_api_grp.setup_done := gmd_api_grp.setup;
263: END IF;
264: IF NOT gmd_api_grp.setup_done THEN
265: RAISE setup_failure;

Line 262: gmd_api_grp.setup_done := gmd_api_grp.setup;

258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: /* Intialize the setup fields */
261: IF NOT gmd_api_grp.setup_done THEN
262: gmd_api_grp.setup_done := gmd_api_grp.setup;
263: END IF;
264: IF NOT gmd_api_grp.setup_done THEN
265: RAISE setup_failure;
266: END IF;

Line 264: IF NOT gmd_api_grp.setup_done THEN

260: /* Intialize the setup fields */
261: IF NOT gmd_api_grp.setup_done THEN
262: gmd_api_grp.setup_done := gmd_api_grp.setup;
263: END IF;
264: IF NOT gmd_api_grp.setup_done THEN
265: RAISE setup_failure;
266: END IF;
267:
268: /* ============================================== */

Line 280: gmd_api_grp.user_id),

276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: g_orgn_id => p_recipe_vr_rec.organization_id,
279: g_user_id => NVL(p_recipe_vr_rec.created_by,
280: gmd_api_grp.user_id),
281: p_required_ind => 'N',
282: x_return_status => l_return_status,
283: x_msg_count => l_msg_count,
284: x_msg_data => l_msg_data,

Line 425: ,NVL(p_recipe_vr_rec.CREATED_BY , gmd_api_grp.user_id )

421: ,p_recipe_vr_flex_rec.ATTRIBUTE27
422: ,p_recipe_vr_flex_rec.ATTRIBUTE28
423: ,p_recipe_vr_flex_rec.ATTRIBUTE29
424: ,p_recipe_vr_flex_rec.ATTRIBUTE30
425: ,NVL(p_recipe_vr_rec.CREATED_BY , gmd_api_grp.user_id )
426: ,NVL(p_recipe_vr_rec.CREATION_DATE, SYSDATE)
427: ,NVL(p_recipe_vr_rec.LAST_UPDATED_BY , gmd_api_grp.user_id )
428: ,NVL(p_recipe_vr_rec.LAST_UPDATE_DATE, SYSDATE)
429: ,NVL(p_recipe_vr_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id )

Line 427: ,NVL(p_recipe_vr_rec.LAST_UPDATED_BY , gmd_api_grp.user_id )

423: ,p_recipe_vr_flex_rec.ATTRIBUTE29
424: ,p_recipe_vr_flex_rec.ATTRIBUTE30
425: ,NVL(p_recipe_vr_rec.CREATED_BY , gmd_api_grp.user_id )
426: ,NVL(p_recipe_vr_rec.CREATION_DATE, SYSDATE)
427: ,NVL(p_recipe_vr_rec.LAST_UPDATED_BY , gmd_api_grp.user_id )
428: ,NVL(p_recipe_vr_rec.LAST_UPDATE_DATE, SYSDATE)
429: ,NVL(p_recipe_vr_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id )
430: ,NVL(p_recipe_vr_rec.DELETE_MARK , 0)
431: ,p_recipe_vr_rec.VALIDITY_RULE_STATUS

Line 429: ,NVL(p_recipe_vr_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id )

425: ,NVL(p_recipe_vr_rec.CREATED_BY , gmd_api_grp.user_id )
426: ,NVL(p_recipe_vr_rec.CREATION_DATE, SYSDATE)
427: ,NVL(p_recipe_vr_rec.LAST_UPDATED_BY , gmd_api_grp.user_id )
428: ,NVL(p_recipe_vr_rec.LAST_UPDATE_DATE, SYSDATE)
429: ,NVL(p_recipe_vr_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id )
430: ,NVL(p_recipe_vr_rec.DELETE_MARK , 0)
431: ,p_recipe_vr_rec.VALIDITY_RULE_STATUS
432: ,p_recipe_vr_rec.PLANNED_PROCESS_LOSS /* Added for Bug No.5954361*/
433: ,p_recipe_vr_rec.FIXED_PROCESS_LOSS /* RLNAGARA B6997624*/

Line 521: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)

517: ,p_recipe_mtl_rec.ROUTINGSTEP_ID
518: ,p_recipe_mtl_rec.FORMULALINE_ID
519: ,p_recipe_mtl_rec.text_code
520: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
521: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
522: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
523: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
524: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
525: ,p_recipe_mtl_flex_rec.ATTRIBUTE_CATEGORY

Line 522: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)

518: ,p_recipe_mtl_rec.FORMULALINE_ID
519: ,p_recipe_mtl_rec.text_code
520: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
521: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
522: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
523: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
524: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
525: ,p_recipe_mtl_flex_rec.ATTRIBUTE_CATEGORY
526: ,p_recipe_mtl_flex_rec.ATTRIBUTE1

Line 524: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)

520: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
521: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
522: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
523: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
524: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
525: ,p_recipe_mtl_flex_rec.ATTRIBUTE_CATEGORY
526: ,p_recipe_mtl_flex_rec.ATTRIBUTE1
527: ,p_recipe_mtl_flex_rec.ATTRIBUTE2
528: ,p_recipe_mtl_flex_rec.ATTRIBUTE3

Line 610: gmd_api_grp.fetch_parm_values ( P_orgn_id => p_recipe_detail_rec.organization_id,

606: /* provided */
607: /* ==================================== */
608:
609: IF (p_recipe_detail_rec.organization_id IS NOT NULL) THEN
610: gmd_api_grp.fetch_parm_values ( P_orgn_id => p_recipe_detail_rec.organization_id,
611: X_out_rec => l_out_rec,
612: X_return_status => l_return_stat);
613:
614: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN

Line 630: gmd_api_grp.user_id),

626: text_code = p_recipe_detail_rec.text_code,
627: process_loss = p_recipe_detail_rec.process_loss,
628: contiguous_ind = NVL(p_recipe_detail_rec.contiguous_ind,0),
629: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
630: gmd_api_grp.user_id),
631: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
632: sysdate),
633: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
634: gmd_api_grp.login_id),

Line 634: gmd_api_grp.login_id),

630: gmd_api_grp.user_id),
631: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
632: sysdate),
633: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
634: gmd_api_grp.login_id),
635: fixed_process_loss = p_recipe_detail_rec.fixed_process_loss, /* 6811759 */
636: fixed_process_loss_uom = p_recipe_detail_rec.fixed_process_loss_uom
637: WHERE recipe_process_loss_id = p_recipe_detail_rec.recipe_process_loss_id;
638: END IF;

Line 688: gmd_api_grp.user_id),

684: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
685: UPDATE GMD_RECIPE_CUSTOMERS
686: SET text_code = p_recipe_detail_rec.text_code,
687: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
688: gmd_api_grp.user_id),
689: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
690: sysdate),
691: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
692: gmd_api_grp.login_id)

Line 692: gmd_api_grp.login_id)

688: gmd_api_grp.user_id),
689: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
690: sysdate),
691: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
692: gmd_api_grp.login_id)
693: WHERE recipe_id = p_recipe_detail_rec.recipe_id AND
694: customer_id = p_recipe_detail_rec.customer_id;
695: END IF;
696: EXCEPTION

Line 928: p_vr_update_tbl(l_row_cnt).p_value := NVL(p_recipe_vr_rec.last_update_login, gmd_api_grp.login_id);

924: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(NVL(p_recipe_vr_rec.last_update_date,SYSDATE));
925: l_row_cnt := l_row_cnt + 1;
926:
927: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'LAST_UPDATE_LOGIN';
928: p_vr_update_tbl(l_row_cnt).p_value := NVL(p_recipe_vr_rec.last_update_login, gmd_api_grp.login_id);
929: l_row_cnt := l_row_cnt + 1;
930:
931: -- 4134275
932: -- KSHUKLA added NVL conditions for the 5079519

Line 1250: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,

1246: p_recipe_detail_rec.MASS_QTY ,
1247: p_recipe_detail_rec.MASS_STD_UOM ,
1248: p_recipe_detail_rec.VOLUME_QTY ,
1249: p_recipe_detail_rec.VOLUME_STD_UOM ,
1250: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1251: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1252: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1253: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1254: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,

Line 1253: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),

1249: p_recipe_detail_rec.VOLUME_STD_UOM ,
1250: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1251: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1252: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1253: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1254: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1255: p_flex_insert_rec.ATTRIBUTE1 ,
1256: p_flex_insert_rec.ATTRIBUTE2 ,
1257: p_flex_insert_rec.ATTRIBUTE3 ,

Line 1254: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,

1250: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1251: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1252: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1253: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1254: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1255: p_flex_insert_rec.ATTRIBUTE1 ,
1256: p_flex_insert_rec.ATTRIBUTE2 ,
1257: p_flex_insert_rec.ATTRIBUTE3 ,
1258: p_flex_insert_rec.ATTRIBUTE4 ,

Line 1298: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),

1294: MASS_QTY = p_recipe_detail_rec.mass_qty,
1295: MASS_STD_UOM = p_recipe_detail_rec.mass_std_uom,
1296: VOLUME_QTY = p_recipe_detail_rec.volume_qty,
1297: VOLUME_STD_UOM = p_recipe_detail_rec.volume_std_uom,
1298: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1299: TEXT_CODE = p_recipe_detail_rec.text_code,
1300: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id),
1301: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate) ,
1302: ATTRIBUTE1 = p_flex_update_rec.attribute1,

Line 1300: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id),

1296: VOLUME_QTY = p_recipe_detail_rec.volume_qty,
1297: VOLUME_STD_UOM = p_recipe_detail_rec.volume_std_uom,
1298: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1299: TEXT_CODE = p_recipe_detail_rec.text_code,
1300: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id),
1301: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate) ,
1302: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1303: ATTRIBUTE2 = p_flex_update_rec.attribute2,
1304: ATTRIBUTE3 = p_flex_update_rec.attribute3,

Line 1454: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,

1450: p_recipe_detail_rec.routingstep_id ,
1451: p_recipe_detail_rec.oprn_line_id ,
1452: p_recipe_detail_rec.activity_factor ,
1453: p_recipe_detail_rec.organization_id ,
1454: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1455: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1456: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1457: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1458: p_recipe_detail_rec.TEXT_CODE ,

Line 1457: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,

1453: p_recipe_detail_rec.organization_id ,
1454: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1455: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1456: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1457: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1458: p_recipe_detail_rec.TEXT_CODE ,
1459: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1460: p_flex_insert_rec.ATTRIBUTE1 ,
1461: p_flex_insert_rec.ATTRIBUTE2 ,

Line 1459: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,

1455: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1456: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1457: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1458: p_recipe_detail_rec.TEXT_CODE ,
1459: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1460: p_flex_insert_rec.ATTRIBUTE1 ,
1461: p_flex_insert_rec.ATTRIBUTE2 ,
1462: p_flex_insert_rec.ATTRIBUTE3 ,
1463: p_flex_insert_rec.ATTRIBUTE4 ,

Line 1498: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),

1494: IF (l_dml_type = 'U') THEN
1495: UPDATE GMD_RECIPE_ORGN_ACTIVITIES
1496: SET ACTIVITY_FACTOR = p_recipe_detail_rec.activity_factor,
1497: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate),
1498: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1499: TEXT_CODE = p_recipe_detail_rec.text_code,
1500: LAST_UPDATED_BY = p_recipe_detail_rec.last_updated_by,
1501: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1502: ATTRIBUTE2 = p_flex_update_rec.attribute2,

Line 1682: NVL(p_recipe_detail_rec.CREATED_BY , gmd_api_grp.user_id) ,

1678: p_recipe_detail_rec.PROCESS_UM ,
1679: p_recipe_detail_rec.USAGE_UOM ,
1680: p_recipe_detail_rec.RESOURCE_USAGE ,
1681: p_recipe_detail_rec.PROCESS_QTY ,
1682: NVL(p_recipe_detail_rec.CREATED_BY , gmd_api_grp.user_id) ,
1683: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1684: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1685: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1686: p_recipe_detail_rec.TEXT_CODE ,

Line 1685: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,

1681: p_recipe_detail_rec.PROCESS_QTY ,
1682: NVL(p_recipe_detail_rec.CREATED_BY , gmd_api_grp.user_id) ,
1683: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1684: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1685: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1686: p_recipe_detail_rec.TEXT_CODE ,
1687: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1688: p_flex_insert_rec.ATTRIBUTE1 ,
1689: p_flex_insert_rec.ATTRIBUTE2 ,

Line 1687: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,

1683: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1684: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1685: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1686: p_recipe_detail_rec.TEXT_CODE ,
1687: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1688: p_flex_insert_rec.ATTRIBUTE1 ,
1689: p_flex_insert_rec.ATTRIBUTE2 ,
1690: p_flex_insert_rec.ATTRIBUTE3 ,
1691: p_flex_insert_rec.ATTRIBUTE4 ,

Line 1736: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),

1732: USAGE_UOM = p_recipe_detail_rec.USAGE_UOM ,
1733: RESOURCE_USAGE = p_recipe_detail_rec.RESOURCE_USAGE,
1734: PROCESS_QTY = p_recipe_detail_rec.PROCESS_QTY ,
1735: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date, sysdate),
1736: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1737: TEXT_CODE = p_recipe_detail_rec.text_code,
1738: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id) ,
1739: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1740: ATTRIBUTE2 = p_flex_update_rec.attribute2,

Line 1738: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id) ,

1734: PROCESS_QTY = p_recipe_detail_rec.PROCESS_QTY ,
1735: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date, sysdate),
1736: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1737: TEXT_CODE = p_recipe_detail_rec.text_code,
1738: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id) ,
1739: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1740: ATTRIBUTE2 = p_flex_update_rec.attribute2,
1741: ATTRIBUTE3 = p_flex_update_rec.attribute3,
1742: ATTRIBUTE4 = p_flex_update_rec.attribute4,