DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RES_ENGINE dependencies on FND_GLOBAL

Line 1344: last_updated_by = fnd_global.user_id,

1340: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1341: last_insp_date = sysdate,
1342: valid_flag = 2,
1343: last_update_date = sysdate,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_login = fnd_global.login_id
1346: where shipment_line_id = p_shipment_line_id
1347: returning criteria_id, inspection_result into c_id, lot_result;
1348: else

Line 1345: last_update_login = fnd_global.login_id

1341: last_insp_date = sysdate,
1342: valid_flag = 2,
1343: last_update_date = sysdate,
1344: last_updated_by = fnd_global.user_id,
1345: last_update_login = fnd_global.login_id
1346: where shipment_line_id = p_shipment_line_id
1347: returning criteria_id, inspection_result into c_id, lot_result;
1348: else
1349: update qa_skiplot_rcv_results

Line 1358: last_updated_by = fnd_global.user_id,

1354: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1355: last_insp_date = sysdate,
1356: valid_flag = 2,
1357: last_update_date = sysdate,
1358: last_updated_by = fnd_global.user_id,
1359: last_update_login = fnd_global.login_id
1360: where insp_lot_id = p_insp_lot_id
1361: returning criteria_id, inspection_result into c_id, lot_result;
1362: end if;

Line 1359: last_update_login = fnd_global.login_id

1355: last_insp_date = sysdate,
1356: valid_flag = 2,
1357: last_update_date = sysdate,
1358: last_updated_by = fnd_global.user_id,
1359: last_update_login = fnd_global.login_id
1360: where insp_lot_id = p_insp_lot_id
1361: returning criteria_id, inspection_result into c_id, lot_result;
1362: end if;
1363: end if;