PACKAGE: APPS.IGS_GE_S_HELP_CTRL_PKG

Source

1 package IGS_GE_S_HELP_CTRL_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSMI09S.pls 115.3 2002/11/29 01:11:27 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_S_CONTROL_NUM in out NOCOPY NUMBER,
7   X_BASE_URL in VARCHAR2,
8   X_OWS_ENABLED_IND in VARCHAR2,
9   X_TOC_URL in VARCHAR2,
10   X_INDEX_URL in VARCHAR2,
11   X_LINK1_BUTTON_LABEL in VARCHAR2,
12   X_LINK1_BASE_URL in VARCHAR2,
13   X_LINK2_BUTTON_LABEL in VARCHAR2,
14   X_LINK2_BASE_URL in VARCHAR2,
15   X_LINK3_BUTTON_LABEL in VARCHAR2,
16   X_LINK3_BASE_URL in VARCHAR2,
17   X_MODE in VARCHAR2 default 'R'
18   );
19 procedure LOCK_ROW (
20   X_ROWID in VARCHAR2,
21   X_S_CONTROL_NUM in NUMBER,
22   X_BASE_URL in VARCHAR2,
23   X_OWS_ENABLED_IND in VARCHAR2,
24   X_TOC_URL in VARCHAR2,
25   X_INDEX_URL in VARCHAR2,
26   X_LINK1_BUTTON_LABEL in VARCHAR2,
27   X_LINK1_BASE_URL in VARCHAR2,
28   X_LINK2_BUTTON_LABEL in VARCHAR2,
29   X_LINK2_BASE_URL in VARCHAR2,
30   X_LINK3_BUTTON_LABEL in VARCHAR2,
31   X_LINK3_BASE_URL in VARCHAR2
32 );
33 procedure UPDATE_ROW (
34   X_ROWID in VARCHAR2,
35   X_S_CONTROL_NUM in NUMBER,
36   X_BASE_URL in VARCHAR2,
37   X_OWS_ENABLED_IND in VARCHAR2,
38   X_TOC_URL in VARCHAR2,
39   X_INDEX_URL in VARCHAR2,
40   X_LINK1_BUTTON_LABEL in VARCHAR2,
41   X_LINK1_BASE_URL in VARCHAR2,
42   X_LINK2_BUTTON_LABEL in VARCHAR2,
43   X_LINK2_BASE_URL in VARCHAR2,
44   X_LINK3_BUTTON_LABEL in VARCHAR2,
45   X_LINK3_BASE_URL in VARCHAR2,
46   X_MODE in VARCHAR2 default 'R'
47   );
48 procedure ADD_ROW (
49   X_ROWID in out NOCOPY VARCHAR2,
50   X_S_CONTROL_NUM in out NOCOPY NUMBER,
51   X_BASE_URL in VARCHAR2,
52   X_OWS_ENABLED_IND in VARCHAR2,
53   X_TOC_URL in VARCHAR2,
54   X_INDEX_URL in VARCHAR2,
55   X_LINK1_BUTTON_LABEL in VARCHAR2,
56   X_LINK1_BASE_URL in VARCHAR2,
57   X_LINK2_BUTTON_LABEL in VARCHAR2,
58   X_LINK2_BASE_URL in VARCHAR2,
59   X_LINK3_BUTTON_LABEL in VARCHAR2,
60   X_LINK3_BASE_URL in VARCHAR2,
61   X_MODE in VARCHAR2 default 'R'
62   );
63 procedure DELETE_ROW (
64   X_ROWID in VARCHAR2
65 );
66 FUNCTION GET_PK_FOR_VALIDATION (
67    x_s_control_num IN NUMBER
68 )RETURN BOOLEAN ;
69  PROCEDURE Check_Constraints(
70   Column_Name IN VARCHAR2 DEFAULT NULL,
71   Column_Value IN VARCHAR2 DEFAULT NULL
72  );
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_s_control_num IN NUMBER DEFAULT NULL,
77     x_base_url IN VARCHAR2 DEFAULT NULL,
78     x_toc_url IN VARCHAR2 DEFAULT NULL,
79     x_index_url IN VARCHAR2 DEFAULT NULL,
80     x_link1_button_label IN VARCHAR2 DEFAULT NULL,
81     x_link1_base_url IN VARCHAR2 DEFAULT NULL,
82     x_link2_button_label IN VARCHAR2 DEFAULT NULL,
83     x_link2_base_url IN VARCHAR2 DEFAULT NULL,
84     x_link3_button_label IN VARCHAR2 DEFAULT NULL,
85     x_link3_base_url IN VARCHAR2 DEFAULT NULL,
86     x_ows_enabled_ind IN VARCHAR2 DEFAULT NULL,
87     x_creation_date IN DATE DEFAULT NULL,
88     x_created_by IN NUMBER DEFAULT NULL,
89     x_last_update_date IN DATE DEFAULT NULL,
90     x_last_updated_by IN NUMBER DEFAULT NULL,
91     x_last_update_login IN NUMBER DEFAULT NULL
92   ) ;
93 
94 
95 end IGS_GE_S_HELP_CTRL_PKG;