APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_ACCOUNTS

Line 4907: UPDATE PSB_POSITION_ACCOUNTS

4903: -- for bug 4545590
4904: IF NOT g_wks_new_hr_budget THEN
4905:
4906: FORALL i IN 1..l_count_accounts
4907: UPDATE PSB_POSITION_ACCOUNTS
4908: SET amount = l_account_amount(i),
4909: budget_group_id = l_account_bg_id(i),
4910: last_update_date = sysdate,
4911: last_updated_by = FND_GLOBAL.USER_ID,

Line 5148: UPDATE PSB_POSITION_ACCOUNTS

5144: -- FOR BUG 4545590
5145: IF NOT g_wks_new_hr_budget THEN
5146:
5147: FORALL i IN 1..l_count_accounts
5148: UPDATE PSB_POSITION_ACCOUNTS
5149: SET amount = l_account_amount(i),
5150: budget_group_id = l_account_bg_id(i),
5151: last_update_date = sysdate,
5152: last_updated_by = FND_GLOBAL.USER_ID,

Line 5467: from psb_position_accounts

5463: select 'Exists'
5464: from dual
5465: where exists
5466: (select 'Exists'
5467: from psb_position_accounts
5468: where budget_revision_id = p_source_id
5469: and position_id = p_position_id);
5470:
5471: BEGIN

Line 6241: insert into PSB_POSITION_ACCOUNTS

6237: l_position_account_line_id NUMBER;
6238:
6239: BEGIN
6240:
6241: insert into PSB_POSITION_ACCOUNTS
6242: (position_account_line_id, position_id, hr_budget_id, budget_revision_id, budget_group_id,
6243: base_line_version, start_date, end_date, code_combination_id, currency_code,
6244: amount, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6245: values (PSB_POSITION_ACCOUNTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_budget_group_id,

Line 6245: values (PSB_POSITION_ACCOUNTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_budget_group_id,

6241: insert into PSB_POSITION_ACCOUNTS
6242: (position_account_line_id, position_id, hr_budget_id, budget_revision_id, budget_group_id,
6243: base_line_version, start_date, end_date, code_combination_id, currency_code,
6244: amount, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6245: values (PSB_POSITION_ACCOUNTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_budget_group_id,
6246: p_base_line_version, p_start_date, p_end_date, p_code_combination_id, p_currency_code,
6247: p_amount, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
6248: RETURNING position_account_line_id into l_position_account_line_id;
6249:

Line 6299: update PSB_POSITION_ACCOUNTS

6295: l_api_name CONSTANT VARCHAR2(30) := 'Update_Position_Accounts';
6296:
6297: BEGIN
6298:
6299: update PSB_POSITION_ACCOUNTS
6300: set amount = p_amount,
6301: budget_group_id = p_budget_group_id,
6302: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6303: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),

Line 6354: delete from PSB_POSITION_ACCOUNTS

6350: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Position_Accounts';
6351:
6352: BEGIN
6353:
6354: delete from PSB_POSITION_ACCOUNTS
6355: where position_account_line_id = p_position_account_line_id;
6356:
6357: -- Initialize API return status to success
6358: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6427: from PSB_POSITION_ACCOUNTS

6423: /*For Bug No : 1808322 End*/
6424:
6425: cursor c_Overlap is
6426: select *
6427: from PSB_POSITION_ACCOUNTS
6428: where position_id = p_position_id
6429: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
6430: and code_combination_id = p_code_combination_id
6431: and currency_code = p_currency_code

Line 6466: update PSB_POSITION_ACCOUNTS

6462: /*For Bug No : 1808322 Start*/
6463: IF p_budget_revision_id IS NOT null THEN
6464: /*For Bug No : 1808322 End*/
6465:
6466: update PSB_POSITION_ACCOUNTS
6467: set amount = p_amount,
6468: budget_group_id = p_budget_group_id,
6469: last_update_date = sysdate,
6470: last_updated_by = FND_GLOBAL.USER_ID,