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 1433: FROM PA_Expenditure_Items ITEM,

1429: ** ITEM.Job_Id,
1430: ** ITEM.Cost_Job_Id,
1431: ** PA_Cross_Business_Grp.GetProjectGroupId(TASK.Project_Id, 'C') job_group_id
1432: **/
1433: FROM PA_Expenditure_Items ITEM,
1434: PA_Expenditures EXP,
1435: PA_Transaction_Sources TXN /* Bug 1824407 */
1436: /** To be uncommented after decing upon rates-model.
1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.

Line 1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.

1433: FROM PA_Expenditure_Items ITEM,
1434: PA_Expenditures EXP,
1435: PA_Transaction_Sources TXN /* Bug 1824407 */
1436: /** To be uncommented after decing upon rates-model.
1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1438: ** PA_Tasks TASK
1439: **/
1440: WHERE ITEM.Cost_Distributed_Flag = 'S'
1441: AND ITEM.Cost_Dist_Rejection_Code IS NULL

Line 1928: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2

1924: ei1.Recvr_Org_Id
1925: into l_parent_cdf_tab(loop_index),l_parent_CCharge_Type(loop_index),
1926: l_parent_Cc_Prvdr_Org_Id(loop_index),l_parent_Cc_Recvr_Org_Id(loop_index),
1927: l_parent_Recvr_Org_Id(loop_index) from
1928: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
1929: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
1930: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index);
1931: EXCEPTION
1932: WHEN NO_DATA_FOUND THEN

Line 1949: UPDATE Pa_Expenditure_Items ITEM

1945:
1946: FORALL LOOP_INDEX IN 1..V_loop_index
1947:
1948:
1949: UPDATE Pa_Expenditure_Items ITEM
1950: SET ITEM.Denom_Currency_Code =
1951: DECODE(ITEM.Denom_Currency_Code, NULL,
1952: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1953: PA_CC_IDENT.DenomCurrCodeTab(loop_index),

Line 2141: from pa_expenditure_items_all ei1,pa_expenditure_items_all ei2

2137: ei1.Recvr_Org_Id
2138: into l_parent_cdf_tab(loop_index),l_parent_CCharge_Type(loop_index),
2139: l_parent_Cc_Prvdr_Org_Id(loop_index),l_parent_Cc_Recvr_Org_Id(loop_index),
2140: l_parent_Recvr_Org_Id(loop_index)
2141: from pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
2142: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
2143: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)
2144: AND ei1.Request_id = P_request_id;
2145: EXCEPTION

Line 2166: UPDATE Pa_Expenditure_Items ITEM

2162:
2163: END LOOP;
2164:
2165: FORALL LOOP_INDEX IN 1..V_loop_index
2166: UPDATE Pa_Expenditure_Items ITEM
2167: SET ITEM.Cc_Cross_Charge_Type =
2168: DECODE(l_parent_cdf_tab(loop_index),'S',l_parent_CCharge_Type(loop_index), ITEM.Cc_Cross_Charge_Type),
2169: ITEM.Cc_Prvdr_Organization_Id =
2170: DECODE(l_parent_cdf_tab(loop_index),'S',l_parent_Cc_Prvdr_Org_Id(loop_index), ITEM.Cc_Prvdr_Organization_Id),

Line 2393: P_task_id IN pa_expenditure_items_all.task_id%TYPE,

2389: **/
2390: PROCEDURE get_currency_attributes
2391: (P_project_id IN pa_projects_all.project_id%type default NULL,
2392: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2393: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2394: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2395: P_calling_module IN VARCHAR2,
2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',

Line 2394: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

2390: PROCEDURE get_currency_attributes
2391: (P_project_id IN pa_projects_all.project_id%type default NULL,
2392: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2393: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2394: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2395: P_calling_module IN VARCHAR2,
2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,

Line 2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,

2392: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2393: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2394: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2395: P_calling_module IN VARCHAR2,
2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,

Line 2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,

2394: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2395: P_calling_module IN VARCHAR2,
2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

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

2395: P_calling_module IN VARCHAR2,
2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,

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

2396: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,
2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,

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

2397: P_accounted_flag IN VARCHAR2 DEFAULT 'N',
2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,

Line 2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,

2398: P_acct_curr_code IN pa_expenditure_items_all.acct_currency_code%TYPE,
2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

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

2399: X_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE,
2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,

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

2400: X_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE,
2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,

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

2401: X_acct_exch_rate IN OUT NOCOPY pa_expenditure_items_all.acct_exchange_rate%TYPE,
2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,

Line 2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,

2402: P_project_curr_code IN pa_expenditure_items_all.project_currency_code%TYPE,
2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

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

2403: X_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE,
2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2411: P_structure_version_id IN NUMBER DEFAULT NULL,

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

2404: X_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE ,
2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2411: P_structure_version_id IN NUMBER DEFAULT NULL,
2412: X_status OUT NOCOPY VARCHAR2,

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

2405: X_project_exch_rate IN OUT NOCOPY pa_expenditure_items_all.project_exchange_rate%TYPE,
2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2411: P_structure_version_id IN NUMBER DEFAULT NULL,
2412: X_status OUT NOCOPY VARCHAR2,
2413: X_stage OUT NOCOPY NUMBER)

Line 2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,

2406: P_projfunc_curr_code IN pa_expenditure_items_all.projfunc_currency_code%TYPE,
2407: X_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE,
2408: X_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE ,
2409: X_projfunc_cost_exch_rate IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE,
2410: P_system_linkage IN pa_expenditure_items_all.system_linkage_function%TYPE,
2411: P_structure_version_id IN NUMBER DEFAULT NULL,
2412: X_status OUT NOCOPY VARCHAR2,
2413: X_stage OUT NOCOPY NUMBER)
2414: IS

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

2439: --------------------------------------
2440: --Forward bodies
2441:
2442: ----------------------------------------------------------------------
2443: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2445: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,P_calling_module IN VARCHAR2

Line 2445: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2441:
2442: ----------------------------------------------------------------------
2443: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2445: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,P_calling_module IN VARCHAR2
2448: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2449: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE

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

2444: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2445: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,P_calling_module IN VARCHAR2
2448: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2449: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2450: )
2451: is
2452:

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

2445: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,P_calling_module IN VARCHAR2
2448: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE
2449: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2450: )
2451: is
2452:
2453: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;

Line 2453: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;

2449: ,x_project_rate_date IN OUT NOCOPY pa_expenditure_items_all.project_rate_date%TYPE
2450: )
2451: is
2452:
2453: l_char_dummy pa_expenditure_items_all.project_currency_code%TYPE;
2454:
2455: begin
2456:
2457: --dbms_output.put_line('deriving project attributes');

Line 2496: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2492: end derive_project_attributes ;
2493:
2494: -----------------------------------------------------------------------
2495: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2496: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2497: ,P_attribute IN VARCHAR2
2498: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2499: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2500: )

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

2494: -----------------------------------------------------------------------
2495: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2496: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2497: ,P_attribute IN VARCHAR2
2498: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2499: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2500: )
2501: is
2502: begin

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

2495: procedure derive_acct_attributes( P_calling_module IN VARCHAR2
2496: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2497: ,P_attribute IN VARCHAR2
2498: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
2499: ,x_acct_rate_date IN OUT NOCOPY pa_expenditure_items_all.acct_rate_date%TYPE
2500: )
2501: is
2502: begin
2503:

Line 2531: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

2527:
2528: -----------------------------------------------------------------------
2529: procedure derive_projfunc_attributes
2530: ( P_calling_module IN VARCHAR2
2531: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2532: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2533: ,P_project_id IN pa_projects_all.project_id%TYPE
2534: ,P_attribute IN VARCHAR2
2535: ,P_structure_version_id IN NUMBER DEFAULT NULL

Line 2532: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE

2528: -----------------------------------------------------------------------
2529: procedure derive_projfunc_attributes
2530: ( P_calling_module IN VARCHAR2
2531: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2532: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2533: ,P_project_id IN pa_projects_all.project_id%TYPE
2534: ,P_attribute IN VARCHAR2
2535: ,P_structure_version_id IN NUMBER DEFAULT NULL
2536: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE

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

2532: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2533: ,P_project_id IN pa_projects_all.project_id%TYPE
2534: ,P_attribute IN VARCHAR2
2535: ,P_structure_version_id IN NUMBER DEFAULT NULL
2536: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE
2537: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2538: )
2539: is
2540:

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

2533: ,P_project_id IN pa_projects_all.project_id%TYPE
2534: ,P_attribute IN VARCHAR2
2535: ,P_structure_version_id IN NUMBER DEFAULT NULL
2536: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE
2537: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2538: )
2539: is
2540:
2541: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;

Line 2541: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;

2537: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE
2538: )
2539: is
2540:
2541: l_char_dummy pa_expenditure_items_all.projfunc_currency_code%TYPE;
2542:
2543: begin
2544:
2545: --dbms_output.put_line('deriving projfunc attributes');