APPS.PA_ORG_UTILS dependencies on PA_NUM_TBL_TYPE

Line 3044: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3040: SELECT org_id FROM pa_implementations_all
3041: WHERE org_structure_version_id = l_version_id
3042: and start_organization_id = l_start_org_id;
3043:
3044: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3045: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3046: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3047:
3048: l_tmp_org_id pa_implementations_all.org_id%type;

Line 3045: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3041: WHERE org_structure_version_id = l_version_id
3042: and start_organization_id = l_start_org_id;
3043:
3044: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3045: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3046: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3047:
3048: l_tmp_org_id pa_implementations_all.org_id%type;
3049: l_plsql_max_array_size CONSTANT NUMBER := 1000;

Line 3046: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

3042: and start_organization_id = l_start_org_id;
3043:
3044: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3045: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3046: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3047:
3048: l_tmp_org_id pa_implementations_all.org_id%type;
3049: l_plsql_max_array_size CONSTANT NUMBER := 1000;
3050: -- End for bug#5952671