[Home] [Help]
PACKAGE: APPS.FA_RX_REPORTS_PKG
Source
1 PACKAGE FA_RX_REPORTS_PKG as
2 /* $Header: faxrxdms.pls 120.5 2006/05/30 12:08:41 rravunny ship $ */
3
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Report_Id NUMBER default null,
6 X_Application_Id NUMBER default null,
7 X_Responsibility_Id NUMBER default null,
8 X_Concurrent_Program_Id NUMBER default null,
9 X_Concurrent_Program_Name VARCHAR2 default null,
10 X_Interface_Table VARCHAR2 default null,
11 X_Concurrent_Program_Flag VARCHAR2 default null,
12 X_Select_Program_Name VARCHAR2 default null,
13 X_Last_Update_Date DATE default null,
14 X_Last_Updated_By NUMBER default null,
15 X_Created_By NUMBER default NULL,
16 X_Creation_Date DATE default NULL,
17 X_Last_Update_Login NUMBER default NULL,
18 X_Where_Clause_API VARCHAR2 default null,
19 X_Purge_API VARCHAR2 default null,
20 X_Calling_Fn VARCHAR2
21 );
22
23
24 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_Report_Id NUMBER default null,
26 X_Application_Id NUMBER default null,
27 X_Responsibility_Id NUMBER default null,
28 X_Concurrent_Program_Id NUMBER default null,
29 X_Concurrent_Program_Flag VARCHAR2 default null,
30 X_Select_Program_Name VARCHAR2 default null,
31 X_Interface_Table VARCHAR2 default null,
32 X_Where_Clause_API VARCHAR2 default null,
33 X_Purge_API VARCHAR2 default null,
34 X_Calling_Fn VARCHAR2
35 );
36
37 PROCEDURE Update_Row(X_Rowid VARCHAR2,
38 X_Report_Id NUMBER default null,
39 X_Application_Id NUMBER default null,
40 X_Responsibility_Id NUMBER default null,
41 X_Concurrent_Program_Id NUMBER default null,
42 X_Concurrent_Program_Name VARCHAR2 default null,
43 X_Interface_Table VARCHAR2 default null,
44 X_Concurrent_Program_Flag VARCHAR2 default null,
45 X_Select_Program_Name VARCHAR2 default null,
46 X_Last_Update_Date DATE default null,
47 X_Last_Updated_By NUMBER default null,
48 X_Last_Update_Login NUMBER default null,
49 X_Where_Clause_API VARCHAR2 default null,
50 X_Purge_API VARCHAR2 default null,
51 X_Calling_Fn VARCHAR2
52 );
53
54 PROCEDURE Delete_Row(X_Rowid VARCHAR2 default null,
55 X_Report_Id NUMBER,
56 X_Calling_Fn VARCHAR2
57 );
58
59 --* overloaded procedure
60 --*
61 PROCEDURE Load_Row(
62 X_Report_Id NUMBER default null,
63 X_Application_Name VARCHAR2 default null,
64 X_Responsibility_Id NUMBER default null,
65 X_Concurrent_Program_Name VARCHAR2 default null,
66 X_Concurrent_Program_Flag VARCHAR2 default null,
67 X_Select_Program_Name VARCHAR2 default null,
68 X_Interface_Table VARCHAR2 default null,
69 X_Where_Clause_API VARCHAR2 default null,
70 X_Purge_API VARCHAR2 default null,
71 X_Owner VARCHAR2 default 'SEED',
72 X_Last_Update_Date VARCHAR2,
73 X_CUSTOM_MODE in VARCHAR2
74 );
75
76 PROCEDURE Load_Row(
77 X_Report_Id NUMBER default null,
78 X_Application_Name VARCHAR2 default null,
79 X_Responsibility_Id NUMBER default null,
80 X_Concurrent_Program_Name VARCHAR2 default null,
81 X_Concurrent_Program_Flag VARCHAR2 default null,
82 X_Select_Program_Name VARCHAR2 default null,
83 X_Interface_Table VARCHAR2 default null,
84 X_Where_Clause_API VARCHAR2 default null,
85 X_Purge_API VARCHAR2 default null,
86 X_Owner VARCHAR2 default 'SEED'
87 );
88
89 FUNCTION validate_plsql_block(p_plsql VARCHAR2) return BOOLEAN ;
90
91 END FA_RX_REPORTS_PKG;