DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 293: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE DEFAULT 'NER',

289: P_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2 ,
290: P_projfunc_cost_rate_date IN OUT NOCOPY DATE,
291: P_projfunc_cost_exch_rate IN OUT NOCOPY NUMBER,
292: P_projfunc_raw_cost IN OUT NOCOPY NUMBER,
293: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE DEFAULT 'NER',
294: P_structure_version_id IN NUMBER DEFAULT NULL,
295: P_status OUT NOCOPY VARCHAR2,
296: P_stage OUT NOCOPY NUMBER,
297: P_Po_Line_ID IN NUMBER DEFAULT NULL /* Bug : 3535935 */

Line 369: P_task_id IN pa_expenditure_items_all.task_id%TYPE,

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,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',

Line 370: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

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,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,

Line 372: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,

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,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,

Line 374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%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,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

Line 375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,

371: P_calling_module IN VARCHAR2,
372: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,

Line 376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,

372: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,

Line 377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,

373: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,

Line 378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

374: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

Line 379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,

375: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,

Line 380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,

376: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,

Line 381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,

377: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,

Line 382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

378: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

Line 383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,

379: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
387: P_structure_version_id IN NUMBER DEFAULT NULL,

Line 384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,

380: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
387: P_structure_version_id IN NUMBER DEFAULT NULL,
388: X_status OUT NOCOPY VARCHAR2,

Line 385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,

381: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
387: P_structure_version_id IN NUMBER DEFAULT NULL,
388: X_status OUT NOCOPY VARCHAR2,
389: X_stage OUT NOCOPY NUMBER) ;

Line 386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

382: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
383: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
384: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
385: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
386: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
387: P_structure_version_id IN NUMBER DEFAULT NULL,
388: X_status OUT NOCOPY VARCHAR2,
389: X_stage OUT NOCOPY NUMBER) ;
390: