[Home] [Help]
31: START WITH pose.organization_id_parent = nvl(c_business_group_id, l_parent_id)
32: AND pose.org_structure_version_id = p_org_structure_version_id
33: UNION
34: SELECT nvl(p_business_group_id, l_parent_id)
35: FROM DUAL)
36: AND p_org_structure_version_id IS NOT NULL
37: UNION
38: SELECT org.organization_id
39: ,org.name
97: IF p_date IS NOT NULL THEN
98: BEGIN
99: SELECT fnd_date.canonical_to_date(p_date)
100: INTO l_date
101: FROM DUAL;
102: EXCEPTION
103: WHEN OTHERS THEN
104: l_date := TRUNC(sysdate);
105: END;
409: START WITH pose.organization_id_parent = nvl(c_business_group_id, l_parent_id)
410: AND pose.org_structure_version_id = p_org_structure_version_id
411: UNION
412: SELECT nvl(c_business_group_id, l_parent_id)
413: FROM DUAL)
414: AND p_org_structure_version_id IS NOT NULL
415: UNION
416: SELECT org.organization_id
417: ,org.name
475: IF p_date IS NOT NULL THEN
476: BEGIN
477: SELECT fnd_date.canonical_to_date(p_date)
478: INTO l_date
479: FROM DUAL;
480: EXCEPTION
481: WHEN OTHERS THEN
482: l_date := TRUNC(sysdate);
483: END;
834: START WITH pose.organization_id_parent = nvl(p_org_id, l_parent_id)
835: AND pose.org_structure_version_id = p_org_structure_version_id
836: UNION
837: SELECT nvl(p_org_id, l_parent_id)
838: FROM DUAL)
839: AND p_org_structure_version_id IS NOT NULL
840: UNION
841: SELECT org.organization_id
842: ,org.name
898: IF p_date IS NOT NULL THEN
899: BEGIN
900: SELECT fnd_date.canonical_to_date(p_date)
901: INTO l_date
902: FROM DUAL;
903: EXCEPTION
904: WHEN OTHERS THEN
905: l_date := TRUNC(sysdate);
906: END;
1242: l_raw_buffer_len pls_integer;
1243: l_blob_offset pls_integer := 1;
1244: begin
1245: hr_utility.set_location('Entered Procedure clob to blob',120);
1246: select userenv('LANGUAGE') into g_nls_db_char from dual;
1247: l_length_clob := dbms_lob.getlength(p_clob);
1248: l_offset := 1;
1249: while l_length_clob > 0 loop
1250: hr_utility.trace('l_length_clob '|| l_length_clob);