eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_HR_POPULATE_DATA_PVT

Line 1: PACKAGE BODY PSB_HR_POPULATE_DATA_PVT AS

1: PACKAGE BODY PSB_HR_POPULATE_DATA_PVT AS
2: /* $Header: PSBVHRPB.pls 120.43 2006/01/09 06:06:08 maniskum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_HR_POPULATE_DATA_PVT';
5: g_dbug VARCHAR2(15000);

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_HR_POPULATE_DATA_PVT';

1: PACKAGE BODY PSB_HR_POPULATE_DATA_PVT AS
2: /* $Header: PSBVHRPB.pls 120.43 2006/01/09 06:06:08 maniskum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_HR_POPULATE_DATA_PVT';
5: g_dbug VARCHAR2(15000);
6:
7: TYPE g_glcostmap_rec_type IS RECORD
8: (gl_account_segment VARCHAR2(30),

Line 4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);

4082: RETURN;
4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:

Line 4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);

4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:
4091: -- get first budget group associated to input organization starting within the input bg's hierarchy

Line 4118: p_worksheet_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),

4114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4115: p_return_status => l_return_status,
4116: p_msg_count => l_msg_count,
4117: p_msg_data => l_msg_data,
4118: p_worksheet_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),
4119: p_position_id => p_position_id,
4120: p_budget_group_id => l_org_budget_group_id,
4121: p_position_line_id => l_position_line_id);
4122:

Line 4139: p_budget_revision_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),

4135: (p_api_version => 1.0,
4136: p_return_status => l_return_status,
4137: p_msg_count => l_msg_count,
4138: p_msg_data => l_msg_data,
4139: p_budget_revision_id => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),
4140: p_budget_revision_pos_line_id => l_budget_rev_pos_line_id,
4141: p_position_id => p_position_id,
4142: p_budget_group_id => l_org_budget_group_id,
4143: p_effective_start_date =>

Line 4144: PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_START_DATE'),

4140: p_budget_revision_pos_line_id => l_budget_rev_pos_line_id,
4141: p_position_id => p_position_id,
4142: p_budget_group_id => l_org_budget_group_id,
4143: p_effective_start_date =>
4144: PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_START_DATE'),
4145: p_effective_end_date => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_END_DATE'),
4146: p_revision_type => null,
4147: p_revision_value_type => null,
4148: p_revision_value => null,

Line 4145: p_effective_end_date => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_END_DATE'),

4141: p_position_id => p_position_id,
4142: p_budget_group_id => l_org_budget_group_id,
4143: p_effective_start_date =>
4144: PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_START_DATE'),
4145: p_effective_end_date => PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_REVISION_END_DATE'),
4146: p_revision_type => null,
4147: p_revision_value_type => null,
4148: p_revision_value => null,
4149: p_note_id => null,

Line 4160: l_budget_revision_id := PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID');

4156: else
4157: -- update the position table for system data extract with budget group ID
4158: -- start bug 3253644
4159:
4160: l_budget_revision_id := PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID');
4161:
4162: FOR l_bud_group_csr IN (
4163: SELECT a.budget_group_id, b.root_budget_group
4164: FROM psb_budget_revisions a,

Line 5817: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;

5813: END IF;
5814: p_return_status := FND_API.G_RET_STS_SUCCESS;
5815:
5816: -- for bug 4213882
5817: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;
5818: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := 'Y';
5819:
5820: -- Populate WHO columns.
5821: l_last_update_date := sysdate;

Line 5818: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := 'Y';

5814: p_return_status := FND_API.G_RET_STS_SUCCESS;
5815:
5816: -- for bug 4213882
5817: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;
5818: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := 'Y';
5819:
5820: -- Populate WHO columns.
5821: l_last_update_date := sysdate;
5822: l_last_updated_BY := FND_GLOBAL.USER_ID;

Line 6851: PSB_HR_POPULATE_DATA_PVT.g_extract_method := null;

6847:
6848: END IF; -- Check IF (l_status = 'I')
6849: --
6850: -- for bug 4213882
6851: PSB_HR_POPULATE_DATA_PVT.g_extract_method := null;
6852: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := null;
6853:
6854: EXCEPTION
6855: --

Line 6852: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := null;

6848: END IF; -- Check IF (l_status = 'I')
6849: --
6850: -- for bug 4213882
6851: PSB_HR_POPULATE_DATA_PVT.g_extract_method := null;
6852: PSB_HR_POPULATE_DATA_PVT.g_pop_assignment := null;
6853:
6854: EXCEPTION
6855: --
6856: WHEN FND_API.G_EXC_ERROR THEN

Line 9074: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;

9070: l_created_BY := FND_GLOBAL.USER_ID;
9071:
9072: /* start bug 4153562 */
9073: -- initialize the packaged varible with the extract method.
9074: PSB_HR_POPULATE_DATA_PVT.g_extract_method := p_extract_method;
9075: /* end bug 4153562 */
9076:
9077: IF NOT FND_API.Compatible_API_Call (l_api_version,
9078: p_api_version,

Line 9483: PSB_HR_POPULATE_DATA_PVT.g_extract_method := null;

9479:
9480: /* start bug 4153562 */
9481: -- re-initialize the packaged variable back to null
9482: -- at the end of the populate_position_assignment API.
9483: PSB_HR_POPULATE_DATA_PVT.g_extract_method := null;
9484: /* end bug 4153562 */
9485:
9486: commit work;
9487: END IF;

Line 9707: END PSB_HR_POPULATE_DATA_PVT;

9703: END get_debug;
9704: /*---------------------------------------------------------------------------*/
9705:
9706:
9707: END PSB_HR_POPULATE_DATA_PVT;