DBA Data[Home] [Help]

APPS.PA_RBS_ASGMT_PKG dependencies on FND_GLOBAL

Line 5: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;

1: PACKAGE BODY PA_RBS_ASGMT_PKG AS
2: /* $Header: PARASGTB.pls 120.0 2005/06/03 13:33:52 appldev noship $*/
3:
4: -- Standard who
5: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: g_last_update_date DATE := SYSDATE;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
9: -- g_last_update_login NUMBER(15) := FND_GLOBAL.LOG_ID;

Line 8: g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;

4: -- Standard who
5: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: g_last_update_date DATE := SYSDATE;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
9: -- g_last_update_login NUMBER(15) := FND_GLOBAL.LOG_ID;
10:
11: /**************************************************************
12: * Procedure : Insert_Row

Line 9: -- g_last_update_login NUMBER(15) := FND_GLOBAL.LOG_ID;

5: g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6: g_last_update_date DATE := SYSDATE;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
9: -- g_last_update_login NUMBER(15) := FND_GLOBAL.LOG_ID;
10:
11: /**************************************************************
12: * Procedure : Insert_Row
13: * Description : The purpose of this procedure is to

Line 59: FND_GLOBAL.USER_ID,

55: p_prog_rep_usage_flag,
56: p_primary_rep_flag,
57: 'ACTIVE',
58: SYSDATE,
59: FND_GLOBAL.USER_ID,
60: SYSDATE,
61: FND_GLOBAL.USER_ID,
62: FND_GLOBAL.LOGIN_ID,
63: 1);

Line 61: FND_GLOBAL.USER_ID,

57: 'ACTIVE',
58: SYSDATE,
59: FND_GLOBAL.USER_ID,
60: SYSDATE,
61: FND_GLOBAL.USER_ID,
62: FND_GLOBAL.LOGIN_ID,
63: 1);
64: EXCEPTION
65: WHEN OTHERS THEN

Line 62: FND_GLOBAL.LOGIN_ID,

58: SYSDATE,
59: FND_GLOBAL.USER_ID,
60: SYSDATE,
61: FND_GLOBAL.USER_ID,
62: FND_GLOBAL.LOGIN_ID,
63: 1);
64: EXCEPTION
65: WHEN OTHERS THEN
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 96: last_updated_by = FND_GLOBAL.USER_ID,

92: fp_usage_flag = p_fp_usage_flag,
93: prog_rep_usage_flag = p_prog_rep_usage_flag,
94: primary_reporting_rbs_flag = p_primary_rep_flag,
95: last_update_date = SYSDATE,
96: last_updated_by = FND_GLOBAL.USER_ID,
97: last_update_login = FND_GLOBAL.LOGIN_ID,
98: record_version_number = record_version_number +1
99: WHERE Rbs_prj_assignment_id = p_rbs_prj_assignment_id
100: AND assignment_status = 'ACTIVE'

Line 97: last_update_login = FND_GLOBAL.LOGIN_ID,

93: prog_rep_usage_flag = p_prog_rep_usage_flag,
94: primary_reporting_rbs_flag = p_primary_rep_flag,
95: last_update_date = SYSDATE,
96: last_updated_by = FND_GLOBAL.USER_ID,
97: last_update_login = FND_GLOBAL.LOGIN_ID,
98: record_version_number = record_version_number +1
99: WHERE Rbs_prj_assignment_id = p_rbs_prj_assignment_id
100: AND assignment_status = 'ACTIVE'
101: AND NVL(record_version_number, 0) =