PACKAGE: APPS.IGR_I_PKG_ITEM_PKG

Source

1 PACKAGE  IGR_I_PKG_ITEM_PKG as
2 /* $Header: IGSRH03S.pls 120.0 2005/06/01 22:44:49 appldev noship $ */
3 PROCEDURE insert_row (
4   x_rowid IN OUT NOCOPY VARCHAR2,
5   x_package_item_id IN NUMBER DEFAULT NULL,
6   x_publish_ss_ind  IN VARCHAR2 DEFAULT NULL,
7   x_mode IN VARCHAR2 default 'R'
8   ) ;
9 PROCEDURE lock_row (
10 x_rowid IN VARCHAR2,
11 x_package_item_id IN NUMBER DEFAULT NULL,
12 x_publish_ss_ind  IN VARCHAR2 DEFAULT NULL
13  );
14 PROCEDURE update_row (
15 x_rowid IN VARCHAR2,
16 x_package_item_id IN NUMBER DEFAULT NULL,
17 x_publish_ss_ind  IN VARCHAR2 DEFAULT NULL,
18 x_mode IN VARCHAR2 DEFAULT 'R'
19 );
20 PROCEDURE add_row (
21 x_rowid IN OUT NOCOPY VARCHAR2,
22 x_package_item_id IN NUMBER DEFAULT NULL,
23 x_publish_ss_ind  IN VARCHAR2 DEFAULT NULL,
24 x_mode IN VARCHAR2 DEFAULT 'R'
25  );
26 PROCEDURE delete_row (
27 x_rowid IN VARCHAR2
28 );
29 --
30   FUNCTION get_pk_for_validation (
31     x_package_item_id IN NUMBER DEFAULT NULL
32     ) RETURN BOOLEAN;
33 --
34   PROCEDURE get_fk_ams_deliverable_all_b (
35     x_package_item_id IN NUMBER DEFAULT NULL
36     );
37 --
38 
39 PROCEDURE before_dml (
40     p_action IN VARCHAR2,
41     x_rowid IN VARCHAR2 DEFAULT NULL,
42     x_package_item_id IN NUMBER DEFAULT NULL,
43     x_publish_ss_ind in VARCHAR2 DEFAULT NULL ,
44     x_creation_date IN DATE DEFAULT NULL,
45     x_created_by IN NUMBER DEFAULT NULL,
46     x_last_update_date IN DATE DEFAULT NULL,
47     x_last_updated_by IN NUMBER DEFAULT NULL,
48     x_last_update_login IN NUMBER DEFAULT NULL
49   );
50 PROCEDURE check_constraints (
51  	Column_Name	IN	VARCHAR2	DEFAULT NULL,
52  	Column_Value 	IN	VARCHAR2	DEFAULT NULL
53  );
54 --
55 end IGR_I_PKG_ITEM_PKG;