eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DELETE_ENTITY dependencies on BOM_DELETE_GROUPS

Line 13: -- and Sub Entities Data into Bom_delete_groups and Bom_delete_sub

9: -- BOMDELMB.pls
10: --
11: -- DESCRIPTION
12: -- This package contains Procedures used to insert delete groups
13: -- and Sub Entities Data into Bom_delete_groups and Bom_delete_sub
14: -- entities Tables Respectively.
15: --
16: -- PARAMETERS
17: -- Group Id Delete Group Sequence Id

Line 32: FROM bom_delete_groups

28: RETURN NUMBER
29: IS
30: CURSOR delorg_type is
31: select delete_org_type
32: FROM bom_delete_groups
33: where delete_group_sequence_id = group_id;
34: BEGIN
35: FOR c_delorg_type IN delorg_type LOOP
36: RETURN c_delorg_type.delete_org_type;

Line 46: FROM bom_delete_groups

42: RETURN NUMBER
43: IS
44: CURSOR del_type is
45: select delete_type
46: FROM bom_delete_groups
47: where delete_group_sequence_id = group_id;
48: BEGIN
49: FOR c_del_type IN del_type LOOP
50: RETURN c_del_type.delete_type;

Line 61: FROM bom_delete_groups

57: RETURN VARCHAR2
58: IS
59: CURSOR delorg_hrchy is
60: select organization_hierarchy
61: FROM bom_delete_groups
62: where delete_group_sequence_id = group_id;
63: BEGIN
64: FOR c_delorg_hrchy IN delorg_hrchy LOOP
65: RETURN c_delorg_hrchy.organization_hierarchy;

Line 75: FROM bom_delete_groups

71: RETURN NUMBER
72: IS
73: CURSOR common_flag is
74: select delete_common_bill_flag
75: FROM bom_delete_groups
76: where delete_group_sequence_id = group_id;
77: BEGIN
78: FOR c_common_flag IN common_flag LOOP
79: RETURN c_common_flag.delete_common_bill_flag;

Line 89: FROM bom_delete_groups

85: RETURN NUMBER
86: IS
87: CURSOR orgid is
88: select organization_id
89: FROM bom_delete_groups
90: where delete_group_sequence_id = group_id;
91: BEGIN
92: FOR c_orgid IN orgid LOOP
93: RETURN c_orgid.organization_id;

Line 1003: delete_org_type bom_delete_groups.delete_org_type%type;

999:
1000: PROCEDURE insert_common_bills(group_id IN NUMBER,
1001: delete_type IN NUMBER)
1002: IS
1003: delete_org_type bom_delete_groups.delete_org_type%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;

Line 1004: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;

1000: PROCEDURE insert_common_bills(group_id IN NUMBER,
1001: delete_type IN NUMBER)
1002: IS
1003: delete_org_type bom_delete_groups.delete_org_type%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;

Line 1005: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;

1001: delete_type IN NUMBER)
1002: IS
1003: delete_org_type bom_delete_groups.delete_org_type%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

Line 1006: current_org_id bom_delete_groups.organization_id%type;

1002: IS
1003: delete_org_type bom_delete_groups.delete_org_type%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);

Line 1044: delete_org_type bom_delete_groups.delete_org_type%type;

1040: ---------------------------------------------------------------------------*/
1041: PROCEDURE insert_original_bills(group_id IN NUMBER,
1042: delete_type IN NUMBER)
1043: IS
1044: delete_org_type bom_delete_groups.delete_org_type%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;

Line 1045: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;

1041: PROCEDURE insert_original_bills(group_id IN NUMBER,
1042: delete_type IN NUMBER)
1043: IS
1044: delete_org_type bom_delete_groups.delete_org_type%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;

Line 1046: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;

1042: delete_type IN NUMBER)
1043: IS
1044: delete_org_type bom_delete_groups.delete_org_type%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:

Line 1047: current_org_id bom_delete_groups.organization_id%type;

1043: IS
1044: delete_org_type bom_delete_groups.delete_org_type%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