APPS.WSH_DOCUMENT_PVT dependencies on FND_GLOBAL

Line 1475: , fnd_global.user_id

1471: , null
1472: , l_entity_name
1473: , l_entity_id
1474: , l_doc_sequence_category_id
1475: , fnd_global.user_id
1476: , sysdate
1477: , fnd_global.user_id
1478: , sysdate
1479: , fnd_global.login_id

Line 1477: , fnd_global.user_id

1473: , l_entity_id
1474: , l_doc_sequence_category_id
1475: , fnd_global.user_id
1476: , sysdate
1477: , fnd_global.user_id
1478: , sysdate
1479: , fnd_global.login_id
1480: , null
1481: , null

Line 1479: , fnd_global.login_id

1475: , fnd_global.user_id
1476: , sysdate
1477: , fnd_global.user_id
1478: , sysdate
1479: , fnd_global.login_id
1480: , null
1481: , null
1482: , null
1483: , null

Line 1633: , fnd_global.user_id

1629: , null
1630: , p_entity_name
1631: , p_entity_id
1632: , l_doc_sequence_category_id
1633: , fnd_global.user_id
1634: , sysdate
1635: , fnd_global.user_id
1636: , sysdate
1637: , fnd_global.login_id

Line 1635: , fnd_global.user_id

1631: , p_entity_id
1632: , l_doc_sequence_category_id
1633: , fnd_global.user_id
1634: , sysdate
1635: , fnd_global.user_id
1636: , sysdate
1637: , fnd_global.login_id
1638: , null
1639: , null

Line 1637: , fnd_global.login_id

1633: , fnd_global.user_id
1634: , sysdate
1635: , fnd_global.user_id
1636: , sysdate
1637: , fnd_global.login_id
1638: , null
1639: , null
1640: , null
1641: , null

Line 2044: , last_updated_by = fnd_global.user_id

2040:
2041: UPDATE wsh_document_instances
2042: SET
2043: last_update_date = sysdate
2044: , last_updated_by = fnd_global.user_id
2045: , last_update_login = fnd_global.login_id
2046: WHERE CURRENT OF old_values_csr;
2047:
2048: END LOOP;

Line 2045: , last_update_login = fnd_global.login_id

2041: UPDATE wsh_document_instances
2042: SET
2043: last_update_date = sysdate
2044: , last_updated_by = fnd_global.user_id
2045: , last_update_login = fnd_global.login_id
2046: WHERE CURRENT OF old_values_csr;
2047:
2048: END LOOP;
2049: IF old_values_csr%ISOPEN

Line 2359: , last_updated_by = fnd_global.user_id

2355:
2356: UPDATE wsh_document_instances
2357: SET status = 'CANCELLED'
2358: , last_update_date = sysdate
2359: , last_updated_by = fnd_global.user_id
2360: , last_update_login = fnd_global.login_id
2361: WHERE CURRENT OF status_csr;
2362:
2363: END LOOP;

Line 2360: , last_update_login = fnd_global.login_id

2356: UPDATE wsh_document_instances
2357: SET status = 'CANCELLED'
2358: , last_update_date = sysdate
2359: , last_updated_by = fnd_global.user_id
2360: , last_update_login = fnd_global.login_id
2361: WHERE CURRENT OF status_csr;
2362:
2363: END LOOP;
2364: IF status_csr%ISOPEN

Line 2374: , last_updated_by = fnd_global.user_id

2370:
2371: UPDATE wsh_document_instances
2372: SET status = 'CANCELLED'
2373: , last_update_date = sysdate
2374: , last_updated_by = fnd_global.user_id
2375: , last_update_login = fnd_global.login_id
2376: WHERE entity_name = l_entity_name
2377: AND entity_id = p_entity_id
2378: AND document_type = p_document_type

Line 2375: , last_update_login = fnd_global.login_id

2371: UPDATE wsh_document_instances
2372: SET status = 'CANCELLED'
2373: , last_update_date = sysdate
2374: , last_updated_by = fnd_global.user_id
2375: , last_update_login = fnd_global.login_id
2376: WHERE entity_name = l_entity_name
2377: AND entity_id = p_entity_id
2378: AND document_type = p_document_type
2379: AND status in ('OPEN', 'PLANNED');

Line 2675: , last_updated_by = fnd_global.user_id

2671:
2672: UPDATE wsh_document_instances
2673: SET status = 'OPEN'
2674: , last_update_date = sysdate
2675: , last_updated_by = fnd_global.user_id
2676: , last_update_login = fnd_global.login_id
2677: WHERE CURRENT OF status_csr;
2678:
2679: END LOOP;

Line 2676: , last_update_login = fnd_global.login_id

2672: UPDATE wsh_document_instances
2673: SET status = 'OPEN'
2674: , last_update_date = sysdate
2675: , last_updated_by = fnd_global.user_id
2676: , last_update_login = fnd_global.login_id
2677: WHERE CURRENT OF status_csr;
2678:
2679: END LOOP;
2680: IF status_csr%ISOPEN

Line 2979: , last_updated_by = fnd_global.user_id

2975:
2976: UPDATE wsh_document_instances
2977: SET status = 'COMPLETE'
2978: , last_update_date = sysdate
2979: , last_updated_by = fnd_global.user_id
2980: , last_update_login = fnd_global.login_id
2981: WHERE CURRENT OF status_csr;
2982:
2983: END LOOP;

Line 2980: , last_update_login = fnd_global.login_id

2976: UPDATE wsh_document_instances
2977: SET status = 'COMPLETE'
2978: , last_update_date = sysdate
2979: , last_updated_by = fnd_global.user_id
2980: , last_update_login = fnd_global.login_id
2981: WHERE CURRENT OF status_csr;
2982:
2983: END LOOP;
2984: IF status_csr%ISOPEN

Line 3633: , last_updated_by = fnd_global.user_id

3629:
3630: UPDATE wsh_document_instances
3631: SET status = 'CANCELLED'
3632: , last_update_date = sysdate
3633: , last_updated_by = fnd_global.user_id
3634: , last_update_login = fnd_global.login_id
3635: WHERE entity_name = p_entity_name
3636: AND entity_id = p_entity_id;
3637:

Line 3634: , last_update_login = fnd_global.login_id

3630: UPDATE wsh_document_instances
3631: SET status = 'CANCELLED'
3632: , last_update_date = sysdate
3633: , last_updated_by = fnd_global.user_id
3634: , last_update_login = fnd_global.login_id
3635: WHERE entity_name = p_entity_name
3636: AND entity_id = p_entity_id;
3637:
3638: -- get message count and the message itself (if only one message)