PACKAGE: APPS.IGS_PE_INCOME_TAX_PKG

Source

1 PACKAGE igs_pe_income_tax_pkg AS
2 /* $Header: IGSNI53S.pls 120.0 2005/06/02 00:19:03 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_TAX_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_TAX_INFO IN VARCHAR2,
8        x_TYPE_CODE IN VARCHAR2,
9        x_TYPE_CODE_ID IN NUMBER DEFAULT NULL,
10        x_START_DATE IN DATE,
11        x_END_DATE IN DATE,
12        X_ORG_ID in NUMBER,
13       X_MODE in VARCHAR2 default 'R'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_TAX_ID IN NUMBER,
19        x_PERSON_ID IN NUMBER,
20        x_TAX_INFO IN VARCHAR2,
21        x_TYPE_CODE IN VARCHAR2,
22        x_TYPE_CODE_ID IN NUMBER DEFAULT NULL,
23        x_START_DATE IN DATE,
24        x_END_DATE IN DATE);
25  procedure UPDATE_ROW (
26       X_ROWID in  VARCHAR2,
27        x_TAX_ID IN NUMBER,
28        x_PERSON_ID IN NUMBER,
29        x_TAX_INFO IN VARCHAR2,
30        x_TYPE_CODE IN VARCHAR2,
31        x_TYPE_CODE_ID IN NUMBER DEFAULT NULL,
32        x_START_DATE IN DATE,
33        x_END_DATE IN DATE,
34       X_MODE in VARCHAR2 default 'R'
35   );
36 
37  procedure ADD_ROW (
38       X_ROWID in out NOCOPY VARCHAR2,
39        x_TAX_ID IN OUT NOCOPY NUMBER,
40        x_PERSON_ID IN NUMBER,
41        x_TAX_INFO IN VARCHAR2,
42        x_TYPE_CODE IN VARCHAR2,
43        x_TYPE_CODE_ID IN NUMBER DEFAULT NULL,
44        x_START_DATE IN DATE,
45        x_END_DATE IN DATE,
46        X_ORG_ID in NUMBER,
47       X_MODE in VARCHAR2 default 'R'
48   ) ;
49 
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2,
52   x_mode IN VARCHAR2 DEFAULT 'R'
53 ) ;
54   FUNCTION Get_PK_For_Validation (
55     x_tax_id IN NUMBER
56     ) RETURN BOOLEAN ;
57 
58   PROCEDURE Get_FK_Igs_Pe_Person (
59     x_person_id IN NUMBER
60     );
61 
62   PROCEDURE Check_Constraints (
63 		 Column_Name IN VARCHAR2  DEFAULT NULL,
64 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
65   PROCEDURE Before_DML (
66     p_action IN VARCHAR2,
67     x_rowid IN VARCHAR2 DEFAULT NULL,
68     x_tax_id IN NUMBER DEFAULT NULL,
69     x_person_id IN NUMBER DEFAULT NULL,
70     x_tax_info IN VARCHAR2 DEFAULT NULL,
71     x_type_code IN VARCHAR2 DEFAULT NULL,
72     x_type_code_id IN NUMBER DEFAULT NULL,
73     x_start_date IN DATE DEFAULT NULL,
74     x_end_date IN DATE DEFAULT NULL,
75     X_ORG_ID in NUMBER DEFAULT NULL,
76     x_creation_date IN DATE DEFAULT NULL,
77     x_created_by IN NUMBER DEFAULT NULL,
78     x_last_update_date IN DATE DEFAULT NULL,
79     x_last_updated_by IN NUMBER DEFAULT NULL,
80     x_last_update_login IN NUMBER DEFAULT NULL
81  );
82 
83 
84 END igs_pe_income_tax_pkg;