APPS.AS_FORECAST_ACTUAL_PKG dependencies on UTL_FILE

Line 80: p_filehandle IN UTL_FILE.FILE_TYPE,

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:

Line 92: , p_filehandle IN UTL_FILE.FILE_TYPE

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:

Line 99: , p_filehandle IN UTL_FILE.FILE_TYPE

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

Line 104: , 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

Line 109: , 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:

Line 116: , p_filehandle IN UTL_FILE.FILE_TYPE

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:

Line 123: , p_filehandle IN UTL_FILE.FILE_TYPE

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 );

Line 136: , p_filehandle IN UTL_FILE.FILE_TYPE) ;

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