[Home] [Help]
68: PROCEDURE PER_PL_VALIDATE_ORGNIP(p_org_information_id VARCHAR2,
69: p_org_information3 VARCHAR2
70: ) IS
71:
72: Cursor cur_nip is select org_information3 from hr_organization_information where org_information_context = 'PL_TAX_INFO'
73: and org_information_id <> nvl(p_org_information_id,0) and org_information3 = p_org_information3;
74: p_org_info hr_organization_information.org_information3%type;
75: nip_sum number;
76: TYPE v_nip is TABLE of number index by BINARY_INTEGER;
70: ) IS
71:
72: Cursor cur_nip is select org_information3 from hr_organization_information where org_information_context = 'PL_TAX_INFO'
73: and org_information_id <> nvl(p_org_information_id,0) and org_information3 = p_org_information3;
74: p_org_info hr_organization_information.org_information3%type;
75: nip_sum number;
76: TYPE v_nip is TABLE of number index by BINARY_INTEGER;
77: nip_number v_nip;
78: --
129: ORG_INFO_TYPE_CODE VARCHAR2) IS
130:
131: cursor csr_overlap_rec is
132: select 1
133: from hr_organization_information where
134: organization_id = ORG_ID and
135: org_information_context = ORG_INFO_TYPE_CODE and
136: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
137: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
200:
201:
202: cursor csr_overlap_upd_rec is
203: select 1
204: from hr_organization_information where
205: organization_id = p_org_id and
206: org_information_context = P_ORG_INFO_TYPE_CODE and
207: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
208: and nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
397: ,P_ORG_INFORMATION_ID NUMBER
398: ) IS
399:
400: cursor csr_org_id is
401: select organization_id from hr_organization_information where
402: org_information_id = P_ORG_INFORMATION_ID;
403:
404: p_org_id hr_organization_units.organization_id%TYPE;
405: