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 526: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)

522: ,p_recipe_mtl_rec.ROUTINGSTEP_ID
523: ,p_recipe_mtl_rec.FORMULALINE_ID
524: ,p_recipe_mtl_rec.text_code
525: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
526: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
527: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
528: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
529: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
530: --Bug 10109808 : Adding Additional parameters in Insert Statement Starts

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

523: ,p_recipe_mtl_rec.FORMULALINE_ID
524: ,p_recipe_mtl_rec.text_code
525: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
526: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
527: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
528: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
529: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
530: --Bug 10109808 : Adding Additional parameters in Insert Statement Starts
531: ,p_recipe_mtl_rec.MINIMUM_TRANSFER_QTY

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

525: ,NVL(p_recipe_mtl_rec.creation_date,SYSDATE)
526: ,NVL(p_recipe_mtl_rec.created_by,gmd_Api_grp.user_id)
527: ,NVL(p_recipe_mtl_rec.last_updated_by,gmd_api_grp.user_id)
528: ,NVL(p_recipe_mtl_rec.last_update_date,sysdate)
529: ,NVL(p_recipe_mtl_rec.last_update_login,gmd_Api_grp.login_id)
530: --Bug 10109808 : Adding Additional parameters in Insert Statement Starts
531: ,p_recipe_mtl_rec.MINIMUM_TRANSFER_QTY
532: ,p_recipe_mtl_rec.MINIMUM_DELAY
533: ,p_recipe_mtl_rec.MAXIMUM_DELAY

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

616: /* provided */
617: /* ==================================== */
618:
619: IF (p_recipe_detail_rec.organization_id IS NOT NULL) THEN
620: gmd_api_grp.fetch_parm_values ( P_orgn_id => p_recipe_detail_rec.organization_id,
621: X_out_rec => l_out_rec,
622: X_return_status => l_return_stat);
623:
624: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN

Line 640: gmd_api_grp.user_id),

636: text_code = p_recipe_detail_rec.text_code,
637: process_loss = p_recipe_detail_rec.process_loss,
638: contiguous_ind = NVL(p_recipe_detail_rec.contiguous_ind,0),
639: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
640: gmd_api_grp.user_id),
641: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
642: sysdate),
643: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
644: gmd_api_grp.login_id),

Line 644: gmd_api_grp.login_id),

640: gmd_api_grp.user_id),
641: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
642: sysdate),
643: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
644: gmd_api_grp.login_id),
645: fixed_process_loss = p_recipe_detail_rec.fixed_process_loss, /* 6811759 */
646: fixed_process_loss_uom = p_recipe_detail_rec.fixed_process_loss_uom
647: WHERE recipe_process_loss_id = p_recipe_detail_rec.recipe_process_loss_id;
648: END IF;

Line 698: gmd_api_grp.user_id),

694: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
695: UPDATE GMD_RECIPE_CUSTOMERS
696: SET text_code = p_recipe_detail_rec.text_code,
697: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
698: gmd_api_grp.user_id),
699: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
700: sysdate),
701: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
702: gmd_api_grp.login_id)

Line 702: gmd_api_grp.login_id)

698: gmd_api_grp.user_id),
699: last_update_date = NVL(p_recipe_detail_rec.last_update_date,
700: sysdate),
701: last_update_login = NVL(p_recipe_detail_rec.last_update_login,
702: gmd_api_grp.login_id)
703: WHERE recipe_id = p_recipe_detail_rec.recipe_id AND
704: customer_id = p_recipe_detail_rec.customer_id;
705: END IF;
706: EXCEPTION

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

934: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(NVL(p_recipe_vr_rec.last_update_date,SYSDATE));
935: l_row_cnt := l_row_cnt + 1;
936:
937: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'LAST_UPDATE_LOGIN';
938: p_vr_update_tbl(l_row_cnt).p_value := NVL(p_recipe_vr_rec.last_update_login, gmd_api_grp.login_id);
939: l_row_cnt := l_row_cnt + 1;
940:
941: -- 4134275
942: -- KSHUKLA added NVL conditions for the 5079519

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

1256: p_recipe_detail_rec.MASS_QTY ,
1257: p_recipe_detail_rec.MASS_STD_UOM ,
1258: p_recipe_detail_rec.VOLUME_QTY ,
1259: p_recipe_detail_rec.VOLUME_STD_UOM ,
1260: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1261: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1262: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1263: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1264: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,

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

1259: p_recipe_detail_rec.VOLUME_STD_UOM ,
1260: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1261: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1262: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1263: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1264: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1265: p_flex_insert_rec.ATTRIBUTE1 ,
1266: p_flex_insert_rec.ATTRIBUTE2 ,
1267: p_flex_insert_rec.ATTRIBUTE3 ,

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

1260: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1261: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1262: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate),
1263: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN, gmd_api_grp.login_id),
1264: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1265: p_flex_insert_rec.ATTRIBUTE1 ,
1266: p_flex_insert_rec.ATTRIBUTE2 ,
1267: p_flex_insert_rec.ATTRIBUTE3 ,
1268: p_flex_insert_rec.ATTRIBUTE4 ,

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

1304: MASS_QTY = p_recipe_detail_rec.mass_qty,
1305: MASS_STD_UOM = p_recipe_detail_rec.mass_std_uom,
1306: VOLUME_QTY = p_recipe_detail_rec.volume_qty,
1307: VOLUME_STD_UOM = p_recipe_detail_rec.volume_std_uom,
1308: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1309: TEXT_CODE = p_recipe_detail_rec.text_code,
1310: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id),
1311: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate) ,
1312: ATTRIBUTE1 = p_flex_update_rec.attribute1,

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

1306: VOLUME_QTY = p_recipe_detail_rec.volume_qty,
1307: VOLUME_STD_UOM = p_recipe_detail_rec.volume_std_uom,
1308: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1309: TEXT_CODE = p_recipe_detail_rec.text_code,
1310: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id),
1311: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate) ,
1312: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1313: ATTRIBUTE2 = p_flex_update_rec.attribute2,
1314: ATTRIBUTE3 = p_flex_update_rec.attribute3,

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

1460: p_recipe_detail_rec.routingstep_id ,
1461: p_recipe_detail_rec.oprn_line_id ,
1462: p_recipe_detail_rec.activity_factor ,
1463: p_recipe_detail_rec.organization_id ,
1464: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1465: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1466: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1467: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1468: p_recipe_detail_rec.TEXT_CODE ,

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

1463: p_recipe_detail_rec.organization_id ,
1464: NVL(p_recipe_detail_rec.CREATED_BY, gmd_api_grp.user_id) ,
1465: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1466: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1467: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1468: p_recipe_detail_rec.TEXT_CODE ,
1469: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1470: p_flex_insert_rec.ATTRIBUTE1 ,
1471: p_flex_insert_rec.ATTRIBUTE2 ,

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

1465: NVL(p_recipe_detail_rec.CREATION_DATE,sysdate) ,
1466: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE,sysdate) ,
1467: NVL (p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1468: p_recipe_detail_rec.TEXT_CODE ,
1469: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1470: p_flex_insert_rec.ATTRIBUTE1 ,
1471: p_flex_insert_rec.ATTRIBUTE2 ,
1472: p_flex_insert_rec.ATTRIBUTE3 ,
1473: p_flex_insert_rec.ATTRIBUTE4 ,

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

1504: IF (l_dml_type = 'U') THEN
1505: UPDATE GMD_RECIPE_ORGN_ACTIVITIES
1506: SET ACTIVITY_FACTOR = p_recipe_detail_rec.activity_factor,
1507: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate),
1508: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1509: TEXT_CODE = p_recipe_detail_rec.text_code,
1510: LAST_UPDATED_BY = p_recipe_detail_rec.last_updated_by,
1511: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1512: ATTRIBUTE2 = p_flex_update_rec.attribute2,

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

1688: p_recipe_detail_rec.PROCESS_UM ,
1689: p_recipe_detail_rec.USAGE_UOM ,
1690: p_recipe_detail_rec.RESOURCE_USAGE ,
1691: p_recipe_detail_rec.PROCESS_QTY ,
1692: NVL(p_recipe_detail_rec.CREATED_BY , gmd_api_grp.user_id) ,
1693: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1694: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1695: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1696: p_recipe_detail_rec.TEXT_CODE ,

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

1691: p_recipe_detail_rec.PROCESS_QTY ,
1692: NVL(p_recipe_detail_rec.CREATED_BY , gmd_api_grp.user_id) ,
1693: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1694: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1695: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1696: p_recipe_detail_rec.TEXT_CODE ,
1697: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1698: p_flex_insert_rec.ATTRIBUTE1 ,
1699: p_flex_insert_rec.ATTRIBUTE2 ,

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

1693: NVL(p_recipe_detail_rec.CREATION_DATE, sysdate) ,
1694: NVL(p_recipe_detail_rec.LAST_UPDATE_DATE, sysdate) ,
1695: NVL(p_recipe_detail_rec.LAST_UPDATE_LOGIN , gmd_api_grp.login_id) ,
1696: p_recipe_detail_rec.TEXT_CODE ,
1697: NVL(p_recipe_detail_rec.LAST_UPDATED_BY, gmd_api_grp.user_id) ,
1698: p_flex_insert_rec.ATTRIBUTE1 ,
1699: p_flex_insert_rec.ATTRIBUTE2 ,
1700: p_flex_insert_rec.ATTRIBUTE3 ,
1701: p_flex_insert_rec.ATTRIBUTE4 ,

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

1742: USAGE_UOM = p_recipe_detail_rec.USAGE_UOM ,
1743: RESOURCE_USAGE = p_recipe_detail_rec.RESOURCE_USAGE,
1744: PROCESS_QTY = p_recipe_detail_rec.PROCESS_QTY ,
1745: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date, sysdate),
1746: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1747: TEXT_CODE = p_recipe_detail_rec.text_code,
1748: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id) ,
1749: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1750: ATTRIBUTE2 = p_flex_update_rec.attribute2,

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

1744: PROCESS_QTY = p_recipe_detail_rec.PROCESS_QTY ,
1745: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date, sysdate),
1746: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1747: TEXT_CODE = p_recipe_detail_rec.text_code,
1748: LAST_UPDATED_BY = NVL(p_recipe_detail_rec.last_updated_by, gmd_api_grp.user_id) ,
1749: ATTRIBUTE1 = p_flex_update_rec.attribute1,
1750: ATTRIBUTE2 = p_flex_update_rec.attribute2,
1751: ATTRIBUTE3 = p_flex_update_rec.attribute3,
1752: ATTRIBUTE4 = p_flex_update_rec.attribute4,