APPS.HR_KFLEX_UTILITY dependencies on HR_API

Line 633: if l_segment_value <> hr_api.g_varchar2

629: --
630: if g_debug then
631: hr_utility.set_location('This is the seg val'||length(l_segment_value),100);
632: end if;
633: if l_segment_value <> hr_api.g_varchar2
634: or l_segment_value is null
635: then
636: --
637: -- Check if the segment value is not set

Line 1026: -- Initailize l_parameter_sorted to hr_api.g_varchar2 to

1022: if l_parameter_temp.count > 0 then
1023: --
1024: -- Create sorted segment array (l_parameter_sorted)
1025: --
1026: -- Initailize l_parameter_sorted to hr_api.g_varchar2 to
1027: -- ensure that no empty cells exist in the segment array
1028: --
1029: for i in 1..30
1030: loop

Line 1031: l_parameter_sorted(i) := hr_api.g_varchar2;

1027: -- ensure that no empty cells exist in the segment array
1028: --
1029: for i in 1..30
1030: loop
1031: l_parameter_sorted(i) := hr_api.g_varchar2;
1032: end loop;
1033: if g_debug then
1034: hr_utility.set_location(l_proc, 30);
1035: end if;

Line 1172: if l_parameter_temp(i) <> hr_api.g_varchar2 then

1168: -- Loop for number of segments on flex combination table
1169: --
1170: for i in 1..30
1171: loop
1172: if l_parameter_temp(i) <> hr_api.g_varchar2 then
1173: --
1174: -- Increase count of populated segments
1175: --
1176: l_no_pop_segments := l_no_pop_segments + 1;

Line 1338: hr_api.mandatory_arg_error

1334: fnd_flex_key_api.set_session_mode('customer_data');
1335: --
1336: -- Check mandatory parameters have been set
1337: --
1338: hr_api.mandatory_arg_error
1339: (p_api_name => l_proc
1340: ,p_argument => 'appl_short_name'
1341: ,p_argument_value => p_appl_short_name
1342: );

Line 1344: hr_api.mandatory_arg_error

1340: ,p_argument => 'appl_short_name'
1341: ,p_argument_value => p_appl_short_name
1342: );
1343: --
1344: hr_api.mandatory_arg_error
1345: (p_api_name => l_proc
1346: ,p_argument => 'flex_code'
1347: ,p_argument_value => p_flex_code
1348: );

Line 1350: hr_api.mandatory_arg_error

1346: ,p_argument => 'flex_code'
1347: ,p_argument_value => p_flex_code
1348: );
1349: --
1350: hr_api.mandatory_arg_error
1351: (p_api_name => l_proc
1352: ,p_argument => 'flex_num'
1353: ,p_argument_value => p_flex_num
1354: );

Line 1542: ,p_segment1 in varchar2 default hr_api.g_varchar2

1538: procedure upd_or_sel_keyflex_comb
1539: (p_appl_short_name in fnd_application.application_short_name%TYPE
1540: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1541: ,p_flex_num in number
1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1543: ,p_segment2 in varchar2 default hr_api.g_varchar2

1539: (p_appl_short_name in fnd_application.application_short_name%TYPE
1540: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1541: ,p_flex_num in number
1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1544: ,p_segment3 in varchar2 default hr_api.g_varchar2

1540: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1541: ,p_flex_num in number
1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1545: ,p_segment4 in varchar2 default hr_api.g_varchar2

1541: ,p_flex_num in number
1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1546: ,p_segment5 in varchar2 default hr_api.g_varchar2

1542: ,p_segment1 in varchar2 default hr_api.g_varchar2
1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1547: ,p_segment6 in varchar2 default hr_api.g_varchar2

1543: ,p_segment2 in varchar2 default hr_api.g_varchar2
1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1548: ,p_segment7 in varchar2 default hr_api.g_varchar2

1544: ,p_segment3 in varchar2 default hr_api.g_varchar2
1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1549: ,p_segment8 in varchar2 default hr_api.g_varchar2

1545: ,p_segment4 in varchar2 default hr_api.g_varchar2
1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1550: ,p_segment9 in varchar2 default hr_api.g_varchar2

1546: ,p_segment5 in varchar2 default hr_api.g_varchar2
1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1551: ,p_segment10 in varchar2 default hr_api.g_varchar2

1547: ,p_segment6 in varchar2 default hr_api.g_varchar2
1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1552: ,p_segment11 in varchar2 default hr_api.g_varchar2

1548: ,p_segment7 in varchar2 default hr_api.g_varchar2
1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1553: ,p_segment12 in varchar2 default hr_api.g_varchar2

1549: ,p_segment8 in varchar2 default hr_api.g_varchar2
1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1554: ,p_segment13 in varchar2 default hr_api.g_varchar2

1550: ,p_segment9 in varchar2 default hr_api.g_varchar2
1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1555: ,p_segment14 in varchar2 default hr_api.g_varchar2

1551: ,p_segment10 in varchar2 default hr_api.g_varchar2
1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1556: ,p_segment15 in varchar2 default hr_api.g_varchar2

1552: ,p_segment11 in varchar2 default hr_api.g_varchar2
1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1557: ,p_segment16 in varchar2 default hr_api.g_varchar2

1553: ,p_segment12 in varchar2 default hr_api.g_varchar2
1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1558: ,p_segment17 in varchar2 default hr_api.g_varchar2

1554: ,p_segment13 in varchar2 default hr_api.g_varchar2
1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1559: ,p_segment18 in varchar2 default hr_api.g_varchar2

1555: ,p_segment14 in varchar2 default hr_api.g_varchar2
1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1560: ,p_segment19 in varchar2 default hr_api.g_varchar2

1556: ,p_segment15 in varchar2 default hr_api.g_varchar2
1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1561: ,p_segment20 in varchar2 default hr_api.g_varchar2

1557: ,p_segment16 in varchar2 default hr_api.g_varchar2
1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1562: ,p_segment21 in varchar2 default hr_api.g_varchar2

1558: ,p_segment17 in varchar2 default hr_api.g_varchar2
1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1563: ,p_segment22 in varchar2 default hr_api.g_varchar2

1559: ,p_segment18 in varchar2 default hr_api.g_varchar2
1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1564: ,p_segment23 in varchar2 default hr_api.g_varchar2

1560: ,p_segment19 in varchar2 default hr_api.g_varchar2
1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1565: ,p_segment24 in varchar2 default hr_api.g_varchar2

1561: ,p_segment20 in varchar2 default hr_api.g_varchar2
1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1566: ,p_segment25 in varchar2 default hr_api.g_varchar2

1562: ,p_segment21 in varchar2 default hr_api.g_varchar2
1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1567: ,p_segment26 in varchar2 default hr_api.g_varchar2

1563: ,p_segment22 in varchar2 default hr_api.g_varchar2
1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2
1571: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1568: ,p_segment27 in varchar2 default hr_api.g_varchar2

1564: ,p_segment23 in varchar2 default hr_api.g_varchar2
1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2
1571: ,p_segment30 in varchar2 default hr_api.g_varchar2
1572: ,p_concat_segments_in in varchar2 default null

Line 1569: ,p_segment28 in varchar2 default hr_api.g_varchar2

1565: ,p_segment24 in varchar2 default hr_api.g_varchar2
1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2
1571: ,p_segment30 in varchar2 default hr_api.g_varchar2
1572: ,p_concat_segments_in in varchar2 default null
1573: ,p_ccid in out nocopy number

Line 1570: ,p_segment29 in varchar2 default hr_api.g_varchar2

1566: ,p_segment25 in varchar2 default hr_api.g_varchar2
1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2
1571: ,p_segment30 in varchar2 default hr_api.g_varchar2
1572: ,p_concat_segments_in in varchar2 default null
1573: ,p_ccid in out nocopy number
1574: ,p_concat_segments_out out nocopy varchar2

Line 1571: ,p_segment30 in varchar2 default hr_api.g_varchar2

1567: ,p_segment26 in varchar2 default hr_api.g_varchar2
1568: ,p_segment27 in varchar2 default hr_api.g_varchar2
1569: ,p_segment28 in varchar2 default hr_api.g_varchar2
1570: ,p_segment29 in varchar2 default hr_api.g_varchar2
1571: ,p_segment30 in varchar2 default hr_api.g_varchar2
1572: ,p_concat_segments_in in varchar2 default null
1573: ,p_ccid in out nocopy number
1574: ,p_concat_segments_out out nocopy varchar2
1575: )

Line 1676: hr_api.mandatory_arg_error

1672: fnd_flex_key_api.set_session_mode('customer_data');
1673: --
1674: -- Check mandatory parameters have been set
1675: --
1676: hr_api.mandatory_arg_error
1677: (p_api_name => l_proc
1678: ,p_argument => 'appl_short_name'
1679: ,p_argument_value => p_appl_short_name
1680: );

Line 1682: hr_api.mandatory_arg_error

1678: ,p_argument => 'appl_short_name'
1679: ,p_argument_value => p_appl_short_name
1680: );
1681: --
1682: hr_api.mandatory_arg_error
1683: (p_api_name => l_proc
1684: ,p_argument => 'flex_code'
1685: ,p_argument_value => p_flex_code
1686: );

Line 1688: hr_api.mandatory_arg_error

1684: ,p_argument => 'flex_code'
1685: ,p_argument_value => p_flex_code
1686: );
1687: --
1688: hr_api.mandatory_arg_error
1689: (p_api_name => l_proc
1690: ,p_argument => 'flex_num'
1691: ,p_argument_value => p_flex_num
1692: );

Line 1717: if (p_concat_segments_in = hr_api.g_varchar2

1713: -- Check to see whether key flex segments as individual parameters
1714: -- have been passed in or a concatenated string of segments
1715: --
1716: if p_ccid is not null then
1717: if (p_concat_segments_in = hr_api.g_varchar2
1718: or p_concat_segments_in is null)
1719: then
1720: --
1721: -- Initialize l_parameter_temp for use within call to

Line 1809: -- the segment array contains the hr_api.g_varchar2 default

1805: hr_utility.set_location(l_proc, 40);
1806: end if;
1807: --
1808: -- Initialize l_parameter_updated so that each cell in
1809: -- the segment array contains the hr_api.g_varchar2 default
1810: --
1811: for i in 1..30
1812: loop
1813: l_parameter_updated(i) := hr_api.g_varchar2;

Line 1813: l_parameter_updated(i) := hr_api.g_varchar2;

1809: -- the segment array contains the hr_api.g_varchar2 default
1810: --
1811: for i in 1..30
1812: loop
1813: l_parameter_updated(i) := hr_api.g_varchar2;
1814: end loop;
1815: --
1816: if g_debug then
1817: hr_utility.set_location(l_proc, 50);

Line 1878: if l_parameter_new(l_seg_num) = hr_api.g_varchar2 then

1874: for i in 1..l_no_segments loop
1875: fetch get_seg_num into l_seg_num;
1876: exit when get_seg_num%NOTFOUND;
1877: --
1878: if l_parameter_new(l_seg_num) = hr_api.g_varchar2 then
1879: --
1880: -- Segment value has not changed - reset to old value
1881: --
1882: l_parameter_updated(l_seg_num) :=

Line 1969: if p_segment1 = hr_api.g_varchar2 then

1965: if g_debug then
1966: hr_utility.set_location(' Seg3 '||p_segment3,101);
1967: end if;
1968: --
1969: if p_segment1 = hr_api.g_varchar2 then
1970: l_segment1 := null;
1971: else
1972: l_segment1 := p_segment1;
1973: end if;

Line 1975: if p_segment2 = hr_api.g_varchar2 then

1971: else
1972: l_segment1 := p_segment1;
1973: end if;
1974:
1975: if p_segment2 = hr_api.g_varchar2 then
1976: l_segment2 := null;
1977: else
1978: l_segment2 := p_segment2;
1979: end if;

Line 1981: if p_segment3 = hr_api.g_varchar2 then

1977: else
1978: l_segment2 := p_segment2;
1979: end if;
1980:
1981: if p_segment3 = hr_api.g_varchar2 then
1982: l_segment3 := null;
1983: else
1984: l_segment3 := p_segment3;
1985: end if;

Line 1987: if p_segment4 = hr_api.g_varchar2 then

1983: else
1984: l_segment3 := p_segment3;
1985: end if;
1986:
1987: if p_segment4 = hr_api.g_varchar2 then
1988: l_segment4 := null;
1989: else
1990: l_segment4 := p_segment4;
1991: end if;

Line 1993: if p_segment5 = hr_api.g_varchar2 then

1989: else
1990: l_segment4 := p_segment4;
1991: end if;
1992:
1993: if p_segment5 = hr_api.g_varchar2 then
1994: l_segment5 := null;
1995: else
1996: l_segment5 := p_segment5;
1997: end if;

Line 1999: if p_segment6 = hr_api.g_varchar2 then

1995: else
1996: l_segment5 := p_segment5;
1997: end if;
1998:
1999: if p_segment6 = hr_api.g_varchar2 then
2000: l_segment6 := null;
2001: else
2002: l_segment6 := p_segment6;
2003: end if;

Line 2005: if p_segment7 = hr_api.g_varchar2 then

2001: else
2002: l_segment6 := p_segment6;
2003: end if;
2004:
2005: if p_segment7 = hr_api.g_varchar2 then
2006: l_segment7 := null;
2007: else
2008: l_segment7 := p_segment7;
2009: end if;

Line 2011: if p_segment8 = hr_api.g_varchar2 then

2007: else
2008: l_segment7 := p_segment7;
2009: end if;
2010:
2011: if p_segment8 = hr_api.g_varchar2 then
2012: l_segment8 := null;
2013: else
2014: l_segment8 := p_segment8;
2015: end if;

Line 2017: if p_segment9 = hr_api.g_varchar2 then

2013: else
2014: l_segment8 := p_segment8;
2015: end if;
2016:
2017: if p_segment9 = hr_api.g_varchar2 then
2018: l_segment9 := null;
2019: else
2020: l_segment9 := p_segment9;
2021: end if;

Line 2023: if p_segment10 = hr_api.g_varchar2 then

2019: else
2020: l_segment9 := p_segment9;
2021: end if;
2022:
2023: if p_segment10 = hr_api.g_varchar2 then
2024: l_segment10 := null;
2025: else
2026: l_segment10 := p_segment10;
2027: end if;

Line 2029: if p_segment11 = hr_api.g_varchar2 then

2025: else
2026: l_segment10 := p_segment10;
2027: end if;
2028:
2029: if p_segment11 = hr_api.g_varchar2 then
2030: l_segment11 := null;
2031: else
2032: l_segment11 := p_segment11;
2033: end if;

Line 2035: if p_segment12 = hr_api.g_varchar2 then

2031: else
2032: l_segment11 := p_segment11;
2033: end if;
2034:
2035: if p_segment12 = hr_api.g_varchar2 then
2036: l_segment12 := null;
2037: else
2038: l_segment12 := p_segment12;
2039: end if;

Line 2041: if p_segment13 = hr_api.g_varchar2 then

2037: else
2038: l_segment12 := p_segment12;
2039: end if;
2040:
2041: if p_segment13 = hr_api.g_varchar2 then
2042: l_segment13 := null;
2043: else
2044: l_segment13 := p_segment13;
2045: end if;

Line 2047: if p_segment14 = hr_api.g_varchar2 then

2043: else
2044: l_segment13 := p_segment13;
2045: end if;
2046:
2047: if p_segment14 = hr_api.g_varchar2 then
2048: l_segment14 := null;
2049: else
2050: l_segment14 := p_segment14;
2051: end if;

Line 2053: if p_segment15 = hr_api.g_varchar2 then

2049: else
2050: l_segment14 := p_segment14;
2051: end if;
2052:
2053: if p_segment15 = hr_api.g_varchar2 then
2054: l_segment15 := null;
2055: else
2056: l_segment15 := p_segment15;
2057: end if;

Line 2059: if p_segment16 = hr_api.g_varchar2 then

2055: else
2056: l_segment15 := p_segment15;
2057: end if;
2058:
2059: if p_segment16 = hr_api.g_varchar2 then
2060: l_segment16 := null;
2061: else
2062: l_segment16 := p_segment16;
2063: end if;

Line 2065: if p_segment17 = hr_api.g_varchar2 then

2061: else
2062: l_segment16 := p_segment16;
2063: end if;
2064:
2065: if p_segment17 = hr_api.g_varchar2 then
2066: l_segment17 := null;
2067: else
2068: l_segment17 := p_segment17;
2069: end if;

Line 2071: if p_segment18 = hr_api.g_varchar2 then

2067: else
2068: l_segment17 := p_segment17;
2069: end if;
2070:
2071: if p_segment18 = hr_api.g_varchar2 then
2072: l_segment18 := null;
2073: else
2074: l_segment18 := p_segment18;
2075: end if;

Line 2077: if p_segment19 = hr_api.g_varchar2 then

2073: else
2074: l_segment18 := p_segment18;
2075: end if;
2076:
2077: if p_segment19 = hr_api.g_varchar2 then
2078: l_segment19 := null;
2079: else
2080: l_segment19 := p_segment19;
2081: end if;

Line 2083: if p_segment20 = hr_api.g_varchar2 then

2079: else
2080: l_segment19 := p_segment19;
2081: end if;
2082:
2083: if p_segment20 = hr_api.g_varchar2 then
2084: l_segment20:= null;
2085: else
2086: l_segment20 := p_segment20;
2087: end if;

Line 2089: if p_segment21 = hr_api.g_varchar2 then

2085: else
2086: l_segment20 := p_segment20;
2087: end if;
2088:
2089: if p_segment21 = hr_api.g_varchar2 then
2090: l_segment21 := null;
2091: else
2092: l_segment21 := p_segment21;
2093: end if;

Line 2095: if p_segment22 = hr_api.g_varchar2 then

2091: else
2092: l_segment21 := p_segment21;
2093: end if;
2094:
2095: if p_segment22 = hr_api.g_varchar2 then
2096: l_segment22 := null;
2097: else
2098: l_segment22 := p_segment22;
2099: end if;

Line 2101: if p_segment23 = hr_api.g_varchar2 then

2097: else
2098: l_segment22 := p_segment22;
2099: end if;
2100:
2101: if p_segment23 = hr_api.g_varchar2 then
2102: l_segment23 := null;
2103: else
2104: l_segment23 := p_segment23;
2105: end if;

Line 2107: if p_segment24 = hr_api.g_varchar2 then

2103: else
2104: l_segment23 := p_segment23;
2105: end if;
2106:
2107: if p_segment24 = hr_api.g_varchar2 then
2108: l_segment24 := null;
2109: else
2110: l_segment24 := p_segment24;
2111: end if;

Line 2113: if p_segment25 = hr_api.g_varchar2 then

2109: else
2110: l_segment24 := p_segment24;
2111: end if;
2112:
2113: if p_segment25 = hr_api.g_varchar2 then
2114: l_segment25 := null;
2115: else
2116: l_segment25 := p_segment25;
2117: end if;

Line 2119: if p_segment26 = hr_api.g_varchar2 then

2115: else
2116: l_segment25 := p_segment25;
2117: end if;
2118:
2119: if p_segment26 = hr_api.g_varchar2 then
2120: l_segment26 := null;
2121: else
2122: l_segment26 := p_segment26;
2123: end if;

Line 2125: if p_segment27 = hr_api.g_varchar2 then

2121: else
2122: l_segment26 := p_segment26;
2123: end if;
2124:
2125: if p_segment27 = hr_api.g_varchar2 then
2126: l_segment27 := null;
2127: else
2128: l_segment27 := p_segment27;
2129: end if;

Line 2131: if p_segment28 = hr_api.g_varchar2 then

2127: else
2128: l_segment27 := p_segment27;
2129: end if;
2130:
2131: if p_segment28 = hr_api.g_varchar2 then
2132: l_segment28 := null;
2133: else
2134: l_segment28 := p_segment28;
2135: end if;

Line 2137: if p_segment29 = hr_api.g_varchar2 then

2133: else
2134: l_segment28 := p_segment28;
2135: end if;
2136:
2137: if p_segment29 = hr_api.g_varchar2 then
2138: l_segment29 := null;
2139: else
2140: l_segment29 := p_segment29;
2141: end if;

Line 2143: if p_segment30 = hr_api.g_varchar2 then

2139: else
2140: l_segment29 := p_segment29;
2141: end if;
2142:
2143: if p_segment30 = hr_api.g_varchar2 then
2144: l_segment30 := null;
2145: else
2146: l_segment30 := p_segment30;
2147: end if;

Line 2149: if p_concat_segments_in = hr_api.g_varchar2 then

2145: else
2146: l_segment30 := p_segment30;
2147: end if;
2148:
2149: if p_concat_segments_in = hr_api.g_varchar2 then
2150: l_concat_segments_in := null;
2151: else
2152: l_concat_segments_in := p_concat_segments_in;
2153: end if;

Line 2233: (p_business_group_id in per_all_assignments_f.business_group_id%type default hr_api.g_number

2229: -- |------------------------------- set_profiles -----------------------------|
2230: -- ----------------------------------------------------------------------------
2231: --
2232: procedure set_profiles
2233: (p_business_group_id in per_all_assignments_f.business_group_id%type default hr_api.g_number
2234: ,p_assignment_id in per_all_assignments_f.assignment_id%type default null
2235: ,p_organization_id in per_all_assignments_f.organization_id%type default null
2236: ,p_location_id in per_all_assignments_f.location_id%type default null
2237: ,p_person_id in per_all_assignments_f.person_id%type default null

Line 2255: if nvl(p_business_group_id,-1) <> hr_api.g_number then

2251: if g_debug then
2252: hr_utility.set_location(l_proc,10);
2253: end if;
2254: --
2255: if nvl(p_business_group_id,-1) <> hr_api.g_number then
2256: fnd_profile.put('PER_BUSINESS_GROUP_ID',p_business_group_id);
2257: if g_debug then
2258: hr_utility.set_location(l_proc,20);
2259: end if;