DBA Data[Home] [Help]

APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on FND_GLOBAL

Line 545: l_fnd_user_id := fnd_global.user_id;

541: IF g_debug_flag THEN
542: Write_Debug('l_task_id is not null..');
543: END IF ;
544:
545: l_fnd_user_id := fnd_global.user_id;
546: IF g_debug_flag THEN
547: Write_Debug('l_fnd_user_id:'|| to_char(l_fnd_user_id));
548: END IF ;
549:

Line 598: l_fnd_login_id := fnd_global.login_id;

594: IF g_debug_flag THEN
595: Write_Debug('submitted for approval!');
596: END IF ;
597:
598: l_fnd_login_id := fnd_global.login_id;
599:
600: IF g_debug_flag THEN
601: Write_Debug('p_document_id:'||to_char(p_document_id));
602: Write_Debug('l_fnd_login_id:'||to_char(l_fnd_login_id));

Line 819: SELECT fnd_global.user_id, fnd_global.login_id

815:
816: -- Real code starts here -----------------------------------------------
817:
818: -- get values for fnd_user and fnd_login
819: SELECT fnd_global.user_id, fnd_global.login_id
820: INTO l_fnd_user_id, l_fnd_login_id
821: FROM dual;
822:
823: -- First check if there are floating versions in the CO to be implemented.

Line 1103: l_fnd_user_id := fnd_global.user_id; -- -1; -- Bug 3700111

1099: END IF ;
1100: -- Initialize API return status to success
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: -- Real code starts here -----------------------------------------------
1103: l_fnd_user_id := fnd_global.user_id; -- -1; -- Bug 3700111
1104: l_fnd_login_id := fnd_global.login_id; -- ''; -- Bug 3700111
1105: select userenv('LANG') into l_language from dual;
1106: select category_id, document_id into l_category_id, l_source_doc_id from fnd_attached_documents where attached_document_id = p_source_attachment_id;
1107: select datatype_id, security_type, dm_node, dm_folder_path, dm_type, dm_document_id, dm_version_number

Line 1104: l_fnd_login_id := fnd_global.login_id; -- ''; -- Bug 3700111

1100: -- Initialize API return status to success
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: -- Real code starts here -----------------------------------------------
1103: l_fnd_user_id := fnd_global.user_id; -- -1; -- Bug 3700111
1104: l_fnd_login_id := fnd_global.login_id; -- ''; -- Bug 3700111
1105: select userenv('LANG') into l_language from dual;
1106: select category_id, document_id into l_category_id, l_source_doc_id from fnd_attached_documents where attached_document_id = p_source_attachment_id;
1107: select datatype_id, security_type, dm_node, dm_folder_path, dm_type, dm_document_id, dm_version_number
1108: into l_datatype_id, l_security_type, l_dm_node, l_dm_folder_path, l_dm_type, l_dm_document_id, l_dm_version_number

Line 1504: x_created_by => fnd_global.user_id,

1500: x_to_pk3_value => p_new_rev_id,
1501: x_to_pk4_value => '',
1502: x_to_pk5_value => '',
1503: X_to_attachment_id => l_new_attachment_id,
1504: x_created_by => fnd_global.user_id,
1505: x_last_update_login => fnd_global.login_id,
1506: x_program_application_id => '',
1507: x_program_id => fnd_global.conc_program_id,
1508: x_request_id => fnd_global.conc_request_id

Line 1505: x_last_update_login => fnd_global.login_id,

1501: x_to_pk4_value => '',
1502: x_to_pk5_value => '',
1503: X_to_attachment_id => l_new_attachment_id,
1504: x_created_by => fnd_global.user_id,
1505: x_last_update_login => fnd_global.login_id,
1506: x_program_application_id => '',
1507: x_program_id => fnd_global.conc_program_id,
1508: x_request_id => fnd_global.conc_request_id
1509: );

Line 1507: x_program_id => fnd_global.conc_program_id,

1503: X_to_attachment_id => l_new_attachment_id,
1504: x_created_by => fnd_global.user_id,
1505: x_last_update_login => fnd_global.login_id,
1506: x_program_application_id => '',
1507: x_program_id => fnd_global.conc_program_id,
1508: x_request_id => fnd_global.conc_request_id
1509: );
1510: -- Step 4: Moving attachment changes (only Detach) from source revision to new revision
1511: update eng_attachment_changes

Line 1508: x_request_id => fnd_global.conc_request_id

1504: x_created_by => fnd_global.user_id,
1505: x_last_update_login => fnd_global.login_id,
1506: x_program_application_id => '',
1507: x_program_id => fnd_global.conc_program_id,
1508: x_request_id => fnd_global.conc_request_id
1509: );
1510: -- Step 4: Moving attachment changes (only Detach) from source revision to new revision
1511: update eng_attachment_changes
1512: set attachment_id = l_new_attachment_id