DBA Data[Home] [Help]

APPS.BOM_DELETE_ENTITY dependencies on INV_ORGHIERARCHY_PVT

Line 121: org_list in out nocopy /* file.sql.39 change */ inv_orghierarchy_pvt.orgid_tbl_type)

117: PROCEDURE get_delorg_list(org_type in number,
118: org_hrchy in varchar2,
119: current_org_id in number,
120: current_org_name in varchar2,
121: org_list in out nocopy /* file.sql.39 change */ inv_orghierarchy_pvt.orgid_tbl_type)
122: IS
123: CURSOR orgs is
124: SELECT MP.organization_id
125: FROM MTL_PARAMETERS MP

Line 145: inv_orghierarchy_pvt.org_hierarchy_list(org_hrchy,

141: If (org_type = 1) then
142: l_index := l_index+1;
143: org_list(l_index) := current_org_id;
144: elsif (org_type = 2) then
145: inv_orghierarchy_pvt.org_hierarchy_list(org_hrchy,
146: current_org_id,
147: org_list);
148: elsif (org_type = 3) then
149: FOR c_orgs in orgs LOOP

Line 310: org_list in inv_orghierarchy_pvt.orgid_tbl_type)

306:
307: PROCEDURE process_delete_entities(delete_type in NUMBER,
308: group_id in NUMBER,
309: original_org in NUMBER,
310: org_list in inv_orghierarchy_pvt.orgid_tbl_type)
311: IS
312: l_index number := 0;
313: current_org number;
314: temp varchar2(1);

Line 491: org_list in inv_orghierarchy_pvt.orgid_tbl_type)

487: delete_type in NUMBER,
488: group_id in NUMBER,
489: original_org in NUMBER,
490: common_flag in NUMBER,
491: org_list in inv_orghierarchy_pvt.orgid_tbl_type)
492: IS
493: l_index number := 0;
494: current_org number;
495: temp varchar2(1);

Line 1008: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;

1004: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;
1005: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;
1006: current_org_id bom_delete_groups.organization_id%type;
1007: current_org_name org_access_view.organization_name%type;
1008: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;
1009: BEGIN
1010: delete_org_type := get_delorg_type(group_id);
1011: delete_org_hrchy := get_delorg_hrchy(group_id);
1012: delete_common_flag := get_common_flag(group_id);

Line 1049: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;

1045: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;
1046: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;
1047: current_org_id bom_delete_groups.organization_id%type;
1048: current_org_name org_access_view.organization_name%type;
1049: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;
1050:
1051: BEGIN
1052: delete_org_type := get_delorg_type(group_id);
1053: delete_org_hrchy := get_delorg_hrchy(group_id);