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_EXTRACT_DATA_PVT dependencies on PSP_LABOR_DIST

Line 2908: PSP_LABOR_DIST.Get_Distribution_Lines

2904:
2905: -- Call LD API to get the set of distributions for the
2906: -- assignment valid on p_date
2907:
2908: PSP_LABOR_DIST.Get_Distribution_Lines
2909: (p_proc_executed => l_proc_executed,
2910: p_person_id => null,
2911: p_sub_line_id => null,
2912: p_assignment_id => p_assignment_id,

Line 2926: For i in 1..PSP_LABOR_DIST.g_num_dist

2922: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2923: raise FND_API.G_EXC_ERROR;
2924: end if;
2925:
2926: For i in 1..PSP_LABOR_DIST.g_num_dist
2927: Loop
2928: l_segment1 := null;
2929: l_segment2 := null;
2930: l_segment3 := null;

Line 2959: if (PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id is not null) then

2955: l_segment28 := null;
2956: l_segment29 := null;
2957: l_segment30 := null;
2958:
2959: if (PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id is not null) then
2960: r := null;
2961: tf := FND_FLEX_EXT.GET_SEGMENTS('SQLGL','GL#',p_chart_of_accounts_id,PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id,nsegs,segs);
2962:
2963: if (tf) then

Line 2961: tf := FND_FLEX_EXT.GET_SEGMENTS('SQLGL','GL#',p_chart_of_accounts_id,PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id,nsegs,segs);

2957: l_segment30 := null;
2958:
2959: if (PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id is not null) then
2960: r := null;
2961: tf := FND_FLEX_EXT.GET_SEGMENTS('SQLGL','GL#',p_chart_of_accounts_id,PSP_LABOR_DIST.g_charging_instructions(i).gl_code_combination_id,nsegs,segs);
2962:
2963: if (tf) then
2964: r := 'VALID: ';
2965: for i in 1..nsegs loop

Line 3119: NVL(PSP_LABOR_DIST.g_charging_instructions(i).percent,0),

3115: p_assignment_id,
3116: p_business_group_id,
3117: 'ASSIGNMENT',
3118: --bug 3677529 added nvl function in the following line
3119: NVL(PSP_LABOR_DIST.g_charging_instructions(i).percent,0),
3120: p_chart_of_accounts_id,
3121: PSP_LABOR_DIST.g_charging_instructions(i).effective_start_date,
3122: PSP_LABOR_DIST.g_charging_instructions(i).effective_end_date,
3123: l_segment1,

Line 3121: PSP_LABOR_DIST.g_charging_instructions(i).effective_start_date,

3117: 'ASSIGNMENT',
3118: --bug 3677529 added nvl function in the following line
3119: NVL(PSP_LABOR_DIST.g_charging_instructions(i).percent,0),
3120: p_chart_of_accounts_id,
3121: PSP_LABOR_DIST.g_charging_instructions(i).effective_start_date,
3122: PSP_LABOR_DIST.g_charging_instructions(i).effective_end_date,
3123: l_segment1,
3124: l_segment2,
3125: l_segment3,

Line 3122: PSP_LABOR_DIST.g_charging_instructions(i).effective_end_date,

3118: --bug 3677529 added nvl function in the following line
3119: NVL(PSP_LABOR_DIST.g_charging_instructions(i).percent,0),
3120: p_chart_of_accounts_id,
3121: PSP_LABOR_DIST.g_charging_instructions(i).effective_start_date,
3122: PSP_LABOR_DIST.g_charging_instructions(i).effective_end_date,
3123: l_segment1,
3124: l_segment2,
3125: l_segment3,
3126: l_segment4,

Line 3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,

3154: l_last_updated_by,
3155: l_last_update_login,
3156: l_created_by,
3157: l_creation_date,
3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,
3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,

Line 3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,

3155: l_last_update_login,
3156: l_created_by,
3157: l_creation_date,
3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,
3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,
3163: PSP_LABOR_DIST.g_charging_instructions(i).description

Line 3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,

3156: l_created_by,
3157: l_creation_date,
3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,
3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,
3163: PSP_LABOR_DIST.g_charging_instructions(i).description
3164: );

Line 3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,

3157: l_creation_date,
3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,
3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,
3163: PSP_LABOR_DIST.g_charging_instructions(i).description
3164: );
3165: End Loop;

Line 3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,

3158: PSP_LABOR_DIST.g_charging_instructions(i).project_id,
3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,
3163: PSP_LABOR_DIST.g_charging_instructions(i).description
3164: );
3165: End Loop;
3166:

Line 3163: PSP_LABOR_DIST.g_charging_instructions(i).description

3159: PSP_LABOR_DIST.g_charging_instructions(i).task_id,
3160: PSP_LABOR_DIST.g_charging_instructions(i).award_id,
3161: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_type,
3162: PSP_LABOR_DIST.g_charging_instructions(i).expenditure_organization_id,
3163: PSP_LABOR_DIST.g_charging_instructions(i).description
3164: );
3165: End Loop;
3166:
3167: -- End of API body.