APPS.IRC_IDO_BUS dependencies on IRC_DOCUMENTS

Line 154: (p_person_id in irc_documents.person_id%type

150: --
151: -- Access Status:
152: -- Internal Table Handler Use Only.
153: Procedure chk_person_id
154: (p_person_id in irc_documents.person_id%type
155: ,p_party_id in out nocopy irc_documents.party_id%type
156: ,p_effective_date date) is
157: --
158: l_proc varchar2(72) := g_package || 'chk_person_id';

Line 155: ,p_party_id in out nocopy irc_documents.party_id%type

151: -- Access Status:
152: -- Internal Table Handler Use Only.
153: Procedure chk_person_id
154: (p_person_id in irc_documents.person_id%type
155: ,p_party_id in out nocopy irc_documents.party_id%type
156: ,p_effective_date date) is
157: --
158: l_proc varchar2(72) := g_package || 'chk_person_id';
159: l_party_id irc_documents.party_id%type;

Line 159: l_party_id irc_documents.party_id%type;

155: ,p_party_id in out nocopy irc_documents.party_id%type
156: ,p_effective_date date) is
157: --
158: l_proc varchar2(72) := g_package || 'chk_person_id';
159: l_party_id irc_documents.party_id%type;
160: l_var varchar2(30);
161: --
162: --
163: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F.

Line 226: (p_person_id in irc_documents.person_id%type

222: --
223: -- Access Status:
224: -- Internal Table Handler Use Only.
225: Procedure chk_monthly_doc_upload_count
226: (p_person_id in irc_documents.person_id%type
227: ,p_effective_date date) is
228: --
229: l_proc varchar2(72) := g_package || 'chk_monthly_doc_upload_count';
230: l_count number;

Line 238: from irc_documents doc

234: -- Cursor to check that document upload count not exceeded in last month
235: --
236: cursor csr_doc_upload_count is
237: select count(*)
238: from irc_documents doc
239: where doc.person_id = p_person_id
240: and doc.end_date is null
241: and months_between(p_effective_date,doc.creation_date) <= 1;
242: Begin

Line 289: (p_person_id in irc_documents.person_id%type ) is

285: --
286: -- Access Status:
287: -- Internal Table Handler Use Only.
288: Procedure chk_total_doc_upload_count
289: (p_person_id in irc_documents.person_id%type ) is
290: --
291: l_proc varchar2(72) := g_package || 'chk_total_doc_upload_count';
292: l_count number;
293: l_max_count number;

Line 300: from irc_documents doc

296: -- Cursor to check that document upload count not exceeded in last month
297: --
298: cursor csr_doc_upload_count is
299: select count(*)
300: from irc_documents doc
301: where doc.person_id = p_person_id
302: and doc.end_date is null;
303: Begin
304: --

Line 337: -- document_id number(15) PK of IRC_DOCUMENTS

333: -- None.
334: --
335: -- In Parameters:
336: -- type varchar2(30) document type
337: -- document_id number(15) PK of IRC_DOCUMENTS
338: -- object_version_number number(9) version of row
339: -- effective_date date date record effective
340: --
341: -- Post Success: