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;
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
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
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);
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
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;
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'
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) =