1 PACKAGE AS_FORECAST_ACTUAL_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtfas.pls 115.16 2003/01/13 22:10:56 geliu ship $ */
3 PROCEDURE Insert_Row(
4 p_SALESFORCE_ID in NUMBER,
5 p_SALES_GROUP_ID in NUMBER,
6 p_PERIOD_NAME in VARCHAR2,
7 p_CURRENCY_CODE in VARCHAR2,
8 p_ALLOCATED_BUDGET_AMOUNT in NUMBER,
9 p_ACTUAL_REVENUE_AMOUNT in NUMBER,
10 p_CREATED_BY in NUMBER,
11 p_CREATION_DATE in DATE,
12 p_LAST_UPDATED_BY in NUMBER,
13 p_LAST_UPDATE_DATE in DATE,
14 p_LAST_UPDATE_LOGIN in NUMBER,
15 p_REQUEST_ID in NUMBER,
16 p_PROGRAM_APPLICATION_ID in NUMBER,
17 p_PROGRAM_ID in NUMBER,
18 p_PROGRAM_UPDATE_DATE in DATE,
19 p_SECURITY_GROUP_ID in NUMBER,
20 p_forecast_category_id IN NUMBER,
21 p_credit_type_id IN NUMBER
22 );
23
24 PROCEDURE Update_Row(
25 p_FORECAST_ACTUAL_ID in NUMBER,
26 p_CURRENCY_CODE in VARCHAR2,
27 p_ALLOCATED_BUDGET_AMOUNT in NUMBER,
28 p_ACTUAL_REVENUE_AMOUNT in NUMBER,
29 p_LAST_UPDATED_BY in NUMBER,
30 p_LAST_UPDATE_DATE in DATE,
31 p_LAST_UPDATE_LOGIN in NUMBER,
32 p_REQUEST_ID in NUMBER,
33 p_PROGRAM_APPLICATION_ID in NUMBER,
34 p_PROGRAM_ID in NUMBER,
35 p_PROGRAM_UPDATE_DATE in DATE,
36 p_SECURITY_GROUP_ID in NUMBER
37 );
38
39 PROCEDURE Lock_Row(
40 p_FORECAST_ACTUAL_ID in NUMBER,
41 p_SALESFORCE_ID in NUMBER,
42 p_SALES_GROUP_ID in NUMBER,
43 p_PERIOD_NAME in VARCHAR2,
44 p_CURRENCY_CODE in VARCHAR2,
45 p_ALLOCATED_BUDGET_AMOUNT in NUMBER,
46 p_ACTUAL_REVENUE_AMOUNT in NUMBER,
47 p_CREATED_BY in NUMBER,
48 p_CREATION_DATE in DATE,
49 p_LAST_UPDATED_BY in NUMBER,
50 p_LAST_UPDATE_DATE in DATE,
51 p_LAST_UPDATE_LOGIN in NUMBER,
52 p_REQUEST_ID in NUMBER,
53 p_PROGRAM_APPLICATION_ID in NUMBER,
54 p_PROGRAM_ID in NUMBER,
55 p_PROGRAM_UPDATE_DATE in DATE,
56 p_SECURITY_GROUP_ID in NUMBER);
57
58 PROCEDURE Delete_Row(
59 p_FORECAST_ACTUAL_ID in NUMBER);
60
61 PROCEDURE Upload_Data(
62 p_period_set_name IN VARCHAR2,
63 p_line_number IN NUMBER,
64 p_SALESFORCE_NUMBER IN NUMBER,
65 p_SALES_GROUP_NUMBER IN NUMBER,
66 p_PERIOD_NAME IN VARCHAR2,
67 p_CURRENCY_CODE IN VARCHAR2,
68 p_ALLOCATED_BUDGET_AMOUNT IN NUMBER,
69 p_ACTUAL_REVENUE_AMOUNT IN NUMBER,
70 p_CREATED_BY IN NUMBER,
71 p_CREATION_DATE IN DATE,
72 p_LAST_UPDATED_BY IN NUMBER,
73 p_LAST_UPDATE_DATE IN DATE,
74 p_LAST_UPDATE_LOGIN IN NUMBER,
75 p_REQUEST_ID IN NUMBER,
76 p_PROGRAM_APPLICATION_ID IN NUMBER,
77 p_PROGRAM_ID IN NUMBER,
78 p_PROGRAM_UPDATE_DATE IN DATE,
79 p_SECURITY_GROUP_ID IN NUMBER,
80 p_filehandle IN UTL_FILE.FILE_TYPE,
81 p_forecast_category_name IN VARCHAR2,
82 p_credit_type_name IN VARCHAR2
83 );
84
85 FUNCTION Get_LogDir(p_data_file IN VARCHAR2) RETURN VARCHAR2;
86
87 FUNCTION Get_LogFileName(p_data_file IN VARCHAR2) RETURN VARCHAR2;
88
89 PROCEDURE Chk_Valid_PeriodName (
90 p_period_name IN VARCHAR2
91 , p_period_set_name IN VARCHAR2
92 , p_filehandle IN UTL_FILE.FILE_TYPE
93 , x_period_flag OUT NOCOPY BOOLEAN
94 , x_start_date OUT NOCOPY DATE
95 , x_end_date OUT NOCOPY DATE );
96
97 PROCEDURE Chk_Valid_Currency (
98 p_currency_code IN VARCHAR2
99 , p_filehandle IN UTL_FILE.FILE_TYPE
100 , x_currency_flag OUT NOCOPY BOOLEAN );
101
102 PROCEDURE Get_CreditTypeId (
103 p_name IN VARCHAR2
104 , p_filehandle IN UTL_FILE.FILE_TYPE
105 , x_credit_type_id OUT NOCOPY NUMBER ) ;
106
107 PROCEDURE Get_ForecastCategoryId (
108 p_name IN VARCHAR2
109 , p_filehandle IN UTL_FILE.FILE_TYPE
110 , p_start_date IN DATE
111 , p_end_date IN DATE
112 , x_forecast_category_id OUT NOCOPY NUMBER );
113
114 PROCEDURE Get_SalesGroupId (
115 p_sales_group_number IN NUMBER
116 , p_filehandle IN UTL_FILE.FILE_TYPE
117 , p_start_date IN DATE
118 , p_end_date IN DATE
119 , x_sales_group_id OUT NOCOPY NUMBER );
120
121 PROCEDURE Get_SalesForceId (
122 p_salesforce_number IN NUMBER
123 , p_filehandle IN UTL_FILE.FILE_TYPE
124 , p_start_date IN DATE
125 , p_end_date IN DATE
126 , p_sales_group_id IN NUMBER
127 , x_salesforce_id OUT NOCOPY NUMBER );
128
129 Procedure Read_Lob( p_file_id IN NUMBER
130 , p_CREATED_BY IN NUMBER
131 , p_LAST_UPDATED_BY IN NUMBER
132 , p_LAST_UPDATE_LOGIN IN NUMBER
133 , p_PROGRAM_APPLICATION_ID IN NUMBER);
134
135 PROCEDURE Delete_lob(p_file_id IN NUMBER
136 , p_filehandle IN UTL_FILE.FILE_TYPE) ;
137
138 PROCEDURE Create_Loglob( p_log_string IN VARCHAR2
139 ,p_file_id IN NUMBER
140 ,p_op_type IN VARCHAR2
141 ,p_exists IN BOOLEAN);
142
143 End AS_FORECAST_ACTUAL_PKG;