DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on FND_FLEX_EXT

Line 884: g_flex_delimiter := FND_FLEX_EXT.Get_Delimiter

880: g_constraint_set_name := c_constraint_set_rec.name;
881: g_constraint_threshold := c_constraint_set_rec.constraint_threshold;
882: end loop;
883:
884: g_flex_delimiter := FND_FLEX_EXT.Get_Delimiter
885: (application_short_name => 'SQLGL',
886: key_flex_code => 'GL#',
887: structure_number => g_flex_code);
888:

Line 1029: l_concat_segments := FND_FLEX_EXT.Get_Segs

1025: l_budget_version_id := p_gl_budget_version_id;
1026: end if;
1027:
1028: if l_budget_version_id is null then
1029: l_concat_segments := FND_FLEX_EXT.Get_Segs
1030: ( application_short_name => 'SQLGL',
1031: key_flex_code => 'GL#',
1032: structure_number => g_flex_code,
1033: combination_id => p_code_combination_id ) ;

Line 4517: l_concat_segments := FND_FLEX_EXT.Get_Segs

4513:
4514: if not l_budget_group_found then
4515: begin
4516:
4517: l_concat_segments := FND_FLEX_EXT.Get_Segs
4518: (application_short_name => 'SQLGL',
4519: key_flex_code => 'GL#',
4520: structure_number => g_flex_code,
4521: combination_id => c_Dist_Rec.code_combination_id);

Line 4564: l_concat_segments := FND_FLEX_EXT.Get_Segs

4560:
4561: if not l_budget_group_found then
4562: begin
4563:
4564: l_concat_segments := FND_FLEX_EXT.Get_Segs
4565: (application_short_name => 'SQLGL',
4566: key_flex_code => 'GL#',
4567: structure_number => g_flex_code,
4568: combination_id => c_Dist_Rec.code_combination_id);

Line 5898: l_ccid_val FND_FLEX_EXT.SegmentArray;

5894: p_revision_start_date IN DATE,
5895: p_revision_end_date IN DATE
5896: ) IS
5897:
5898: l_ccid_val FND_FLEX_EXT.SegmentArray;
5899: l_seg_val FND_FLEX_EXT.SegmentArray;
5900: l_ccid NUMBER;
5901:
5902: l_start_date DATE;

Line 5899: l_seg_val FND_FLEX_EXT.SegmentArray;

5895: p_revision_end_date IN DATE
5896: ) IS
5897:
5898: l_ccid_val FND_FLEX_EXT.SegmentArray;
5899: l_seg_val FND_FLEX_EXT.SegmentArray;
5900: l_ccid NUMBER;
5901:
5902: l_start_date DATE;
5903: l_end_date DATE;

Line 5993: if not FND_FLEX_EXT.Get_Segments

5989: l_ccid_val(l_init_index) := null;
5990: l_seg_val(l_init_index) := null;
5991: end loop;
5992:
5993: if not FND_FLEX_EXT.Get_Segments
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,

Line 6133: if not FND_FLEX_EXT.Get_Combination_ID

6129: end if;
6130:
6131: end loop;
6132:
6133: if not FND_FLEX_EXT.Get_Combination_ID
6134: (application_short_name => 'SQLGL',
6135: key_flex_code => 'GL#',
6136: structure_number => g_flex_code,
6137: validation_date => sysdate,

Line 7946: l_concat_segments := FND_FLEX_EXT.Get_Segs

7942: message_token('NAME', p_constraint_name);
7943: else
7944: begin
7945:
7946: l_concat_segments := FND_FLEX_EXT.Get_Segs
7947: (application_short_name => 'SQLGL',
7948: key_flex_code => 'GL#',
7949: structure_number => g_flex_code,
7950: combination_id => p_ccid);

Line 11133: l_seg_apply_cr fnd_flex_ext.SegmentArray;

11129: l_apply_cr NUMBER := 0;
11130: l_apply_dr NUMBER := 0;
11131: l_balance_cr NUMBER := 0;
11132: l_balance_dr NUMBER := 0;
11133: l_seg_apply_cr fnd_flex_ext.SegmentArray;
11134: l_seg_apply_dr fnd_flex_ext.SegmentArray;
11135: l_seg_balance_cr fnd_flex_ext.SegmentArray;
11136: l_seg_balance_dr fnd_flex_ext.SegmentArray;
11137:

Line 11134: l_seg_apply_dr fnd_flex_ext.SegmentArray;

11130: l_apply_dr NUMBER := 0;
11131: l_balance_cr NUMBER := 0;
11132: l_balance_dr NUMBER := 0;
11133: l_seg_apply_cr fnd_flex_ext.SegmentArray;
11134: l_seg_apply_dr fnd_flex_ext.SegmentArray;
11135: l_seg_balance_cr fnd_flex_ext.SegmentArray;
11136: l_seg_balance_dr fnd_flex_ext.SegmentArray;
11137:
11138: l_cnt NUMBER := 0;

Line 11135: l_seg_balance_cr fnd_flex_ext.SegmentArray;

11131: l_balance_cr NUMBER := 0;
11132: l_balance_dr NUMBER := 0;
11133: l_seg_apply_cr fnd_flex_ext.SegmentArray;
11134: l_seg_apply_dr fnd_flex_ext.SegmentArray;
11135: l_seg_balance_cr fnd_flex_ext.SegmentArray;
11136: l_seg_balance_dr fnd_flex_ext.SegmentArray;
11137:
11138: l_cnt NUMBER := 0;
11139: --

Line 11136: l_seg_balance_dr fnd_flex_ext.SegmentArray;

11132: l_balance_dr NUMBER := 0;
11133: l_seg_apply_cr fnd_flex_ext.SegmentArray;
11134: l_seg_apply_dr fnd_flex_ext.SegmentArray;
11135: l_seg_balance_cr fnd_flex_ext.SegmentArray;
11136: l_seg_balance_dr fnd_flex_ext.SegmentArray;
11137:
11138: l_cnt NUMBER := 0;
11139: --
11140: -- CCIDs assigned to the Revision Rule : select CCIDs that also belong to the Budget Group Hierarchy

Line 11487: p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,

11483: p_apply_cr IN OUT NOCOPY NUMBER,
11484: p_apply_dr IN OUT NOCOPY NUMBER,
11485: p_balance_cr IN OUT NOCOPY NUMBER,
11486: p_balance_dr IN OUT NOCOPY NUMBER,
11487: p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11488: p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11489: p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11490: p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11491: p_budget_revision_id IN NUMBER,

Line 11488: p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,

11484: p_apply_dr IN OUT NOCOPY NUMBER,
11485: p_balance_cr IN OUT NOCOPY NUMBER,
11486: p_balance_dr IN OUT NOCOPY NUMBER,
11487: p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11488: p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11489: p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11490: p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11491: p_budget_revision_id IN NUMBER,
11492: p_rule_id IN NUMBER,

Line 11489: p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,

11485: p_balance_cr IN OUT NOCOPY NUMBER,
11486: p_balance_dr IN OUT NOCOPY NUMBER,
11487: p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11488: p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11489: p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11490: p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11491: p_budget_revision_id IN NUMBER,
11492: p_rule_id IN NUMBER,
11493: p_apply_account_set_flag IN VARCHAR2,

Line 11490: p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,

11486: p_balance_dr IN OUT NOCOPY NUMBER,
11487: p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11488: p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11489: p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11490: p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
11491: p_budget_revision_id IN NUMBER,
11492: p_rule_id IN NUMBER,
11493: p_apply_account_set_flag IN VARCHAR2,
11494: p_balance_account_set_flag IN VARCHAR2,

Line 11799: := FND_FLEX_EXT.Get_Segs

11795: -- CP can be set to Warning status.
11796: PSB_BUDGET_REVISIONS_PVT.g_soft_error_flag := 'Y';
11797:
11798: l_concat_segments
11799: := FND_FLEX_EXT.Get_Segs
11800: ( application_short_name => 'SQLGL'
11801: , key_flex_code => 'GL#'
11802: , structure_number => g_flex_code -- Bug#4675858
11803: , combination_id => l_code_combination_id