DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RES_ENGINE dependencies on FND_GLOBAL

Line 1502: last_updated_by = fnd_global.user_id,

1498: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1499: last_insp_date = sysdate,
1500: valid_flag = 2,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: where shipment_line_id = p_shipment_line_id
1505: and (interface_txn_id IS NULL or interface_txn_id = l_txn_id)
1506: returning criteria_id, inspection_result into c_id, lot_result;

Line 1503: last_update_login = fnd_global.login_id

1499: last_insp_date = sysdate,
1500: valid_flag = 2,
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id
1504: where shipment_line_id = p_shipment_line_id
1505: and (interface_txn_id IS NULL or interface_txn_id = l_txn_id)
1506: returning criteria_id, inspection_result into c_id, lot_result;
1507:

Line 1519: last_updated_by = fnd_global.user_id,

1515: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1516: last_insp_date = sysdate,
1517: valid_flag = 2,
1518: last_update_date = sysdate,
1519: last_updated_by = fnd_global.user_id,
1520: last_update_login = fnd_global.login_id
1521: where insp_lot_id = p_insp_lot_id
1522: returning criteria_id, inspection_result into c_id, lot_result;
1523: end if;

Line 1520: last_update_login = fnd_global.login_id

1516: last_insp_date = sysdate,
1517: valid_flag = 2,
1518: last_update_date = sysdate,
1519: last_updated_by = fnd_global.user_id,
1520: last_update_login = fnd_global.login_id
1521: where insp_lot_id = p_insp_lot_id
1522: returning criteria_id, inspection_result into c_id, lot_result;
1523: end if;
1524: end if;