DBA Data[Home] [Help]

APPS.PA_FP_GEN_PUB dependencies on FND_GLOBAL

Line 17: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

13: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
14:
15: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS';
16:
17: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
18: l_last_update_login NUMBER := FND_GLOBAL.login_id;
19: l_sysdate DATE := SYSDATE;
20: l_ret_status VARCHAR2(100);
21: l_msg_count NUMBER;

Line 18: l_last_update_login NUMBER := FND_GLOBAL.login_id;

14:
15: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS';
16:
17: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
18: l_last_update_login NUMBER := FND_GLOBAL.login_id;
19: l_sysdate DATE := SYSDATE;
20: l_ret_status VARCHAR2(100);
21: l_msg_count NUMBER;
22: l_msg_data VARCHAR2(2000);

Line 812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;

808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */

Line 813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;

809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1853: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

1849: l_msg_index_out NUMBER;
1850:
1851: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1852:
1853: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1854: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1855: l_sysdate DATE := SYSDATE;
1856: BEGIN
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1854: l_last_update_login NUMBER := FND_GLOBAL.login_id;

1850:
1851: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1852:
1853: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1854: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1855: l_sysdate DATE := SYSDATE;
1856: BEGIN
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858: x_msg_count := 0;

Line 2059: := FND_GLOBAL.user_id;

2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2056:
2057: l_sysdate DATE;
2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2059: := FND_GLOBAL.user_id;
2060: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2061: := FND_GLOBAL.login_id;
2062:
2063: l_count NUMBER;

Line 2061: := FND_GLOBAL.login_id;

2057: l_sysdate DATE;
2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2059: := FND_GLOBAL.user_id;
2060: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2061: := FND_GLOBAL.login_id;
2062:
2063: l_count NUMBER;
2064: l_msg_count NUMBER;
2065: l_data VARCHAR2(1000);