APPS.HR_KFLEX_UTILITY dependencies on HR_API

Line 632: if l_segment_value <> hr_api.g_varchar2

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

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

1013: if l_parameter_temp.count > 0 then
1014: --
1015: -- Create sorted segment array (l_parameter_sorted)
1016: --
1017: -- Initailize l_parameter_sorted to hr_api.g_varchar2 to
1018: -- ensure that no empty cells exist in the segment array
1019: --
1020: for i in 1..30
1021: loop

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

1018: -- ensure that no empty cells exist in the segment array
1019: --
1020: for i in 1..30
1021: loop
1022: l_parameter_sorted(i) := hr_api.g_varchar2;
1023: end loop;
1024: if g_debug then
1025: hr_utility.set_location(l_proc, 30);
1026: end if;

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

1159: -- Loop for number of segments on flex combination table
1160: --
1161: for i in 1..30
1162: loop
1163: if l_parameter_temp(i) <> hr_api.g_varchar2 then
1164: --
1165: -- Increase count of populated segments
1166: --
1167: l_no_pop_segments := l_no_pop_segments + 1;

Line 1329: hr_api.mandatory_arg_error

1325: fnd_flex_key_api.set_session_mode('customer_data');
1326: --
1327: -- Check mandatory parameters have been set
1328: --
1329: hr_api.mandatory_arg_error
1330: (p_api_name => l_proc
1331: ,p_argument => 'appl_short_name'
1332: ,p_argument_value => p_appl_short_name
1333: );

Line 1335: hr_api.mandatory_arg_error

1331: ,p_argument => 'appl_short_name'
1332: ,p_argument_value => p_appl_short_name
1333: );
1334: --
1335: hr_api.mandatory_arg_error
1336: (p_api_name => l_proc
1337: ,p_argument => 'flex_code'
1338: ,p_argument_value => p_flex_code
1339: );

Line 1341: hr_api.mandatory_arg_error

1337: ,p_argument => 'flex_code'
1338: ,p_argument_value => p_flex_code
1339: );
1340: --
1341: hr_api.mandatory_arg_error
1342: (p_api_name => l_proc
1343: ,p_argument => 'flex_num'
1344: ,p_argument_value => p_flex_num
1345: );

Line 1533: ,p_segment1 in varchar2 default hr_api.g_varchar2

1529: procedure upd_or_sel_keyflex_comb
1530: (p_appl_short_name in fnd_application.application_short_name%TYPE
1531: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1532: ,p_flex_num in number
1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1534: ,p_segment2 in varchar2 default hr_api.g_varchar2

1530: (p_appl_short_name in fnd_application.application_short_name%TYPE
1531: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1532: ,p_flex_num in number
1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1535: ,p_segment3 in varchar2 default hr_api.g_varchar2

1531: ,p_flex_code in fnd_id_flex_segments.id_flex_code%TYPE
1532: ,p_flex_num in number
1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1536: ,p_segment4 in varchar2 default hr_api.g_varchar2

1532: ,p_flex_num in number
1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1537: ,p_segment5 in varchar2 default hr_api.g_varchar2

1533: ,p_segment1 in varchar2 default hr_api.g_varchar2
1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1538: ,p_segment6 in varchar2 default hr_api.g_varchar2

1534: ,p_segment2 in varchar2 default hr_api.g_varchar2
1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1539: ,p_segment7 in varchar2 default hr_api.g_varchar2

1535: ,p_segment3 in varchar2 default hr_api.g_varchar2
1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1540: ,p_segment8 in varchar2 default hr_api.g_varchar2

1536: ,p_segment4 in varchar2 default hr_api.g_varchar2
1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1541: ,p_segment9 in varchar2 default hr_api.g_varchar2

1537: ,p_segment5 in varchar2 default hr_api.g_varchar2
1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1542: ,p_segment10 in varchar2 default hr_api.g_varchar2

1538: ,p_segment6 in varchar2 default hr_api.g_varchar2
1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1543: ,p_segment11 in varchar2 default hr_api.g_varchar2

1539: ,p_segment7 in varchar2 default hr_api.g_varchar2
1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1544: ,p_segment12 in varchar2 default hr_api.g_varchar2

1540: ,p_segment8 in varchar2 default hr_api.g_varchar2
1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1545: ,p_segment13 in varchar2 default hr_api.g_varchar2

1541: ,p_segment9 in varchar2 default hr_api.g_varchar2
1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1546: ,p_segment14 in varchar2 default hr_api.g_varchar2

1542: ,p_segment10 in varchar2 default hr_api.g_varchar2
1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1547: ,p_segment15 in varchar2 default hr_api.g_varchar2

1543: ,p_segment11 in varchar2 default hr_api.g_varchar2
1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1548: ,p_segment16 in varchar2 default hr_api.g_varchar2

1544: ,p_segment12 in varchar2 default hr_api.g_varchar2
1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1549: ,p_segment17 in varchar2 default hr_api.g_varchar2

1545: ,p_segment13 in varchar2 default hr_api.g_varchar2
1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1550: ,p_segment18 in varchar2 default hr_api.g_varchar2

1546: ,p_segment14 in varchar2 default hr_api.g_varchar2
1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1551: ,p_segment19 in varchar2 default hr_api.g_varchar2

1547: ,p_segment15 in varchar2 default hr_api.g_varchar2
1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1552: ,p_segment20 in varchar2 default hr_api.g_varchar2

1548: ,p_segment16 in varchar2 default hr_api.g_varchar2
1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1553: ,p_segment21 in varchar2 default hr_api.g_varchar2

1549: ,p_segment17 in varchar2 default hr_api.g_varchar2
1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1554: ,p_segment22 in varchar2 default hr_api.g_varchar2

1550: ,p_segment18 in varchar2 default hr_api.g_varchar2
1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1555: ,p_segment23 in varchar2 default hr_api.g_varchar2

1551: ,p_segment19 in varchar2 default hr_api.g_varchar2
1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1556: ,p_segment24 in varchar2 default hr_api.g_varchar2

1552: ,p_segment20 in varchar2 default hr_api.g_varchar2
1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1557: ,p_segment25 in varchar2 default hr_api.g_varchar2

1553: ,p_segment21 in varchar2 default hr_api.g_varchar2
1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1558: ,p_segment26 in varchar2 default hr_api.g_varchar2

1554: ,p_segment22 in varchar2 default hr_api.g_varchar2
1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2
1562: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1559: ,p_segment27 in varchar2 default hr_api.g_varchar2

1555: ,p_segment23 in varchar2 default hr_api.g_varchar2
1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2
1562: ,p_segment30 in varchar2 default hr_api.g_varchar2
1563: ,p_concat_segments_in in varchar2 default null

Line 1560: ,p_segment28 in varchar2 default hr_api.g_varchar2

1556: ,p_segment24 in varchar2 default hr_api.g_varchar2
1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2
1562: ,p_segment30 in varchar2 default hr_api.g_varchar2
1563: ,p_concat_segments_in in varchar2 default null
1564: ,p_ccid in out nocopy number

Line 1561: ,p_segment29 in varchar2 default hr_api.g_varchar2

1557: ,p_segment25 in varchar2 default hr_api.g_varchar2
1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2
1562: ,p_segment30 in varchar2 default hr_api.g_varchar2
1563: ,p_concat_segments_in in varchar2 default null
1564: ,p_ccid in out nocopy number
1565: ,p_concat_segments_out out nocopy varchar2

Line 1562: ,p_segment30 in varchar2 default hr_api.g_varchar2

1558: ,p_segment26 in varchar2 default hr_api.g_varchar2
1559: ,p_segment27 in varchar2 default hr_api.g_varchar2
1560: ,p_segment28 in varchar2 default hr_api.g_varchar2
1561: ,p_segment29 in varchar2 default hr_api.g_varchar2
1562: ,p_segment30 in varchar2 default hr_api.g_varchar2
1563: ,p_concat_segments_in in varchar2 default null
1564: ,p_ccid in out nocopy number
1565: ,p_concat_segments_out out nocopy varchar2
1566: )

Line 1667: hr_api.mandatory_arg_error

1663: fnd_flex_key_api.set_session_mode('customer_data');
1664: --
1665: -- Check mandatory parameters have been set
1666: --
1667: hr_api.mandatory_arg_error
1668: (p_api_name => l_proc
1669: ,p_argument => 'appl_short_name'
1670: ,p_argument_value => p_appl_short_name
1671: );

Line 1673: hr_api.mandatory_arg_error

1669: ,p_argument => 'appl_short_name'
1670: ,p_argument_value => p_appl_short_name
1671: );
1672: --
1673: hr_api.mandatory_arg_error
1674: (p_api_name => l_proc
1675: ,p_argument => 'flex_code'
1676: ,p_argument_value => p_flex_code
1677: );

Line 1679: hr_api.mandatory_arg_error

1675: ,p_argument => 'flex_code'
1676: ,p_argument_value => p_flex_code
1677: );
1678: --
1679: hr_api.mandatory_arg_error
1680: (p_api_name => l_proc
1681: ,p_argument => 'flex_num'
1682: ,p_argument_value => p_flex_num
1683: );

Line 1708: if (p_concat_segments_in = hr_api.g_varchar2

1704: -- Check to see whether key flex segments as individual parameters
1705: -- have been passed in or a concatenated string of segments
1706: --
1707: if p_ccid is not null then
1708: if (p_concat_segments_in = hr_api.g_varchar2
1709: or p_concat_segments_in is null)
1710: then
1711: --
1712: -- Initialize l_parameter_temp for use within call to

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

1796: hr_utility.set_location(l_proc, 40);
1797: end if;
1798: --
1799: -- Initialize l_parameter_updated so that each cell in
1800: -- the segment array contains the hr_api.g_varchar2 default
1801: --
1802: for i in 1..30
1803: loop
1804: l_parameter_updated(i) := hr_api.g_varchar2;

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

1800: -- the segment array contains the hr_api.g_varchar2 default
1801: --
1802: for i in 1..30
1803: loop
1804: l_parameter_updated(i) := hr_api.g_varchar2;
1805: end loop;
1806: --
1807: if g_debug then
1808: hr_utility.set_location(l_proc, 50);

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

1865: for i in 1..l_no_segments loop
1866: fetch get_seg_num into l_seg_num;
1867: exit when get_seg_num%NOTFOUND;
1868: --
1869: if l_parameter_new(l_seg_num) = hr_api.g_varchar2 then
1870: --
1871: -- Segment value has not changed - reset to old value
1872: --
1873: l_parameter_updated(l_seg_num) :=

Line 1960: if p_segment1 = hr_api.g_varchar2 then

1956: if g_debug then
1957: hr_utility.set_location(' Seg3 '||p_segment3,101);
1958: end if;
1959: --
1960: if p_segment1 = hr_api.g_varchar2 then
1961: l_segment1 := null;
1962: else
1963: l_segment1 := p_segment1;
1964: end if;

Line 1966: if p_segment2 = hr_api.g_varchar2 then

1962: else
1963: l_segment1 := p_segment1;
1964: end if;
1965:
1966: if p_segment2 = hr_api.g_varchar2 then
1967: l_segment2 := null;
1968: else
1969: l_segment2 := p_segment2;
1970: end if;

Line 1972: if p_segment3 = hr_api.g_varchar2 then

1968: else
1969: l_segment2 := p_segment2;
1970: end if;
1971:
1972: if p_segment3 = hr_api.g_varchar2 then
1973: l_segment3 := null;
1974: else
1975: l_segment3 := p_segment3;
1976: end if;

Line 1978: if p_segment4 = hr_api.g_varchar2 then

1974: else
1975: l_segment3 := p_segment3;
1976: end if;
1977:
1978: if p_segment4 = hr_api.g_varchar2 then
1979: l_segment4 := null;
1980: else
1981: l_segment4 := p_segment4;
1982: end if;

Line 1984: if p_segment5 = hr_api.g_varchar2 then

1980: else
1981: l_segment4 := p_segment4;
1982: end if;
1983:
1984: if p_segment5 = hr_api.g_varchar2 then
1985: l_segment5 := null;
1986: else
1987: l_segment5 := p_segment5;
1988: end if;

Line 1990: if p_segment6 = hr_api.g_varchar2 then

1986: else
1987: l_segment5 := p_segment5;
1988: end if;
1989:
1990: if p_segment6 = hr_api.g_varchar2 then
1991: l_segment6 := null;
1992: else
1993: l_segment6 := p_segment6;
1994: end if;

Line 1996: if p_segment7 = hr_api.g_varchar2 then

1992: else
1993: l_segment6 := p_segment6;
1994: end if;
1995:
1996: if p_segment7 = hr_api.g_varchar2 then
1997: l_segment7 := null;
1998: else
1999: l_segment7 := p_segment7;
2000: end if;

Line 2002: if p_segment8 = hr_api.g_varchar2 then

1998: else
1999: l_segment7 := p_segment7;
2000: end if;
2001:
2002: if p_segment8 = hr_api.g_varchar2 then
2003: l_segment8 := null;
2004: else
2005: l_segment8 := p_segment8;
2006: end if;

Line 2008: if p_segment9 = hr_api.g_varchar2 then

2004: else
2005: l_segment8 := p_segment8;
2006: end if;
2007:
2008: if p_segment9 = hr_api.g_varchar2 then
2009: l_segment9 := null;
2010: else
2011: l_segment9 := p_segment9;
2012: end if;

Line 2014: if p_segment10 = hr_api.g_varchar2 then

2010: else
2011: l_segment9 := p_segment9;
2012: end if;
2013:
2014: if p_segment10 = hr_api.g_varchar2 then
2015: l_segment10 := null;
2016: else
2017: l_segment10 := p_segment10;
2018: end if;

Line 2020: if p_segment11 = hr_api.g_varchar2 then

2016: else
2017: l_segment10 := p_segment10;
2018: end if;
2019:
2020: if p_segment11 = hr_api.g_varchar2 then
2021: l_segment11 := null;
2022: else
2023: l_segment11 := p_segment11;
2024: end if;

Line 2026: if p_segment12 = hr_api.g_varchar2 then

2022: else
2023: l_segment11 := p_segment11;
2024: end if;
2025:
2026: if p_segment12 = hr_api.g_varchar2 then
2027: l_segment12 := null;
2028: else
2029: l_segment12 := p_segment12;
2030: end if;

Line 2032: if p_segment13 = hr_api.g_varchar2 then

2028: else
2029: l_segment12 := p_segment12;
2030: end if;
2031:
2032: if p_segment13 = hr_api.g_varchar2 then
2033: l_segment13 := null;
2034: else
2035: l_segment13 := p_segment13;
2036: end if;

Line 2038: if p_segment14 = hr_api.g_varchar2 then

2034: else
2035: l_segment13 := p_segment13;
2036: end if;
2037:
2038: if p_segment14 = hr_api.g_varchar2 then
2039: l_segment14 := null;
2040: else
2041: l_segment14 := p_segment14;
2042: end if;

Line 2044: if p_segment15 = hr_api.g_varchar2 then

2040: else
2041: l_segment14 := p_segment14;
2042: end if;
2043:
2044: if p_segment15 = hr_api.g_varchar2 then
2045: l_segment15 := null;
2046: else
2047: l_segment15 := p_segment15;
2048: end if;

Line 2050: if p_segment16 = hr_api.g_varchar2 then

2046: else
2047: l_segment15 := p_segment15;
2048: end if;
2049:
2050: if p_segment16 = hr_api.g_varchar2 then
2051: l_segment16 := null;
2052: else
2053: l_segment16 := p_segment16;
2054: end if;

Line 2056: if p_segment17 = hr_api.g_varchar2 then

2052: else
2053: l_segment16 := p_segment16;
2054: end if;
2055:
2056: if p_segment17 = hr_api.g_varchar2 then
2057: l_segment17 := null;
2058: else
2059: l_segment17 := p_segment17;
2060: end if;

Line 2062: if p_segment18 = hr_api.g_varchar2 then

2058: else
2059: l_segment17 := p_segment17;
2060: end if;
2061:
2062: if p_segment18 = hr_api.g_varchar2 then
2063: l_segment18 := null;
2064: else
2065: l_segment18 := p_segment18;
2066: end if;

Line 2068: if p_segment19 = hr_api.g_varchar2 then

2064: else
2065: l_segment18 := p_segment18;
2066: end if;
2067:
2068: if p_segment19 = hr_api.g_varchar2 then
2069: l_segment19 := null;
2070: else
2071: l_segment19 := p_segment19;
2072: end if;

Line 2074: if p_segment20 = hr_api.g_varchar2 then

2070: else
2071: l_segment19 := p_segment19;
2072: end if;
2073:
2074: if p_segment20 = hr_api.g_varchar2 then
2075: l_segment20:= null;
2076: else
2077: l_segment20 := p_segment20;
2078: end if;

Line 2080: if p_segment21 = hr_api.g_varchar2 then

2076: else
2077: l_segment20 := p_segment20;
2078: end if;
2079:
2080: if p_segment21 = hr_api.g_varchar2 then
2081: l_segment21 := null;
2082: else
2083: l_segment21 := p_segment21;
2084: end if;

Line 2086: if p_segment22 = hr_api.g_varchar2 then

2082: else
2083: l_segment21 := p_segment21;
2084: end if;
2085:
2086: if p_segment22 = hr_api.g_varchar2 then
2087: l_segment22 := null;
2088: else
2089: l_segment22 := p_segment22;
2090: end if;

Line 2092: if p_segment23 = hr_api.g_varchar2 then

2088: else
2089: l_segment22 := p_segment22;
2090: end if;
2091:
2092: if p_segment23 = hr_api.g_varchar2 then
2093: l_segment23 := null;
2094: else
2095: l_segment23 := p_segment23;
2096: end if;

Line 2098: if p_segment24 = hr_api.g_varchar2 then

2094: else
2095: l_segment23 := p_segment23;
2096: end if;
2097:
2098: if p_segment24 = hr_api.g_varchar2 then
2099: l_segment24 := null;
2100: else
2101: l_segment24 := p_segment24;
2102: end if;

Line 2104: if p_segment25 = hr_api.g_varchar2 then

2100: else
2101: l_segment24 := p_segment24;
2102: end if;
2103:
2104: if p_segment25 = hr_api.g_varchar2 then
2105: l_segment25 := null;
2106: else
2107: l_segment25 := p_segment25;
2108: end if;

Line 2110: if p_segment26 = hr_api.g_varchar2 then

2106: else
2107: l_segment25 := p_segment25;
2108: end if;
2109:
2110: if p_segment26 = hr_api.g_varchar2 then
2111: l_segment26 := null;
2112: else
2113: l_segment26 := p_segment26;
2114: end if;

Line 2116: if p_segment27 = hr_api.g_varchar2 then

2112: else
2113: l_segment26 := p_segment26;
2114: end if;
2115:
2116: if p_segment27 = hr_api.g_varchar2 then
2117: l_segment27 := null;
2118: else
2119: l_segment27 := p_segment27;
2120: end if;

Line 2122: if p_segment28 = hr_api.g_varchar2 then

2118: else
2119: l_segment27 := p_segment27;
2120: end if;
2121:
2122: if p_segment28 = hr_api.g_varchar2 then
2123: l_segment28 := null;
2124: else
2125: l_segment28 := p_segment28;
2126: end if;

Line 2128: if p_segment29 = hr_api.g_varchar2 then

2124: else
2125: l_segment28 := p_segment28;
2126: end if;
2127:
2128: if p_segment29 = hr_api.g_varchar2 then
2129: l_segment29 := null;
2130: else
2131: l_segment29 := p_segment29;
2132: end if;

Line 2134: if p_segment30 = hr_api.g_varchar2 then

2130: else
2131: l_segment29 := p_segment29;
2132: end if;
2133:
2134: if p_segment30 = hr_api.g_varchar2 then
2135: l_segment30 := null;
2136: else
2137: l_segment30 := p_segment30;
2138: end if;

Line 2140: if p_concat_segments_in = hr_api.g_varchar2 then

2136: else
2137: l_segment30 := p_segment30;
2138: end if;
2139:
2140: if p_concat_segments_in = hr_api.g_varchar2 then
2141: l_concat_segments_in := null;
2142: else
2143: l_concat_segments_in := p_concat_segments_in;
2144: end if;

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

2220: -- |------------------------------- set_profiles -----------------------------|
2221: -- ----------------------------------------------------------------------------
2222: --
2223: procedure set_profiles
2224: (p_business_group_id in per_all_assignments_f.business_group_id%type default hr_api.g_number
2225: ,p_assignment_id in per_all_assignments_f.assignment_id%type default null
2226: ,p_organization_id in per_all_assignments_f.organization_id%type default null
2227: ,p_location_id in per_all_assignments_f.location_id%type default null
2228: ) is

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

2241: if g_debug then
2242: hr_utility.set_location(l_proc,10);
2243: end if;
2244: --
2245: if nvl(p_business_group_id,-1) <> hr_api.g_number then
2246: fnd_profile.put('PER_BUSINESS_GROUP_ID',p_business_group_id);
2247: if g_debug then
2248: hr_utility.set_location(l_proc,20);
2249: end if;