DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on FND_GLOBAL

Line 394: l_update_by NUMBER := fnd_global.user_id;

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:

Line 900: l_update_by NUMBER := fnd_global.user_id;

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

Line 1222: l_update_by NUMBER := fnd_global.user_id;

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:

Line 1677: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;

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;

Line 1679: l_trohdr_rec.last_updated_by := 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;

Line 1681: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;

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:

Line 1699: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;

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;

Line 1701: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_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;

Line 1703: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;

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:

Line 2278: l_update_by NUMBER := fnd_global.user_id;

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

Line 3313: l_update_by NUMBER := fnd_global.user_id;

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:

Line 3498: l_update_by NUMBER := fnd_global.user_id;

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: