DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_PROJECTS_ALL

Line 41: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,

37: * pragma RESTRICT_REFERENCES(get_project_rate_type,WNDS,WNPS);
38: */
39: PROCEDURE get_projfunc_cost_rate_type (
40: P_task_id IN NUMBER ,
41: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
42: P_calling_module IN VARCHAR2 DEFAULT 'GET_CURR_AMOUNTS',
43: p_structure_version_id IN NUMBER DEFAULT NULL,
44: P_projfunc_currency_code IN OUT NOCOPY VARCHAR2 ,
45: P_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2 ) ;

Line 129: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

125: * pragma RESTRICT_REFERENCES(get_project_rate_date,WNDS);
126: */
127: PROCEDURE get_projfunc_cost_rate_date (
128: P_task_id IN NUMBER ,
129: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,
130: P_EI_date IN DATE ,
131: P_structure_version_id IN NUMBER DEFAULT NULL,
132: P_calling_module IN VARCHAR2 DEFAULT 'GET_CURR_AMOUNTS' ,
133: P_projfunc_cost_rate_date IN OUT NOCOPY DATE );

Line 166: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

162: * pragma RESTRICT_REFERENCES(get_default_project_rate_date, WNDS, WNPS);
163: */
164: PROCEDURE get_def_projfunc_cst_rate_date (
165: P_task_id IN NUMBER ,
166: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,
167: P_EI_date IN DATE ,
168: p_structure_version_id IN NUMBER DEFAULT NULL,
169: P_calling_module IN VARCHAR2 DEFAULT 'GET_CURR_AMOUNTS' ,
170: P_projfunc_cost_rate_date IN OUT NOCOPY DATE );

Line 332: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,

328: --
329: /*----------------------------------------------------------------------------*/
330:
331: PROCEDURE get_proj_rate_type ( P_task_id IN NUMBER ,
332: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
333: P_structure_version_id IN NUMBER DEFAULT NULL,
334: P_calling_module IN VARCHAR2 DEFAULT 'GET_CURR_AMOUNTS',
335: P_project_currency_code IN OUT NOCOPY VARCHAR2 ,
336: P_project_rate_type IN OUT NOCOPY VARCHAR2 ) ;

Line 355: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

351: -- P_project_rate_date VARCHAR2
352: /*----------------------------------------------------------------------------*/
353:
354: PROCEDURE get_proj_rate_date ( P_task_id IN NUMBER ,
355: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,
356: P_EI_date IN DATE ,
357: p_structure_version_id IN NUMBER DEFAULT NULL,
358: P_calling_module IN VARCHAR2 DEFAULT 'GET_CURR_AMOUNTS' ,
359: P_project_rate_date IN OUT NOCOPY DATE );

Line 367: P_project_id IN pa_projects_all.project_id%type default NULL,

363: /** Added new params p_project_id, p_exp_org_id to call this api from FORECAST modules
364: * when p_calling_module = 'FORECAST' p_task_id will be null and p_ei_date = FI date
365: **/
366: PROCEDURE get_currency_attributes (
367: P_project_id IN pa_projects_all.project_id%type default NULL,
368: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
369: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
370: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
371: P_calling_module IN VARCHAR2,

Line 368: P_exp_org_id IN pa_projects_all.org_id%type default NULL,

364: * when p_calling_module = 'FORECAST' p_task_id will be null and p_ei_date = FI date
365: **/
366: PROCEDURE get_currency_attributes (
367: P_project_id IN pa_projects_all.project_id%type default NULL,
368: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
369: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
370: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
371: P_calling_module IN VARCHAR2,
372: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,