PACKAGE: APPS.IGS_AD_INTERFACE_CTL_PKG

Source

1 PACKAGE igs_ad_interface_ctl_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIA8S.pls 115.11 2003/12/09 12:44:51 pbondugu ship $ */
3   procedure INSERT_ROW (
4     X_ROWID in out NOCOPY VARCHAR2,
5     x_INTERFACE_RUN_ID IN OUT NOCOPY NUMBER,
6     x_SOURCE_TYPE_ID IN NUMBER,
7     x_BATCH_ID IN NUMBER,
8     x_MATCH_SET_ID IN NUMBER,
9     x_STATUS IN VARCHAR2,
10     X_MODE in VARCHAR2 default 'R'
11  );
12 
13   procedure LOCK_ROW (
14     X_ROWID in  VARCHAR2,
15     x_INTERFACE_RUN_ID IN NUMBER,
16     x_SOURCE_TYPE_ID IN NUMBER,
17     x_BATCH_ID IN NUMBER,
18     x_MATCH_SET_ID IN NUMBER,
19     x_STATUS IN VARCHAR2
20    );
21 
22  procedure UPDATE_ROW (
23     X_ROWID in  VARCHAR2,
24     x_INTERFACE_RUN_ID IN NUMBER,
25     x_SOURCE_TYPE_ID IN NUMBER,
26     x_BATCH_ID IN NUMBER,
27     x_MATCH_SET_ID IN NUMBER,
28     x_STATUS IN VARCHAR2,
29     X_MODE in VARCHAR2 default 'R'
30   );
31 
32  procedure ADD_ROW (
33     X_ROWID in out NOCOPY VARCHAR2,
34     x_INTERFACE_RUN_ID IN OUT NOCOPY NUMBER,
35     x_SOURCE_TYPE_ID IN NUMBER,
36     x_BATCH_ID IN NUMBER,
37     x_MATCH_SET_ID IN NUMBER,
38     x_STATUS IN VARCHAR2,
39     X_MODE in VARCHAR2 default 'R'
40   ) ;
41 
42   procedure DELETE_ROW (
43     X_ROWID in VARCHAR2
44   ) ;
45 
46   FUNCTION Get_PK_For_Validation (
47     x_interface_run_id IN NUMBER
48   ) RETURN BOOLEAN ;
49 
50 
51   PROCEDURE Get_FK_Igs_Pe_Src_Types (
52     x_source_type_id IN NUMBER
53   );
54 
55 
56   PROCEDURE Get_FK_Igs_Pe_Match_Sets (
57     x_match_set_id IN NUMBER
58   );
59 
60 
61   PROCEDURE Check_Constraints (
62 	  Column_Name IN VARCHAR2  DEFAULT NULL,
63 	  Column_Value IN VARCHAR2  DEFAULT NULL
64   ) ;
65 
66   PROCEDURE Before_DML (
67     p_action IN VARCHAR2,
68     x_rowid IN VARCHAR2 DEFAULT NULL,
69     x_interface_run_id IN NUMBER DEFAULT NULL,
70     x_source_type_id IN NUMBER DEFAULT NULL,
71     x_batch_id IN NUMBER DEFAULT NULL,
72     x_match_set_id IN NUMBER DEFAULT NULL,
73     x_status IN VARCHAR2 DEFAULT NULL,
74     x_creation_date IN DATE DEFAULT NULL,
75     x_created_by IN NUMBER DEFAULT NULL,
76     x_last_update_date IN DATE DEFAULT NULL,
77     x_last_updated_by IN NUMBER DEFAULT NULL,
78     x_last_update_login IN NUMBER DEFAULT NULL
79  );
80 
81 END igs_ad_interface_ctl_pkg;