1 PACKAGE MODAL_DELETE as
2 /*$Header: BOMMDELS.pls 120.1 2005/06/21 05:24:29 appldev ship $*/
3
4 /* This function sends an error message to the Forms message line when
5 an error occurs. This function is called by Forms only */
6
7 FUNCTION DELETE_MANAGER(
8 new_group_seq_id IN NUMBER,
9 name IN VARCHAR2,
10 group_desc IN VARCHAR2,
11 org_id IN NUMBER,
12 bom_or_eng IN NUMBER,
13 del_type IN NUMBER,
14 ent_bill_seq_id IN NUMBER,
15 ent_rtg_seq_id IN NUMBER,
16 ent_inv_item_id IN NUMBER,
17 ent_alt_designator IN VARCHAR2,
18 ent_comp_seq_id IN NUMBER,
19 ent_op_seq_id IN NUMBER,
20 user_id IN NUMBER
21 ) RETURN NUMBER;
22
23 /* This function returns an error message and an error code which is
24 used by the Open Interface program to flag errors. This function is
25 called by the Open Inteface program only */
26
27 FUNCTION DELETE_MANAGER_OI(
28 new_group_seq_id IN NUMBER,
29 name IN VARCHAR2,
30 group_desc IN VARCHAR2,
31 org_id IN NUMBER,
32 bom_or_eng IN NUMBER,
33 del_type IN NUMBER,
34 ent_bill_seq_id IN NUMBER,
35 ent_rtg_seq_id IN NUMBER,
36 ent_inv_item_id IN NUMBER,
37 ent_alt_designator IN VARCHAR2,
38 ent_comp_seq_id IN NUMBER,
39 ent_op_seq_id IN NUMBER,
40 user_id IN NUMBER,
41 err_text IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ) RETURN NUMBER;
43 /*
44 The %type declaration shown before is preffered but causes problems while the library
45 that calls this package compiles ) Once we support this functionality, we should
46 change this back
47
48 FUNCTION DELETE_MANAGER(
49 new_group_seq_id IN BOM_DELETE_GROUPS.DELETE_GROUP_SEQUENCE_ID%TYPE,
50 name IN BOM_DELETE_GROUPS.DELETE_GROUP_NAME%TYPE,
51 group_desc IN BOM_DELETE_GROUPS.DESCRIPTION%TYPE,
52 org_id IN BOM_DELETE_GROUPS.ORGANIZATION_ID%TYPE,
53 bom_or_eng IN BOM_DELETE_GROUPS.ENGINEERING_FLAG%TYPE,
54 del_type IN BOM_DELETE_GROUPS.DELETE_TYPE%TYPE,
55 ent_bill_seq_id IN BOM_DELETE_ENTITIES.BILL_SEQUENCE_ID%TYPE,
56 ent_rtg_seq_id IN BOM_DELETE_ENTITIES.ROUTING_SEQUENCE_ID%TYPE,
57 ent_inv_item_id IN BOM_DELETE_ENTITIES.INVENTORY_ITEM_ID%TYPE,
58 ent_alt_designator IN BOM_DELETE_ENTITIES.ALTERNATE_DESIGNATOR%TYPE,
59 ent_comp_seq_id IN BOM_DELETE_SUB_ENTITIES.COMPONENT_SEQUENCE_ID%TYPE,
60 ent_op_seq_id IN BOM_DELETE_SUB_ENTITIES.OPERATION_SEQUENCE_ID%TYPE,
61 user_id IN BOM_DELETE_GROUPS.LAST_UPDATED_BY%TYPE
62 ) RETURN NUMBER;
63 */
64 END MODAL_DELETE;