APPS.EDR_ATTACHMENTS_GRP dependencies on DUAL

Line 820: --individual category name

816: --obtain the name of the categories being passed from the call
817: l_category_names := l_category;
818:
819: --parse the string of semicolon separated category names and get the
820: --individual category name
821: l_category_name := edr_utilities.get_delimited_string(l_category_names,';');
822:
823: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Category PArsed');
824: loop

Line 1307: from dual;

1303: l_document_id := p_document_id;
1304: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','The FND Document id is '||l_document_id);
1305:
1306: select fnd_attached_documents_s.nextval into l_atc_doc_id
1307: from dual;
1308:
1309: l_user_id := fnd_global.user_id;
1310: l_login_id := fnd_global.login_id;
1311:

Line 1312: select userenv('lang') into l_language from dual;

1308:
1309: l_user_id := fnd_global.user_id;
1310: l_login_id := fnd_global.login_id;
1311:
1312: select userenv('lang') into l_language from dual;
1313:
1314: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row
1315: (X_Rowid => l_rowid,
1316: X_attached_document_id => l_atc_doc_id,

Line 1377: --Parse the string and identify the individual attachment strings contained.

1373: l_temp_count := 0;
1374:
1375: l_identified_position := instr(l_attachment_string,'~',1,1);
1376:
1377: --Parse the string and identify the individual attachment strings contained.
1378: while l_identified_position > 0 loop
1379: l_temp_count := l_temp_count + 1;
1380: l_attachment_string_list.extend;
1381: l_attachment_string_list(l_temp_count) := substr(l_attachment_string,1,l_identified_position-1);