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_POSITIONS_PVT dependencies on PSB_WS_ACCT1

Line 4509: PSB_WS_ACCT1.Flex_Info

4505: l_set_of_books_id;
4506: CLOSE c_bg;
4507:
4508:
4509: PSB_WS_ACCT1.Flex_Info
4510: (p_flex_code => l_chart_of_accounts_id,
4511: p_return_status => l_return_status);
4512:
4513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4519: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

4515: END IF;
4516:
4517:
4518: -- get calendar start/end dates
4519: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
4520: begin
4521:
4522: PSB_WS_ACCT1.Cache_Budget_Calendar(p_return_status => p_return_status,
4523: p_budget_calendar_id => l_budget_calendar_id);

Line 4522: PSB_WS_ACCT1.Cache_Budget_Calendar(p_return_status => p_return_status,

4518: -- get calendar start/end dates
4519: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
4520: begin
4521:
4522: PSB_WS_ACCT1.Cache_Budget_Calendar(p_return_status => p_return_status,
4523: p_budget_calendar_id => l_budget_calendar_id);
4524:
4525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4526: RAISE FND_API.G_EXC_ERROR ;

Line 4563: p_startdate_pp => PSB_WS_ACCT1.g_startdate_pp,

4559: p_budget_calendar_id => l_budget_calendar_id,
4560: p_chart_of_accounts_id => l_chart_of_accounts_id,
4561: p_position_start_date => l_positions_rec.effective_start_date,
4562: p_position_end_date => l_positions_rec.effective_end_date,
4563: p_startdate_pp => PSB_WS_ACCT1.g_startdate_pp,
4564: p_enddate_cy => PSB_WS_ACCT1.g_enddate_cy,
4565: p_effective_start_date => PSB_WS_ACCT1.g_startdate_cy,
4566: p_effective_end_date => PSB_WS_ACCT1.g_end_est_date,
4567: p_error_flag => l_error_flag,

Line 4564: p_enddate_cy => PSB_WS_ACCT1.g_enddate_cy,

4560: p_chart_of_accounts_id => l_chart_of_accounts_id,
4561: p_position_start_date => l_positions_rec.effective_start_date,
4562: p_position_end_date => l_positions_rec.effective_end_date,
4563: p_startdate_pp => PSB_WS_ACCT1.g_startdate_pp,
4564: p_enddate_cy => PSB_WS_ACCT1.g_enddate_cy,
4565: p_effective_start_date => PSB_WS_ACCT1.g_startdate_cy,
4566: p_effective_end_date => PSB_WS_ACCT1.g_end_est_date,
4567: p_error_flag => l_error_flag,
4568: p_return_status => l_return_status);

Line 4565: p_effective_start_date => PSB_WS_ACCT1.g_startdate_cy,

4561: p_position_start_date => l_positions_rec.effective_start_date,
4562: p_position_end_date => l_positions_rec.effective_end_date,
4563: p_startdate_pp => PSB_WS_ACCT1.g_startdate_pp,
4564: p_enddate_cy => PSB_WS_ACCT1.g_enddate_cy,
4565: p_effective_start_date => PSB_WS_ACCT1.g_startdate_cy,
4566: p_effective_end_date => PSB_WS_ACCT1.g_end_est_date,
4567: p_error_flag => l_error_flag,
4568: p_return_status => l_return_status);
4569:

Line 4566: p_effective_end_date => PSB_WS_ACCT1.g_end_est_date,

4562: p_position_end_date => l_positions_rec.effective_end_date,
4563: p_startdate_pp => PSB_WS_ACCT1.g_startdate_pp,
4564: p_enddate_cy => PSB_WS_ACCT1.g_enddate_cy,
4565: p_effective_start_date => PSB_WS_ACCT1.g_startdate_cy,
4566: p_effective_end_date => PSB_WS_ACCT1.g_end_est_date,
4567: p_error_flag => l_error_flag,
4568: p_return_status => l_return_status);
4569:
4570:

Line 4959: IF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') AND

4955: END IF;
4956:
4957: FOR l_index IN 1..l_last_index LOOP
4958:
4959: IF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') AND
4960: (c_Dist_Rec.segment1 IS NOT NULL)) THEN
4961: l_seg_val(l_index) := c_Dist_Rec.segment1;
4962:
4963: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') AND

Line 4963: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') AND

4959: IF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') AND
4960: (c_Dist_Rec.segment1 IS NOT NULL)) THEN
4961: l_seg_val(l_index) := c_Dist_Rec.segment1;
4962:
4963: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') AND
4964: (c_Dist_Rec.segment2 IS NOT NULL)) THEN
4965: l_seg_val(l_index) := c_Dist_Rec.segment2;
4966:
4967: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') AND

Line 4967: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') AND

4963: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') AND
4964: (c_Dist_Rec.segment2 IS NOT NULL)) THEN
4965: l_seg_val(l_index) := c_Dist_Rec.segment2;
4966:
4967: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') AND
4968: (c_Dist_Rec.segment3 IS NOT NULL)) THEN
4969: l_seg_val(l_index) := c_Dist_Rec.segment3;
4970:
4971: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') AND

Line 4971: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') AND

4967: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') AND
4968: (c_Dist_Rec.segment3 IS NOT NULL)) THEN
4969: l_seg_val(l_index) := c_Dist_Rec.segment3;
4970:
4971: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') AND
4972: (c_Dist_Rec.segment4 IS NOT NULL)) THEN
4973: l_seg_val(l_index) := c_Dist_Rec.segment4;
4974:
4975: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') AND

Line 4975: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') AND

4971: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') AND
4972: (c_Dist_Rec.segment4 IS NOT NULL)) THEN
4973: l_seg_val(l_index) := c_Dist_Rec.segment4;
4974:
4975: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') AND
4976: (c_Dist_Rec.segment5 IS NOT NULL)) THEN
4977: l_seg_val(l_index) := c_Dist_Rec.segment5;
4978:
4979: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') AND

Line 4979: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') AND

4975: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') AND
4976: (c_Dist_Rec.segment5 IS NOT NULL)) THEN
4977: l_seg_val(l_index) := c_Dist_Rec.segment5;
4978:
4979: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') AND
4980: (c_Dist_Rec.segment6 IS NOT NULL)) THEN
4981: l_seg_val(l_index) := c_Dist_Rec.segment6;
4982:
4983: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') AND

Line 4983: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') AND

4979: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') AND
4980: (c_Dist_Rec.segment6 IS NOT NULL)) THEN
4981: l_seg_val(l_index) := c_Dist_Rec.segment6;
4982:
4983: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') AND
4984: (c_Dist_Rec.segment7 IS NOT NULL)) THEN
4985: l_seg_val(l_index) := c_Dist_Rec.segment7;
4986:
4987: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') AND

Line 4987: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') AND

4983: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') AND
4984: (c_Dist_Rec.segment7 IS NOT NULL)) THEN
4985: l_seg_val(l_index) := c_Dist_Rec.segment7;
4986:
4987: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') AND
4988: (c_Dist_Rec.segment8 IS NOT NULL)) THEN
4989: l_seg_val(l_index) := c_Dist_Rec.segment8;
4990:
4991: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') AND

Line 4991: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') AND

4987: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') AND
4988: (c_Dist_Rec.segment8 IS NOT NULL)) THEN
4989: l_seg_val(l_index) := c_Dist_Rec.segment8;
4990:
4991: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') AND
4992: (c_Dist_Rec.segment9 IS NOT NULL)) THEN
4993: l_seg_val(l_index) := c_Dist_Rec.segment9;
4994:
4995: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') AND

Line 4995: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') AND

4991: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') AND
4992: (c_Dist_Rec.segment9 IS NOT NULL)) THEN
4993: l_seg_val(l_index) := c_Dist_Rec.segment9;
4994:
4995: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') AND
4996: (c_Dist_Rec.segment10 IS NOT NULL)) THEN
4997: l_seg_val(l_index) := c_Dist_Rec.segment10;
4998:
4999: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') AND

Line 4999: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') AND

4995: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') AND
4996: (c_Dist_Rec.segment10 IS NOT NULL)) THEN
4997: l_seg_val(l_index) := c_Dist_Rec.segment10;
4998:
4999: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') AND
5000: (c_Dist_Rec.segment11 IS NOT NULL)) THEN
5001: l_seg_val(l_index) := c_Dist_Rec.segment11;
5002:
5003: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') AND

Line 5003: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') AND

4999: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') AND
5000: (c_Dist_Rec.segment11 IS NOT NULL)) THEN
5001: l_seg_val(l_index) := c_Dist_Rec.segment11;
5002:
5003: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') AND
5004: (c_Dist_Rec.segment12 IS NOT NULL)) THEN
5005: l_seg_val(l_index) := c_Dist_Rec.segment12;
5006:
5007: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') AND

Line 5007: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') AND

5003: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') AND
5004: (c_Dist_Rec.segment12 IS NOT NULL)) THEN
5005: l_seg_val(l_index) := c_Dist_Rec.segment12;
5006:
5007: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') AND
5008: (c_Dist_Rec.segment13 IS NOT NULL)) THEN
5009: l_seg_val(l_index) := c_Dist_Rec.segment13;
5010:
5011: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') AND

Line 5011: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') AND

5007: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') AND
5008: (c_Dist_Rec.segment13 IS NOT NULL)) THEN
5009: l_seg_val(l_index) := c_Dist_Rec.segment13;
5010:
5011: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') AND
5012: (c_Dist_Rec.segment14 IS NOT NULL)) THEN
5013: l_seg_val(l_index) := c_Dist_Rec.segment14;
5014:
5015: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') AND

Line 5015: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') AND

5011: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') AND
5012: (c_Dist_Rec.segment14 IS NOT NULL)) THEN
5013: l_seg_val(l_index) := c_Dist_Rec.segment14;
5014:
5015: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') AND
5016: (c_Dist_Rec.segment15 IS NOT NULL)) THEN
5017: l_seg_val(l_index) := c_Dist_Rec.segment15;
5018:
5019: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') AND

Line 5019: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') AND

5015: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') AND
5016: (c_Dist_Rec.segment15 IS NOT NULL)) THEN
5017: l_seg_val(l_index) := c_Dist_Rec.segment15;
5018:
5019: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') AND
5020: (c_Dist_Rec.segment16 IS NOT NULL)) THEN
5021: l_seg_val(l_index) := c_Dist_Rec.segment16;
5022:
5023: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') AND

Line 5023: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') AND

5019: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') AND
5020: (c_Dist_Rec.segment16 IS NOT NULL)) THEN
5021: l_seg_val(l_index) := c_Dist_Rec.segment16;
5022:
5023: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') AND
5024: (c_Dist_Rec.segment17 IS NOT NULL)) THEN
5025: l_seg_val(l_index) := c_Dist_Rec.segment17;
5026:
5027: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') AND

Line 5027: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') AND

5023: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') AND
5024: (c_Dist_Rec.segment17 IS NOT NULL)) THEN
5025: l_seg_val(l_index) := c_Dist_Rec.segment17;
5026:
5027: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') AND
5028: (c_Dist_Rec.segment18 IS NOT NULL)) THEN
5029: l_seg_val(l_index) := c_Dist_Rec.segment18;
5030:
5031: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') AND

Line 5031: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') AND

5027: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') AND
5028: (c_Dist_Rec.segment18 IS NOT NULL)) THEN
5029: l_seg_val(l_index) := c_Dist_Rec.segment18;
5030:
5031: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') AND
5032: (c_Dist_Rec.segment19 IS NOT NULL)) THEN
5033: l_seg_val(l_index) := c_Dist_Rec.segment19;
5034:
5035: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') AND

Line 5035: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') AND

5031: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') AND
5032: (c_Dist_Rec.segment19 IS NOT NULL)) THEN
5033: l_seg_val(l_index) := c_Dist_Rec.segment19;
5034:
5035: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') AND
5036: (c_Dist_Rec.segment20 IS NOT NULL)) THEN
5037: l_seg_val(l_index) := c_Dist_Rec.segment20;
5038:
5039: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') AND

Line 5039: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') AND

5035: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') AND
5036: (c_Dist_Rec.segment20 IS NOT NULL)) THEN
5037: l_seg_val(l_index) := c_Dist_Rec.segment20;
5038:
5039: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') AND
5040: (c_Dist_Rec.segment21 IS NOT NULL)) THEN
5041: l_seg_val(l_index) := c_Dist_Rec.segment21;
5042:
5043: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') AND

Line 5043: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') AND

5039: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') AND
5040: (c_Dist_Rec.segment21 IS NOT NULL)) THEN
5041: l_seg_val(l_index) := c_Dist_Rec.segment21;
5042:
5043: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') AND
5044: (c_Dist_Rec.segment22 IS NOT NULL)) THEN
5045: l_seg_val(l_index) := c_Dist_Rec.segment22;
5046:
5047: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') AND

Line 5047: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') AND

5043: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') AND
5044: (c_Dist_Rec.segment22 IS NOT NULL)) THEN
5045: l_seg_val(l_index) := c_Dist_Rec.segment22;
5046:
5047: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') AND
5048: (c_Dist_Rec.segment23 IS NOT NULL)) THEN
5049: l_seg_val(l_index) := c_Dist_Rec.segment23;
5050:
5051: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') AND

Line 5051: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') AND

5047: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') AND
5048: (c_Dist_Rec.segment23 IS NOT NULL)) THEN
5049: l_seg_val(l_index) := c_Dist_Rec.segment23;
5050:
5051: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') AND
5052: (c_Dist_Rec.segment24 IS NOT NULL)) THEN
5053: l_seg_val(l_index) := c_Dist_Rec.segment24;
5054:
5055: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') AND

Line 5055: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') AND

5051: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') AND
5052: (c_Dist_Rec.segment24 IS NOT NULL)) THEN
5053: l_seg_val(l_index) := c_Dist_Rec.segment24;
5054:
5055: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') AND
5056: (c_Dist_Rec.segment25 IS NOT NULL)) THEN
5057: l_seg_val(l_index) := c_Dist_Rec.segment25;
5058:
5059: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') AND

Line 5059: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') AND

5055: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') AND
5056: (c_Dist_Rec.segment25 IS NOT NULL)) THEN
5057: l_seg_val(l_index) := c_Dist_Rec.segment25;
5058:
5059: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') AND
5060: (c_Dist_Rec.segment26 IS NOT NULL)) THEN
5061: l_seg_val(l_index) := c_Dist_Rec.segment26;
5062:
5063: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') AND

Line 5063: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') AND

5059: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') AND
5060: (c_Dist_Rec.segment26 IS NOT NULL)) THEN
5061: l_seg_val(l_index) := c_Dist_Rec.segment26;
5062:
5063: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') AND
5064: (c_Dist_Rec.segment27 IS NOT NULL)) THEN
5065: l_seg_val(l_index) := c_Dist_Rec.segment27;
5066:
5067: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') AND

Line 5067: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') AND

5063: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') AND
5064: (c_Dist_Rec.segment27 IS NOT NULL)) THEN
5065: l_seg_val(l_index) := c_Dist_Rec.segment27;
5066:
5067: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') AND
5068: (c_Dist_Rec.segment28 IS NOT NULL)) THEN
5069: l_seg_val(l_index) := c_Dist_Rec.segment28;
5070:
5071: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') AND

Line 5071: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') AND

5067: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') AND
5068: (c_Dist_Rec.segment28 IS NOT NULL)) THEN
5069: l_seg_val(l_index) := c_Dist_Rec.segment28;
5070:
5071: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') AND
5072: (c_Dist_Rec.segment29 IS NOT NULL)) THEN
5073: l_seg_val(l_index) := c_Dist_Rec.segment29;
5074:
5075: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') AND

Line 5075: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') AND

5071: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') AND
5072: (c_Dist_Rec.segment29 IS NOT NULL)) THEN
5073: l_seg_val(l_index) := c_Dist_Rec.segment29;
5074:
5075: ELSIF ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') AND
5076: (c_Dist_Rec.segment30 IS NOT NULL)) THEN
5077: l_seg_val(l_index) := c_Dist_Rec.segment30;
5078: ELSE
5079: l_seg_val(l_index) := l_ccid_val(l_index);

Line 5179: FOR l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods LOOP

5175: END IF;
5176:
5177: /* Bug 3247574 End */
5178:
5179: FOR l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods LOOP
5180:
5181: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
5182: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
5183:

Line 5181: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;

5177: /* Bug 3247574 End */
5178:
5179: FOR l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods LOOP
5180:
5181: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
5182: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
5183:
5184: END LOOP;
5185:

Line 5182: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;

5178:
5179: FOR l_calcperiod_index in 1..PSB_WS_ACCT1.g_num_calc_periods LOOP
5180:
5181: l_calc_start_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).start_date;
5182: l_calc_end_date := PSB_WS_ACCT1.g_calculation_periods(l_calcperiod_index).end_date;
5183:
5184: END LOOP;
5185:
5186: for c_job_rec in c_job loop