eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_EXPENDITURE_ITEMS

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

666: P_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2 ,
667: P_projfunc_cost_rate_date IN OUT NOCOPY DATE,
668: P_projfunc_cost_exch_rate IN OUT NOCOPY NUMBER,
669: P_projfunc_raw_cost IN OUT NOCOPY NUMBER,
670: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE DEFAULT 'NER',
671: P_structure_version_id IN NUMBER DEFAULT NULL,
672: P_status OUT NOCOPY VARCHAR2,
673: P_stage OUT NOCOPY NUMBER,
674: P_Po_Line_ID IN NUMBER DEFAULT NULL) /* Bug : 3535935 */

Line 1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;

1302: * Variable Declarations
1303: */
1304:
1305: V_loop_index NUMBER := 1;
1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;
1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;

Line 1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;

1303: */
1304:
1305: V_loop_index NUMBER := 1;
1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;
1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;

Line 1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;

1304:
1305: V_loop_index NUMBER := 1;
1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;
1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;

Line 1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;

1305: V_loop_index NUMBER := 1;
1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;
1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;

Line 1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;

1306: V_acct_raw_cost PA_EXPENDITURE_ITEMS.ACCT_RAW_COST%TYPE;
1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;

Line 1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;

1307: V_acct_rate_date PA_EXPENDITURE_ITEMS.ACCT_RATE_DATE%TYPE;
1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;

Line 1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;

1308: V_acct_rate_type PA_EXPENDITURE_ITEMS.ACCT_RATE_TYPE%TYPE;
1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;

Line 1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;

1309: V_acct_exchange_rate PA_EXPENDITURE_ITEMS.ACCT_EXCHANGE_RATE%TYPE;
1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;

Line 1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;

1310: V_projfunc_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;
1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;

Line 1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;

1311: V_projfunc_cost_rate_date PA_EXPENDITURE_ITEMS.projfunc_cost_rate_DATE%TYPE;
1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;
1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;
1319: V_status VARCHAR2(150);

Line 1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;

1312: V_projfunc_cost_rate_type PA_EXPENDITURE_ITEMS.projfunc_cost_rate_TYPE%TYPE;
1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;
1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;
1319: V_status VARCHAR2(150);
1320: V_stage NUMBER;

Line 1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;

1313: V_projfunc_cost_exchange_rate PA_EXPENDITURE_ITEMS.projfunc_cost_exchANGE_RATE%TYPE;
1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;
1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;
1319: V_status VARCHAR2(150);
1320: V_stage NUMBER;
1321: V_denominator NUMBER;

Line 1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;

1314: V_project_raw_cost PA_EXPENDITURE_ITEMS.RAW_COST%TYPE;
1315: V_project_rate_date PA_EXPENDITURE_ITEMS.PROJECT_RATE_DATE%TYPE;
1316: V_project_rate_type PA_EXPENDITURE_ITEMS.PROJECT_RATE_TYPE%TYPE;
1317: V_project_exchange_rate PA_EXPENDITURE_ITEMS.PROJECT_EXCHANGE_RATE%TYPE;
1318: V_system_linkage PA_EXPENDITURE_ITEMS.SYSTEM_LINKAGE_FUNCTION%TYPE;
1319: V_status VARCHAR2(150);
1320: V_stage NUMBER;
1321: V_denominator NUMBER;
1322: V_numerator NUMBER;

Line 1426: FROM PA_Expenditure_Items ITEM,

1422: ** ITEM.Job_Id,
1423: ** ITEM.Cost_Job_Id,
1424: ** PA_Cross_Business_Grp.GetProjectGroupId(TASK.Project_Id, 'C') job_group_id
1425: **/
1426: FROM PA_Expenditure_Items ITEM,
1427: PA_Expenditures EXP,
1428: PA_Transaction_Sources TXN /* Bug 1824407 */
1429: /** To be uncommented after decing upon rates-model.
1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.

Line 1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.

1426: FROM PA_Expenditure_Items ITEM,
1427: PA_Expenditures EXP,
1428: PA_Transaction_Sources TXN /* Bug 1824407 */
1429: /** To be uncommented after decing upon rates-model.
1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1431: ** PA_Tasks TASK
1432: **/
1433: WHERE ITEM.Cost_Distributed_Flag = 'S'
1434: AND ITEM.Cost_Dist_Rejection_Code IS NULL

Line 1916: UPDATE Pa_Expenditure_Items ITEM

1912:
1913: FORALL LOOP_INDEX IN 1..V_loop_index
1914:
1915:
1916: UPDATE Pa_Expenditure_Items ITEM
1917: SET ITEM.Denom_Currency_Code =
1918: DECODE(ITEM.Denom_Currency_Code, NULL,
1919: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1920: PA_CC_IDENT.DenomCurrCodeTab(loop_index),

Line 2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,

2300: **/
2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,
2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',

Line 2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,
2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,

Line 2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,

2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,

Line 2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,

2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

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

2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,

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

2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,

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

2308: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,

Line 2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

2309: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

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

2310: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,

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

2311: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,

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

2312: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,

Line 2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

2313: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

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

2314: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2322: P_structure_version_id IN NUMBER DEFAULT NULL,

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

2315: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2322: P_structure_version_id IN NUMBER DEFAULT NULL,
2323: X_status OUT NOCOPY VARCHAR2,

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

2316: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2322: P_structure_version_id IN NUMBER DEFAULT NULL,
2323: X_status OUT NOCOPY VARCHAR2,
2324: X_stage OUT NOCOPY NUMBER)

Line 2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

2317: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2318: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2319: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2320: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2321: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2322: P_structure_version_id IN NUMBER DEFAULT NULL,
2323: X_status OUT NOCOPY VARCHAR2,
2324: X_stage OUT NOCOPY NUMBER)
2325: IS

Line 2354: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE

2350: --------------------------------------
2351: --Forward bodies
2352:
2353: ----------------------------------------------------------------------
2354: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE
2355: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2357: ,P_structure_version_id IN NUMBER DEFAULT NULL
2358: ,P_calling_module IN VARCHAR2

Line 2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2352:
2353: ----------------------------------------------------------------------
2354: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE
2355: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2357: ,P_structure_version_id IN NUMBER DEFAULT NULL
2358: ,P_calling_module IN VARCHAR2
2359: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2360: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE

Line 2359: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE

2355: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2357: ,P_structure_version_id IN NUMBER DEFAULT NULL
2358: ,P_calling_module IN VARCHAR2
2359: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2360: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2361: )
2362: is
2363:

Line 2360: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE

2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2357: ,P_structure_version_id IN NUMBER DEFAULT NULL
2358: ,P_calling_module IN VARCHAR2
2359: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2360: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2361: )
2362: is
2363:
2364: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;

Line 2364: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;

2360: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2361: )
2362: is
2363:
2364: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;
2365:
2366: begin
2367:
2368: --dbms_output.put_line('deriving project attributes');

Line 2407: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2403: end derive_project_attributes ;
2404:
2405: -----------------------------------------------------------------------
2406: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2407: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2408: ,P_attribute IN VARCHAR2
2409: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2410: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2411: )

Line 2409: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE

2405: -----------------------------------------------------------------------
2406: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2407: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2408: ,P_attribute IN VARCHAR2
2409: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2410: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2411: )
2412: is
2413: begin

Line 2410: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE

2406: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2407: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2408: ,P_attribute IN VARCHAR2
2409: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2410: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2411: )
2412: is
2413: begin
2414:

Line 2442: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2438:
2439: -----------------------------------------------------------------------
2440: procedure derive_projfunc_attributes
2441: ( P_calling_module IN VARCHAR2
2442: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2443: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE
2445: ,P_attribute IN VARCHAR2
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL

Line 2443: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE

2439: -----------------------------------------------------------------------
2440: procedure derive_projfunc_attributes
2441: ( P_calling_module IN VARCHAR2
2442: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2443: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE
2445: ,P_attribute IN VARCHAR2
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE

Line 2447: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE

2443: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE
2445: ,P_attribute IN VARCHAR2
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE
2448: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2449: )
2450: is
2451:

Line 2448: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE

2444: ,P_project_id IN pa_projects_all.project_id%TYPE
2445: ,P_attribute IN VARCHAR2
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE
2448: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2449: )
2450: is
2451:
2452: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;

Line 2452: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;

2448: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2449: )
2450: is
2451:
2452: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;
2453:
2454: begin
2455:
2456: --dbms_output.put_line('deriving projfunc attributes');