APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on FND_PROFILE

Line 62: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;

58:
59: IF g_output_dir IS NULL
60: THEN
61:
62: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;
63:
64: END IF;
65:
66: select value

Line 158: l_fnd_user_id :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

154: BEGIN
155: -- Initialize API return status to success
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: l_fnd_user_id :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
159: l_fnd_login_id :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
160:
161: OPEN C;
162: LOOP

Line 159: l_fnd_login_id :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

155: -- Initialize API return status to success
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: l_fnd_user_id :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
159: l_fnd_login_id :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
160:
161: OPEN C;
162: LOOP
163: FETCH C INTO l_attachment_id, l_prev_status,

Line 224: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

220: l_source_media_id NUMBER;
221: l_file_name VARCHAR2(2048);
222: l_datatype_id NUMBER;
223: l_created_by NUMBER;
224: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
225: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
226: l_doc_id NUMBER;
227:
228: cursor C IS

Line 225: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

221: l_file_name VARCHAR2(2048);
222: l_datatype_id NUMBER;
223: l_created_by NUMBER;
224: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
225: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
226: l_doc_id NUMBER;
227:
228: cursor C IS
229: select attachment_id, previous_status, source_document_id, repository_id,

Line 285: -- FND_PROFILE package is not available for workflow (WF),

281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282:
283:
284: -- Real code starts here -----------------------------------
285: -- FND_PROFILE package is not available for workflow (WF),
286: -- therefore manually set WHO column values
287:
288: -- insert into swarb values(1, to_char(p_change_id), p_workflow_status);
289: -- commit;

Line 291: -- FND_PROFILE package is not available for workflow (WF),

287:
288: -- insert into swarb values(1, to_char(p_change_id), p_workflow_status);
289: -- commit;
290:
291: -- FND_PROFILE package is not available for workflow (WF),
292: -- therefore manually set WHO column values
293:
294: IF p_api_caller = 'WF' THEN
295: l_fnd_user_id := G_ENG_WF_USER_ID;

Line 1058: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1054: l_security_type number := 1;
1055: l_security_id number;
1056: l_publish_flag varchar2(1) := 'Y';
1057: l_usage_type varchar2(1) := 'O';
1058: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1059: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1060: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachment';
1061: l_api_version CONSTANT NUMBER := 1.0;
1062: l_return_status VARCHAR2(1);

Line 1059: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1055: l_security_id number;
1056: l_publish_flag varchar2(1) := 'Y';
1057: l_usage_type varchar2(1) := 'O';
1058: l_fnd_user_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1059: l_fnd_login_id NUMBER :=TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1060: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachment';
1061: l_api_version CONSTANT NUMBER := 1.0;
1062: l_return_status VARCHAR2(1);
1063: l_msg_count NUMBER;

Line 1323: -- FND_PROFILE package is not available for workflow (WF),

1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320:
1321:
1322: -- Real code starts here -----------------------------------
1323: -- FND_PROFILE package is not available for workflow (WF),
1324: -- therefore manually set WHO column values
1325:
1326: l_fnd_user_id := -1;
1327: l_fnd_login_id := '';