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 1681: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;

1677: -- to here. kabalakr.
1678: l_header_id := FND_API.G_MISS_NUM;
1679:
1680: -- populate Header WHO columns
1681: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1682: l_trohdr_rec.creation_date := sysdate;
1683: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1684: l_trohdr_rec.last_update_date := sysdate;
1685: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;

Line 1683: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;

1679:
1680: -- populate Header WHO columns
1681: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1682: l_trohdr_rec.creation_date := sysdate;
1683: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1684: l_trohdr_rec.last_update_date := sysdate;
1685: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1686:
1687: l_trohdr_rec.from_subinventory_code := p_from_subinventory;

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

1681: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1682: l_trohdr_rec.creation_date := sysdate;
1683: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1684: l_trohdr_rec.last_update_date := sysdate;
1685: l_trohdr_rec.last_update_login := FND_GLOBAL.USER_ID;
1686:
1687: l_trohdr_rec.from_subinventory_code := p_from_subinventory;
1688: l_trohdr_rec.to_subinventory_code := p_to_subinventory;
1689:

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

1699: l_line_num := l_line_num + 1;
1700:
1701: -- populate Lines WHO columns.
1702:
1703: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1704: l_trolin_tbl(l_order_count).creation_date := sysdate;
1705: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1706: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1707: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1705: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;

1701: -- populate Lines WHO columns.
1702:
1703: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1704: l_trolin_tbl(l_order_count).creation_date := sysdate;
1705: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1706: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1707: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1708:
1709: l_trolin_tbl(l_order_count).date_required := p_date_required;

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

1703: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
1704: l_trolin_tbl(l_order_count).creation_date := sysdate;
1705: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
1706: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1707: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1708:
1709: l_trolin_tbl(l_order_count).date_required := p_date_required;
1710: l_trolin_tbl(l_order_count).status_date := sysdate;
1711:

Line 2282: l_update_by NUMBER := fnd_global.user_id;

2278: l_entity_type VARCHAR2(30);
2279: l_interface_id NUMBER;
2280: l_lot_control_code NUMBER;
2281: l_serial_control_code NUMBER;
2282: l_update_by NUMBER := fnd_global.user_id;
2283:
2284: CURSOR wip_cur IS
2285: SELECT wip_entity_id, entity_type
2286: FROM wip_entities

Line 3329: l_update_by NUMBER := fnd_global.user_id;

3325:
3326: PRAGMA AUTONOMOUS_TRANSACTION;
3327:
3328: l_request_id NUMBER;
3329: l_update_by NUMBER := fnd_global.user_id;
3330: l_update_name VARCHAR2(100);
3331:
3332: l_header_id NUMBER;
3333:

Line 3514: l_update_by NUMBER := fnd_global.user_id;

3510:
3511: PRAGMA AUTONOMOUS_TRANSACTION;
3512:
3513: l_request_id NUMBER;
3514: l_update_by NUMBER := fnd_global.user_id;
3515: l_update_name VARCHAR2(100);
3516:
3517: l_header_id NUMBER;
3518: