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 799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;

795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
801: l_sysdate DATE := SYSDATE;
802:
803: /* Tables for budget line Insert */

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

796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
801: l_sysdate DATE := SYSDATE;
802:
803: /* Tables for budget line Insert */
804: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

1836: l_msg_index_out NUMBER;
1837:
1838: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1839:
1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1841: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1842: l_sysdate DATE := SYSDATE;
1843: BEGIN
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1841: l_last_update_login NUMBER := FND_GLOBAL.login_id;

1837:
1838: l_fixed_date_id PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE;
1839:
1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1841: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1842: l_sysdate DATE := SYSDATE;
1843: BEGIN
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845: x_msg_count := 0;

Line 2046: := FND_GLOBAL.user_id;

2042: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2043:
2044: l_sysdate DATE;
2045: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2046: := FND_GLOBAL.user_id;
2047: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2048: := FND_GLOBAL.login_id;
2049:
2050: l_count NUMBER;

Line 2048: := FND_GLOBAL.login_id;

2044: l_sysdate DATE;
2045: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2046: := FND_GLOBAL.user_id;
2047: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2048: := FND_GLOBAL.login_id;
2049:
2050: l_count NUMBER;
2051: l_msg_count NUMBER;
2052: l_data VARCHAR2(1000);