APPS.WSH_DOCUMENT_PVT dependencies on FND_GLOBAL

Line 1474: , fnd_global.user_id

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

Line 1476: , fnd_global.user_id

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

Line 1478: , fnd_global.login_id

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

Line 1632: , fnd_global.user_id

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

Line 1634: , fnd_global.user_id

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

Line 1636: , fnd_global.login_id

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

Line 2043: , last_updated_by = fnd_global.user_id

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

Line 2044: , last_update_login = fnd_global.login_id

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

Line 2358: , last_updated_by = fnd_global.user_id

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

Line 2359: , last_update_login = fnd_global.login_id

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

Line 2373: , last_updated_by = fnd_global.user_id

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

Line 2374: , last_update_login = fnd_global.login_id

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

Line 2674: , last_updated_by = fnd_global.user_id

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

Line 2675: , last_update_login = fnd_global.login_id

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

Line 2978: , last_updated_by = fnd_global.user_id

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

Line 2979: , last_update_login = fnd_global.login_id

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

Line 3632: , last_updated_by = fnd_global.user_id

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

Line 3633: , last_update_login = fnd_global.login_id

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