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

Line 3310: PSB_WS_ACCT1.Find_CCIDs

3306: l_effective_end_date := c_gl_periods_rec.end_date;
3307:
3308: For C_Account_Sets_Rec in C_Account_Sets Loop
3309:
3310: PSB_WS_ACCT1.Find_CCIDs
3311: (p_return_status => l_return_status,
3312: p_account_set_id => c_Account_Sets_Rec.account_position_set_id);
3313:
3314: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3318: for l_ccid_index in 1..PSB_WS_ACCT1.g_num_ccids loop

3314: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3315: raise FND_API.G_EXC_ERROR;
3316: end if;
3317:
3318: for l_ccid_index in 1..PSB_WS_ACCT1.g_num_ccids loop
3319:
3320: l_ccid_start_period := greatest(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).start_date,
3321: c_Account_Sets_Rec.effective_start_date), c_Account_Sets_Rec.effective_start_date);
3322: l_ccid_end_period := least(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).end_date,

Line 3320: l_ccid_start_period := greatest(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).start_date,

3316: end if;
3317:
3318: for l_ccid_index in 1..PSB_WS_ACCT1.g_num_ccids loop
3319:
3320: l_ccid_start_period := greatest(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).start_date,
3321: c_Account_Sets_Rec.effective_start_date), c_Account_Sets_Rec.effective_start_date);
3322: l_ccid_end_period := least(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).end_date,
3323: c_Account_Sets_Rec.effective_end_date), c_Account_Sets_Rec.effective_end_date);
3324:

Line 3322: l_ccid_end_period := least(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).end_date,

3318: for l_ccid_index in 1..PSB_WS_ACCT1.g_num_ccids loop
3319:
3320: l_ccid_start_period := greatest(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).start_date,
3321: c_Account_Sets_Rec.effective_start_date), c_Account_Sets_Rec.effective_start_date);
3322: l_ccid_end_period := least(nvl(PSB_WS_ACCT1.g_ccids(l_ccid_index).end_date,
3323: c_Account_Sets_Rec.effective_end_date), c_Account_Sets_Rec.effective_end_date);
3324:
3325: l_ccid_type := null;
3326:

Line 3330: PSB_WS_ACCT1.Check_CCID_Type

3326:
3327: if (g_revise_by_position = 'Y') then
3328: begin
3329:
3330: PSB_WS_ACCT1.Check_CCID_Type
3331: (p_api_version => 1.0,
3332: p_return_status => l_return_status,
3333: p_ccid_type => l_ccid_type,
3334: p_flex_code => g_flex_code,

Line 3335: p_ccid => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3331: (p_api_version => 1.0,
3332: p_return_status => l_return_status,
3333: p_ccid_type => l_ccid_type,
3334: p_flex_code => g_flex_code,
3335: p_ccid => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3336: p_budget_group_id => c_Account_Sets_Rec.budget_group_id);
3337:
3338: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3339: raise FND_API.G_EXC_ERROR;

Line 3359: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3355: p_return_status => l_return_status,
3356: p_msg_count => l_msg_count,
3357: p_msg_data => l_msg_data,
3358: p_gl_budget_set_id => g_gl_budget_set_id,
3359: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3360: p_start_date => c_gl_periods_rec.start_date,
3361: p_dual_posting_type => 'A',
3362: p_gl_budget_version_id => l_budget_version_id);
3363:

Line 3377: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3373: p_return_status => l_return_status,
3374: p_msg_count => l_msg_count,
3375: p_msg_data => l_msg_data,
3376: p_gl_budget_set_id => g_gl_budget_set_id,
3377: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3378: p_start_date => c_gl_periods_rec.start_date,
3379: p_gl_budget_version_id => l_budget_version_id);
3380:
3381: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3390: (p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3386: end if;
3387:
3388: -- Get Original Budget for the ccid + gl_period + budget_version_id
3389: l_original_budget_balance := Find_Original_Budget_Balance
3390: (p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3391: p_budget_group_id => c_Account_Sets_Rec.budget_group_id,
3392: p_gl_period => c_gl_periods_rec.period_name,
3393: p_gl_budget_version_id => l_budget_version_id,
3394: p_currency_code => g_currency_code); -- Bug 3029168

Line 3404: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid);

3400: p_xbc_enabled_flag => g_budgetary_control,
3401: p_gl_period_name => c_gl_periods_rec.period_name,
3402: p_gl_budget_version_id => l_budget_version_id,
3403: p_currency_code => g_currency_code,
3404: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid);
3405:
3406: -- Compute a Compound Factor for each Budget Year if Compound Annually is set
3407:
3408: if (c_gl_periods_rec.start_date > add_months(lx_from_date, 12)) then

Line 3418: p_ccid => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3414: if (AcctParam_Exists(p_parameter_id => c_AccParam_Rec.parameter_id,
3415: p_budget_revision_id => p_budget_revision_id,
3416: p_period_name => c_gl_periods_rec.period_name,
3417: p_local_parameter => l_local_parameter,
3418: p_ccid => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3419: p_ccid_start_period => l_ccid_start_period,
3420: p_ccid_end_period => l_ccid_end_period,
3421: p_period_start_date => c_gl_periods_rec.start_date,
3422: p_period_end_date => c_gl_periods_rec.end_date)) then

Line 3470: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,

3466: p_msg_count => l_msg_count,
3467: p_msg_data => l_msg_data,
3468: p_budget_revision_id => p_budget_revision_id,
3469: p_budget_revision_acct_line_id => l_budget_revision_acct_line_id,
3470: p_code_combination_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid,
3471: p_budget_group_id => c_Account_Sets_Rec.budget_group_id,
3472: p_gl_period_name => c_gl_periods_rec.period_name,
3473: p_gl_budget_version_id => l_budget_version_id,
3474: p_currency_code => g_currency_code,

Line 3507: , p_cc_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid -- Bug#4675858

3503: , p_account_line_id => l_budget_revision_acct_line_id
3504: , p_position_line_id => NULL
3505: , p_note => l_note
3506: , p_flex_code => g_flex_code
3507: , p_cc_id => PSB_WS_ACCT1.g_ccids(l_ccid_index).ccid -- Bug#4675858
3508: ) ;
3509:
3510: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3511: raise FND_API.G_EXC_ERROR;

Line 4605: if g_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then

4601: add_message('PSB', 'PSB_NO_SALARY_DISTRIBUTION');
4602: raise FND_API.G_EXC_ERROR;
4603: end if;
4604:
4605: if g_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
4606: begin
4607:
4608: PSB_WS_ACCT1.Flex_Info
4609: (p_flex_code => g_flex_code,

Line 4608: PSB_WS_ACCT1.Flex_Info

4604:
4605: if g_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
4606: begin
4607:
4608: PSB_WS_ACCT1.Flex_Info
4609: (p_flex_code => g_flex_code,
4610: p_return_status => l_return_status);
4611:
4612: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 5988: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop

5984:
5985: -- added for bug # 4502946
5986: l_percent := PSB_WS_POS1.g_salary_dist(l_saldist_index).percent / 100;
5987:
5988: for l_init_index in 1..PSB_WS_ACCT1.g_num_segs loop
5989: l_ccid_val(l_init_index) := null;
5990: l_seg_val(l_init_index) := null;
5991: end loop;
5992:

Line 5998: n_segments => PSB_WS_ACCT1.g_num_segs,

5994: (application_short_name => 'SQLGL',
5995: key_flex_code => 'GL#',
5996: structure_number => g_flex_code,
5997: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,
5998: n_segments => PSB_WS_ACCT1.g_num_segs,
5999: segments => l_ccid_val) then
6000:
6001: FND_MSG_PUB.Add;
6002: raise FND_API.G_EXC_ERROR;

Line 6005: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop

6001: FND_MSG_PUB.Add;
6002: raise FND_API.G_EXC_ERROR;
6003: end if;
6004:
6005: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
6006:
6007: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
6008: (c_Dist_Rec.segment1 is not null)) then
6009: l_seg_val(l_index) := c_Dist_Rec.segment1;

Line 6007: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and

6003: end if;
6004:
6005: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
6006:
6007: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
6008: (c_Dist_Rec.segment1 is not null)) then
6009: l_seg_val(l_index) := c_Dist_Rec.segment1;
6010:
6011: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and

Line 6011: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and

6007: if ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT1') and
6008: (c_Dist_Rec.segment1 is not null)) then
6009: l_seg_val(l_index) := c_Dist_Rec.segment1;
6010:
6011: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
6012: (c_Dist_Rec.segment2 is not null)) then
6013: l_seg_val(l_index) := c_Dist_Rec.segment2;
6014:
6015: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and

Line 6015: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and

6011: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT2') and
6012: (c_Dist_Rec.segment2 is not null)) then
6013: l_seg_val(l_index) := c_Dist_Rec.segment2;
6014:
6015: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
6016: (c_Dist_Rec.segment3 is not null)) then
6017: l_seg_val(l_index) := c_Dist_Rec.segment3;
6018:
6019: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and

Line 6019: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and

6015: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT3') and
6016: (c_Dist_Rec.segment3 is not null)) then
6017: l_seg_val(l_index) := c_Dist_Rec.segment3;
6018:
6019: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
6020: (c_Dist_Rec.segment4 is not null)) then
6021: l_seg_val(l_index) := c_Dist_Rec.segment4;
6022:
6023: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and

Line 6023: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and

6019: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT4') and
6020: (c_Dist_Rec.segment4 is not null)) then
6021: l_seg_val(l_index) := c_Dist_Rec.segment4;
6022:
6023: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
6024: (c_Dist_Rec.segment5 is not null)) then
6025: l_seg_val(l_index) := c_Dist_Rec.segment5;
6026:
6027: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and

Line 6027: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and

6023: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT5') and
6024: (c_Dist_Rec.segment5 is not null)) then
6025: l_seg_val(l_index) := c_Dist_Rec.segment5;
6026:
6027: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
6028: (c_Dist_Rec.segment6 is not null)) then
6029: l_seg_val(l_index) := c_Dist_Rec.segment6;
6030:
6031: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and

Line 6031: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and

6027: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT6') and
6028: (c_Dist_Rec.segment6 is not null)) then
6029: l_seg_val(l_index) := c_Dist_Rec.segment6;
6030:
6031: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
6032: (c_Dist_Rec.segment7 is not null)) then
6033: l_seg_val(l_index) := c_Dist_Rec.segment7;
6034:
6035: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and

Line 6035: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and

6031: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT7') and
6032: (c_Dist_Rec.segment7 is not null)) then
6033: l_seg_val(l_index) := c_Dist_Rec.segment7;
6034:
6035: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
6036: (c_Dist_Rec.segment8 is not null)) then
6037: l_seg_val(l_index) := c_Dist_Rec.segment8;
6038:
6039: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and

Line 6039: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and

6035: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT8') and
6036: (c_Dist_Rec.segment8 is not null)) then
6037: l_seg_val(l_index) := c_Dist_Rec.segment8;
6038:
6039: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
6040: (c_Dist_Rec.segment9 is not null)) then
6041: l_seg_val(l_index) := c_Dist_Rec.segment9;
6042:
6043: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and

Line 6043: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and

6039: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT9') and
6040: (c_Dist_Rec.segment9 is not null)) then
6041: l_seg_val(l_index) := c_Dist_Rec.segment9;
6042:
6043: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
6044: (c_Dist_Rec.segment10 is not null)) then
6045: l_seg_val(l_index) := c_Dist_Rec.segment10;
6046:
6047: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and

Line 6047: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and

6043: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT10') and
6044: (c_Dist_Rec.segment10 is not null)) then
6045: l_seg_val(l_index) := c_Dist_Rec.segment10;
6046:
6047: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
6048: (c_Dist_Rec.segment11 is not null)) then
6049: l_seg_val(l_index) := c_Dist_Rec.segment11;
6050:
6051: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and

Line 6051: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and

6047: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT11') and
6048: (c_Dist_Rec.segment11 is not null)) then
6049: l_seg_val(l_index) := c_Dist_Rec.segment11;
6050:
6051: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
6052: (c_Dist_Rec.segment12 is not null)) then
6053: l_seg_val(l_index) := c_Dist_Rec.segment12;
6054:
6055: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and

Line 6055: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and

6051: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT12') and
6052: (c_Dist_Rec.segment12 is not null)) then
6053: l_seg_val(l_index) := c_Dist_Rec.segment12;
6054:
6055: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
6056: (c_Dist_Rec.segment13 is not null)) then
6057: l_seg_val(l_index) := c_Dist_Rec.segment13;
6058:
6059: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and

Line 6059: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and

6055: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT13') and
6056: (c_Dist_Rec.segment13 is not null)) then
6057: l_seg_val(l_index) := c_Dist_Rec.segment13;
6058:
6059: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
6060: (c_Dist_Rec.segment14 is not null)) then
6061: l_seg_val(l_index) := c_Dist_Rec.segment14;
6062:
6063: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and

Line 6063: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and

6059: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT14') and
6060: (c_Dist_Rec.segment14 is not null)) then
6061: l_seg_val(l_index) := c_Dist_Rec.segment14;
6062:
6063: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
6064: (c_Dist_Rec.segment15 is not null)) then
6065: l_seg_val(l_index) := c_Dist_Rec.segment15;
6066:
6067: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and

Line 6067: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and

6063: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT15') and
6064: (c_Dist_Rec.segment15 is not null)) then
6065: l_seg_val(l_index) := c_Dist_Rec.segment15;
6066:
6067: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
6068: (c_Dist_Rec.segment16 is not null)) then
6069: l_seg_val(l_index) := c_Dist_Rec.segment16;
6070:
6071: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and

Line 6071: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and

6067: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT16') and
6068: (c_Dist_Rec.segment16 is not null)) then
6069: l_seg_val(l_index) := c_Dist_Rec.segment16;
6070:
6071: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
6072: (c_Dist_Rec.segment17 is not null)) then
6073: l_seg_val(l_index) := c_Dist_Rec.segment17;
6074:
6075: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and

Line 6075: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and

6071: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT17') and
6072: (c_Dist_Rec.segment17 is not null)) then
6073: l_seg_val(l_index) := c_Dist_Rec.segment17;
6074:
6075: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
6076: (c_Dist_Rec.segment18 is not null)) then
6077: l_seg_val(l_index) := c_Dist_Rec.segment18;
6078:
6079: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and

Line 6079: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and

6075: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT18') and
6076: (c_Dist_Rec.segment18 is not null)) then
6077: l_seg_val(l_index) := c_Dist_Rec.segment18;
6078:
6079: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
6080: (c_Dist_Rec.segment19 is not null)) then
6081: l_seg_val(l_index) := c_Dist_Rec.segment19;
6082:
6083: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and

Line 6083: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and

6079: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT19') and
6080: (c_Dist_Rec.segment19 is not null)) then
6081: l_seg_val(l_index) := c_Dist_Rec.segment19;
6082:
6083: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
6084: (c_Dist_Rec.segment20 is not null)) then
6085: l_seg_val(l_index) := c_Dist_Rec.segment20;
6086:
6087: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and

Line 6087: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and

6083: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT20') and
6084: (c_Dist_Rec.segment20 is not null)) then
6085: l_seg_val(l_index) := c_Dist_Rec.segment20;
6086:
6087: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
6088: (c_Dist_Rec.segment21 is not null)) then
6089: l_seg_val(l_index) := c_Dist_Rec.segment21;
6090:
6091: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and

Line 6091: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and

6087: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT21') and
6088: (c_Dist_Rec.segment21 is not null)) then
6089: l_seg_val(l_index) := c_Dist_Rec.segment21;
6090:
6091: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
6092: (c_Dist_Rec.segment22 is not null)) then
6093: l_seg_val(l_index) := c_Dist_Rec.segment22;
6094:
6095: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and

Line 6095: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and

6091: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT22') and
6092: (c_Dist_Rec.segment22 is not null)) then
6093: l_seg_val(l_index) := c_Dist_Rec.segment22;
6094:
6095: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
6096: (c_Dist_Rec.segment23 is not null)) then
6097: l_seg_val(l_index) := c_Dist_Rec.segment23;
6098:
6099: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and

Line 6099: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and

6095: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT23') and
6096: (c_Dist_Rec.segment23 is not null)) then
6097: l_seg_val(l_index) := c_Dist_Rec.segment23;
6098:
6099: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
6100: (c_Dist_Rec.segment24 is not null)) then
6101: l_seg_val(l_index) := c_Dist_Rec.segment24;
6102:
6103: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and

Line 6103: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and

6099: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT24') and
6100: (c_Dist_Rec.segment24 is not null)) then
6101: l_seg_val(l_index) := c_Dist_Rec.segment24;
6102:
6103: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
6104: (c_Dist_Rec.segment25 is not null)) then
6105: l_seg_val(l_index) := c_Dist_Rec.segment25;
6106:
6107: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and

Line 6107: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and

6103: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT25') and
6104: (c_Dist_Rec.segment25 is not null)) then
6105: l_seg_val(l_index) := c_Dist_Rec.segment25;
6106:
6107: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
6108: (c_Dist_Rec.segment26 is not null)) then
6109: l_seg_val(l_index) := c_Dist_Rec.segment26;
6110:
6111: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and

Line 6111: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and

6107: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT26') and
6108: (c_Dist_Rec.segment26 is not null)) then
6109: l_seg_val(l_index) := c_Dist_Rec.segment26;
6110:
6111: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
6112: (c_Dist_Rec.segment27 is not null)) then
6113: l_seg_val(l_index) := c_Dist_Rec.segment27;
6114:
6115: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and

Line 6115: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and

6111: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT27') and
6112: (c_Dist_Rec.segment27 is not null)) then
6113: l_seg_val(l_index) := c_Dist_Rec.segment27;
6114:
6115: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
6116: (c_Dist_Rec.segment28 is not null)) then
6117: l_seg_val(l_index) := c_Dist_Rec.segment28;
6118:
6119: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and

Line 6119: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and

6115: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT28') and
6116: (c_Dist_Rec.segment28 is not null)) then
6117: l_seg_val(l_index) := c_Dist_Rec.segment28;
6118:
6119: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
6120: (c_Dist_Rec.segment29 is not null)) then
6121: l_seg_val(l_index) := c_Dist_Rec.segment29;
6122:
6123: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and

Line 6123: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and

6119: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT29') and
6120: (c_Dist_Rec.segment29 is not null)) then
6121: l_seg_val(l_index) := c_Dist_Rec.segment29;
6122:
6123: elsif ((PSB_WS_ACCT1.g_seg_name(l_index) = 'SEGMENT30') and
6124: (c_Dist_Rec.segment30 is not null)) then
6125: l_seg_val(l_index) := c_Dist_Rec.segment30;
6126:
6127: else

Line 6138: n_segments => PSB_WS_ACCT1.g_num_segs,

6134: (application_short_name => 'SQLGL',
6135: key_flex_code => 'GL#',
6136: structure_number => g_flex_code,
6137: validation_date => sysdate,
6138: n_segments => PSB_WS_ACCT1.g_num_segs,
6139: segments => l_seg_val,
6140: combination_id => l_ccid) then
6141:
6142: FND_MSG_PUB.Add;