APPS.HR_OFFER_CUSTOM dependencies on FND_ATTACHED_DOCUMENTS_S

Line 854: l_seq_num fnd_attached_documents.seq_num%type;

850: l_category_id fnd_document_categories.category_id%TYPE
851: default null;
852: l_datatype_id fnd_document_datatypes.datatype_id%TYPE default 2;
853: l_language varchar2(30) default 'AMERICAN';
854: l_seq_num fnd_attached_documents.seq_num%type;
855:
856:
857: cursor csr_get_seq_num is
858: select nvl(max(seq_num),0) + 10

Line 897: select fnd_attached_documents_s.nextval

893: end if;
894: close csr_get_category_id;
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

Line 1208: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type) is

1204: ,p_document_id out nocopy fnd_documents.document_id%TYPE
1205: ,p_media_id out nocopy fnd_documents_tl.media_id%TYPE
1206: ,p_rowid out nocopy varchar2
1207: ,p_category_id out nocopy fnd_documents.category_id%type
1208: ,p_seq_num out nocopy fnd_attached_documents.seq_num%type) is
1209:
1210: -- [CUSTOMIZE]
1211: -- Call fnd_attached_documents, fnd_documents_tl and
1212: -- fnd_documents_long_text tables. If customer uses third party

Line 1223: l_seq_num fnd_attached_documents.seq_num%type default null;

1219: l_attachment_text clob default null; -- Bug#13362792
1220: l_rowid varchar2(50) default null;
1221: l_category_id fnd_documents.category_id%type default null;
1222: l_language varchar2(30) default 'AMERICAN';
1223: l_seq_num fnd_attached_documents.seq_num%type default null;
1224: l_update_date date default null;
1225:
1226: cursor csr_get_category_id (csr_p_lang in varchar2) is
1227: select category_id