390:
391: PRAGMA AUTONOMOUS_TRANSACTION;
392:
393: l_request_id NUMBER;
394: l_update_by NUMBER := fnd_global.user_id;
395: l_update_name VARCHAR2(100);
396:
397: l_source_code VARCHAR2(30);
398:
896:
897: PRAGMA AUTONOMOUS_TRANSACTION;
898:
899: l_request_id NUMBER;
900: l_update_by NUMBER := fnd_global.user_id;
901: l_update_name VARCHAR2(100);
902:
903: CURSOR update_cur IS
904: SELECT user_name
1218: PRAGMA AUTONOMOUS_TRANSACTION;
1219:
1220: l_header_id NUMBER;
1221: l_interface_id NUMBER;
1222: l_update_by NUMBER := fnd_global.user_id;
1223: l_lot_control_code NUMBER;
1224: l_serial_control_code NUMBER;
1225: l_transaction_qty NUMBER := -p_transaction_qty;
1226:
1673: -- to here. kabalakr.
1674: l_header_id := FND_API.G_MISS_NUM;
1675:
1676: -- populate Header WHO columns
1677: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1678: l_trohdr_rec.creation_date := sysdate;
1679: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1680: l_trohdr_rec.last_update_date := sysdate;
1681: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1675:
1676: -- populate Header WHO columns
1677: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1678: l_trohdr_rec.creation_date := sysdate;
1679: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1680: l_trohdr_rec.last_update_date := sysdate;
1681: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1682:
1683: l_trohdr_rec.from_subinventory_code := p_from_subinventory;
1677: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1678: l_trohdr_rec.creation_date := sysdate;
1679: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1680: l_trohdr_rec.last_update_date := sysdate;
1681: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1682:
1683: l_trohdr_rec.from_subinventory_code := p_from_subinventory;
1684: l_trohdr_rec.to_subinventory_code := p_to_subinventory;
1685:
1695: l_line_num := l_line_num + 1;
1696:
1697: -- populate Lines WHO columns.
1698:
1699: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1700: l_trolin_tbl(l_order_count).creation_date := sysdate;
1701: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1702: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1703: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1697: -- populate Lines WHO columns.
1698:
1699: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1700: l_trolin_tbl(l_order_count).creation_date := sysdate;
1701: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1702: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1703: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1704:
1705: l_trolin_tbl(l_order_count).date_required := p_date_required;
1699: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1700: l_trolin_tbl(l_order_count).creation_date := sysdate;
1701: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1702: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1703: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1704:
1705: l_trolin_tbl(l_order_count).date_required := p_date_required;
1706: l_trolin_tbl(l_order_count).status_date := sysdate;
1707:
2274: l_entity_type VARCHAR2(30);
2275: l_interface_id NUMBER;
2276: l_lot_control_code NUMBER;
2277: l_serial_control_code NUMBER;
2278: l_update_by NUMBER := fnd_global.user_id;
2279:
2280: CURSOR wip_cur IS
2281: SELECT wip_entity_id, entity_type
2282: FROM wip_entities
3309:
3310: PRAGMA AUTONOMOUS_TRANSACTION;
3311:
3312: l_request_id NUMBER;
3313: l_update_by NUMBER := fnd_global.user_id;
3314: l_update_name VARCHAR2(100);
3315:
3316: l_header_id NUMBER;
3317:
3494:
3495: PRAGMA AUTONOMOUS_TRANSACTION;
3496:
3497: l_request_id NUMBER;
3498: l_update_by NUMBER := fnd_global.user_id;
3499: l_update_name VARCHAR2(100);
3500:
3501: l_header_id NUMBER;
3502: