PACKAGE: APPS.BOM_DELETE_ENTITY

Source

1 PACKAGE bom_delete_entity AS
2 /* $Header: BOMDELMS.pls 120.1 2005/06/21 04:00:54 appldev ship $ */
3 /****************************************************************************
4 --
5 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      BOMDELMS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package BOMDELMS
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --  15-Sep-2000 Janaki B    Initial Creation
20 --
21 ****************************************************************************/
22 
23 FUNCTION Get_delorg_type(group_id in NUMBER)
24 RETURN NUMBER;
25 
26 FUNCTION Get_delete_type(group_id in NUMBER)
27 RETURN NUMBER;
28 
29 FUNCTION Get_delorg_hrchy(group_id in NUMBER)
30 RETURN VARCHAR2;
31 
32 FUNCTION Get_common_flag(group_id in NUMBER)
33 RETURN NUMBER;
34 
35 FUNCTION Get_delorg_id(group_id in NUMBER)
36 RETURN NUMBER;
37 
38 FUNCTION Get_delorg_name(org_id IN NUMBER)
39 RETURN varchar2;
40 
41 PROCEDURE get_delorg_list(org_type         in      number,
42                           org_hrchy        in      varchar2,
43                           current_org_id   in      number,
44                           current_org_name in      varchar2,
45                           org_list         in out nocopy /* file.sql.39 change */     inv_orghierarchy_pvt.orgid_tbl_type);
46 
47 FUNCTION Get_bill_seq(assembly_id    in NUMBER,
48                       org_id         in NUMBER,
49                       alternate_bom  in VARCHAR2)
50 RETURN NUMBER;
51 
52 FUNCTION Get_rtg_seq(assembly_id    in NUMBER,
53                      org_id         in NUMBER,
54                      alternate_desg in VARCHAR2
55                      )
56 RETURN NUMBER;
57 
58 FUNCTION Get_comp_seq(bill_seq     in NUMBER,
59                       component_id in NUMBER,
60                      oper_seq_num   in NUMBER,
61                      effective_date in DATE)
62 RETURN NUMBER;
63 
64 FUNCTION Get_oper_seq(rtg_seq       in NUMBER,
65                      oper_seq_num   in NUMBER,
66                      effective_date in DATE,
67                      dept_code      in VARCHAR2,
68                      org_id         in NUMBER)
69 RETURN NUMBER;
70 
71 FUNCTION Get_dept_code(
72                       dept_code       in VARCHAR2,
73                       org_id          in NUMBER)
74 RETURN VARCHAR2;
75 
76 
77 FUNCTION Get_item_descr(assembly_id    in NUMBER,
78                         org_id         in NUMBER)
79 RETURN VARCHAR2;
80 
81 FUNCTION Get_concat_segs(assembly_id    in NUMBER,
82                          org_id         in NUMBER)
83 RETURN VARCHAR2;
84 
85 FUNCTION get_item_id(assembly_id    in NUMBER,
86                      current_org    in NUMBER)
87 RETURN NUMBER;
88 
89 PROCEDURE process_delete_entities(delete_type     in    NUMBER,
90                                   group_id        in    NUMBER,
91                                   original_org    in    NUMBER,
92                                   org_list        in    inv_orghierarchy_pvt.orgid_tbl_type);
93 
94 PROCEDURE modify_original_bills( group_id          in   NUMBER,
95                                  common_flag       in   NUMBER);
96 
97 PROCEDURE process_original_sub_entities(
98                              delete_type     in    NUMBER,
99                              group_id        in    NUMBER,
100                              original_org    in    NUMBER,
101                              common_flag     in    NUMBER,
102                              org_list        in    inv_orghierarchy_pvt.orgid_tbl_type);
103 
104 PROCEDURE insert_common_bills(group_id      IN NUMBER,
105                               delete_type   IN NUMBER);
106 
107 PROCEDURE insert_original_bills(group_id      IN NUMBER,
108                                 delete_type   IN NUMBER);
109 
110 
111 END bom_delete_entity;