DBA Data[Home] [Help]

APPS.HR_OFFER_CUSTOM dependencies on DUAL

Line 877: select userenv('LANG') into l_language from dual;

873:
874: Begin
875: --
876: -- Get language
877: select userenv('LANG') into l_language from dual;
878: --
879: -- Get seq num
880: --
881: l_seq_num := 0;

Line 899: from sys.dual;

895: --
896: -- get sequence id for attached_document_id
897: select fnd_attached_documents_s.nextval
898: into l_attached_document_id
899: from sys.dual;
900:
901: -- Insert document to fnd_documents_long_text
902: --
903: fnd_attached_documents_pkg.insert_row

Line 1020: select userenv('LANG') into l_language from dual;

1016: --
1017: Begin
1018: --
1019: -- Get language
1020: select userenv('LANG') into l_language from dual;
1021: --
1022: -- Get the before update nullable fields which are not used by the
1023: -- Web page to ensure the values are propagated.
1024: Open csr_get_attached_doc;

Line 1267: select userenv('LANG') into l_language from dual;

1263:
1264: Begin
1265: --
1266: -- Get language
1267: select userenv('LANG') into l_language from dual;
1268: --
1269: -- -------------------------------------------------------------------------
1270: -- Retrieving a resume requires 4 steps:
1271: -- 1) Get Category ID.