APPS.HR_SCL_FLEX dependencies on HR_SCL_SHD

Line 916: -- we need to populate the hr_scl_shd.g_rec_type for use by the validation

912: close lcsel;
913: --
914: if (l_legislation_code = 'US') then
915: --
916: -- we need to populate the hr_scl_shd.g_rec_type for use by the validation
917: -- processes.
918: -- note: the hr_scl_shd.api_updating function will ensure the
919: -- soft_coding_keyflex_id is valid and exists.
920: -- if the function returns a false the soft_coding_keyflex_id must

Line 918: -- note: the hr_scl_shd.api_updating function will ensure the

914: if (l_legislation_code = 'US') then
915: --
916: -- we need to populate the hr_scl_shd.g_rec_type for use by the validation
917: -- processes.
918: -- note: the hr_scl_shd.api_updating function will ensure the
919: -- soft_coding_keyflex_id is valid and exists.
920: -- if the function returns a false the soft_coding_keyflex_id must
921: -- be null. therefore, no validation processing is required.
922: --

Line 923: if hr_scl_shd.api_updating

919: -- soft_coding_keyflex_id is valid and exists.
920: -- if the function returns a false the soft_coding_keyflex_id must
921: -- be null. therefore, no validation processing is required.
922: --
923: if hr_scl_shd.api_updating
924: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id) then
925: --
926: -- SEGMENT1
927: --

Line 928: chk_us_segment1(p_segment1 => hr_scl_shd.g_old_rec.segment1

924: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id) then
925: --
926: -- SEGMENT1
927: --
928: chk_us_segment1(p_segment1 => hr_scl_shd.g_old_rec.segment1
929: ,p_business_group_id => p_rec.business_group_id);
930: --
931: hr_utility.set_location(l_proc, 15);
932: --

Line 935: chk_us_segment2(p_segment2 => hr_scl_shd.g_old_rec.segment2

931: hr_utility.set_location(l_proc, 15);
932: --
933: -- SEGMENT2
934: --
935: chk_us_segment2(p_segment2 => hr_scl_shd.g_old_rec.segment2
936: ,p_business_group_id => p_rec.business_group_id
937: ,p_validation_start_date => p_validation_start_date
938: ,p_validation_end_date => p_validation_end_date );
939: --

Line 944: chk_us_segment3(p_segment3 => hr_scl_shd.g_old_rec.segment3);

940: hr_utility.set_location(l_proc, 20);
941: --
942: -- SEGMENT3
943: --
944: chk_us_segment3(p_segment3 => hr_scl_shd.g_old_rec.segment3);
945: --
946: hr_utility.set_location(l_proc, 25);
947: --
948: -- SEGMENT4

Line 950: chk_us_segment4(p_segment4 => hr_scl_shd.g_old_rec.segment4

946: hr_utility.set_location(l_proc, 25);
947: --
948: -- SEGMENT4
949: --
950: chk_us_segment4(p_segment4 => hr_scl_shd.g_old_rec.segment4
951: ,p_organization_id => p_rec.organization_id);
952: --
953: hr_utility.set_location(l_proc, 30);
954: --

Line 957: chk_us_segment5(p_segment5 => hr_scl_shd.g_old_rec.segment5);

953: hr_utility.set_location(l_proc, 30);
954: --
955: -- SEGMENT5
956: --
957: chk_us_segment5(p_segment5 => hr_scl_shd.g_old_rec.segment5);
958: --
959: hr_utility.set_location(l_proc, 35);
960: --
961: -- SEGMENT6

Line 963: chk_us_segment6(p_segment6 => hr_scl_shd.g_old_rec.segment6);

959: hr_utility.set_location(l_proc, 35);
960: --
961: -- SEGMENT6
962: --
963: chk_us_segment6(p_segment6 => hr_scl_shd.g_old_rec.segment6);
964: --
965: hr_utility.set_location(l_proc, 40);
966: --
967: -- SEGMENT7

Line 969: chk_us_segment7(p_segment7 => hr_scl_shd.g_old_rec.segment7);

965: hr_utility.set_location(l_proc, 40);
966: --
967: -- SEGMENT7
968: --
969: chk_us_segment7(p_segment7 => hr_scl_shd.g_old_rec.segment7);
970: --
971: hr_utility.set_location(l_proc, 45);
972: --
973: -- SEGMENT8

Line 984: chk_us_segment8(p_segment8 => hr_scl_shd.g_old_rec.segment8

980: (p_assignment_id => p_rec.assignment_id
981: ,p_effective_date => p_validation_start_date
982: ,p_object_version_number => p_rec.object_version_number) then
983: --
984: chk_us_segment8(p_segment8 => hr_scl_shd.g_old_rec.segment8
985: ,p_segment1 => hr_scl_shd.g_old_rec.segment1
986: ,p_location_id => p_rec.location_id
987: ,p_assignment_id => p_rec.assignment_id );
988: else

Line 985: ,p_segment1 => hr_scl_shd.g_old_rec.segment1

981: ,p_effective_date => p_validation_start_date
982: ,p_object_version_number => p_rec.object_version_number) then
983: --
984: chk_us_segment8(p_segment8 => hr_scl_shd.g_old_rec.segment8
985: ,p_segment1 => hr_scl_shd.g_old_rec.segment1
986: ,p_location_id => p_rec.location_id
987: ,p_assignment_id => p_rec.assignment_id );
988: else
989: if hr_scl_shd.g_old_rec.segment8 is not null then

Line 989: if hr_scl_shd.g_old_rec.segment8 is not null then

985: ,p_segment1 => hr_scl_shd.g_old_rec.segment1
986: ,p_location_id => p_rec.location_id
987: ,p_assignment_id => p_rec.assignment_id );
988: else
989: if hr_scl_shd.g_old_rec.segment8 is not null then
990: hr_utility.set_message(801,'HR_50013_SCL_WORKERS_OVERRIDE');
991: hr_utility.raise_error;
992: end if;
993: end if;

Line 999: chk_us_segment9(p_segment9 => hr_scl_shd.g_old_rec.segment9

995: hr_utility.set_location(l_proc, 50);
996: --
997: -- SEGMENT9
998: --
999: chk_us_segment9(p_segment9 => hr_scl_shd.g_old_rec.segment9
1000: ,p_business_group_id => p_rec.business_group_id);
1001: --
1002: hr_utility.set_location(l_proc, 55);
1003: --

Line 1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10

1002: hr_utility.set_location(l_proc, 55);
1003: --
1004: -- SEGMENT10 to 30
1005: --
1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10
1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14

Line 1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11

1003: --
1004: -- SEGMENT10 to 30
1005: --
1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10
1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15

Line 1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12

1004: -- SEGMENT10 to 30
1005: --
1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10
1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16

Line 1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13

1005: --
1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10
1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17

Line 1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14

1006: chk_us_segment10_30(p_segment10 => hr_scl_shd.g_old_rec.segment10
1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18

Line 1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15

1007: ,p_segment11 => hr_scl_shd.g_old_rec.segment11
1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19

Line 1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16

1008: ,p_segment12 => hr_scl_shd.g_old_rec.segment12
1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20

Line 1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17

1009: ,p_segment13 => hr_scl_shd.g_old_rec.segment13
1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21

Line 1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18

1010: ,p_segment14 => hr_scl_shd.g_old_rec.segment14
1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22

Line 1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19

1011: ,p_segment15 => hr_scl_shd.g_old_rec.segment15
1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23

Line 1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20

1012: ,p_segment16 => hr_scl_shd.g_old_rec.segment16
1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24

Line 1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21

1013: ,p_segment17 => hr_scl_shd.g_old_rec.segment17
1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25

Line 1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22

1014: ,p_segment18 => hr_scl_shd.g_old_rec.segment18
1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26

Line 1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23

1015: ,p_segment19 => hr_scl_shd.g_old_rec.segment19
1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27

Line 1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24

1016: ,p_segment20 => hr_scl_shd.g_old_rec.segment20
1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28

Line 1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25

1017: ,p_segment21 => hr_scl_shd.g_old_rec.segment21
1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29

Line 1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26

1018: ,p_segment22 => hr_scl_shd.g_old_rec.segment22
1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29
1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );

Line 1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27

1019: ,p_segment23 => hr_scl_shd.g_old_rec.segment23
1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29
1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );
1027: --

Line 1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28

1020: ,p_segment24 => hr_scl_shd.g_old_rec.segment24
1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29
1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );
1027: --
1028: hr_utility.set_location(l_proc, 60);

Line 1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29

1021: ,p_segment25 => hr_scl_shd.g_old_rec.segment25
1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29
1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );
1027: --
1028: hr_utility.set_location(l_proc, 60);
1029:

Line 1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );

1022: ,p_segment26 => hr_scl_shd.g_old_rec.segment26
1023: ,p_segment27 => hr_scl_shd.g_old_rec.segment27
1024: ,p_segment28 => hr_scl_shd.g_old_rec.segment28
1025: ,p_segment29 => hr_scl_shd.g_old_rec.segment29
1026: ,p_segment30 => hr_scl_shd.g_old_rec.segment30 );
1027: --
1028: hr_utility.set_location(l_proc, 60);
1029:
1030: else

Line 1049: if hr_scl_shd.api_updating

1045: -- Need to populate g_old_rec to access the data.
1046: -- (The record has previously been inserted by
1047: -- hr_scl_ins.insert_dml)
1048: --
1049: if hr_scl_shd.api_updating
1050: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id) then
1051: --
1052: hr_kflex_utility.ins_or_sel_keyflex_comb
1053: (p_appl_short_name => 'PER',

Line 1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,

1051: --
1052: hr_kflex_utility.ins_or_sel_keyflex_comb
1053: (p_appl_short_name => 'PER',
1054: p_flex_code => 'SCL',
1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,
1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,

Line 1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,

1052: hr_kflex_utility.ins_or_sel_keyflex_comb
1053: (p_appl_short_name => 'PER',
1054: p_flex_code => 'SCL',
1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,
1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,

Line 1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,

1053: (p_appl_short_name => 'PER',
1054: p_flex_code => 'SCL',
1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,
1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,

Line 1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,

1054: p_flex_code => 'SCL',
1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,
1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,

Line 1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,

1055: p_flex_num => hr_scl_shd.g_old_rec.id_flex_num,
1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,

Line 1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,

1056: p_segment1 => hr_scl_shd.g_old_rec.segment1,
1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,

Line 1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,

1057: p_segment2 => hr_scl_shd.g_old_rec.segment2,
1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,

Line 1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,

1058: p_segment3 => hr_scl_shd.g_old_rec.segment3,
1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,

Line 1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,

1059: p_segment4 => hr_scl_shd.g_old_rec.segment4,
1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,

Line 1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,

1060: p_segment5 => hr_scl_shd.g_old_rec.segment5,
1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,

Line 1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,

1061: p_segment6 => hr_scl_shd.g_old_rec.segment6,
1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,

Line 1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,

1062: p_segment7 => hr_scl_shd.g_old_rec.segment7,
1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,

Line 1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,

1063: p_segment8 => hr_scl_shd.g_old_rec.segment8,
1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,

Line 1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,

1064: p_segment9 => hr_scl_shd.g_old_rec.segment9,
1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,

Line 1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,

1065: p_segment10 => hr_scl_shd.g_old_rec.segment10,
1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,

Line 1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,

1066: p_segment11 => hr_scl_shd.g_old_rec.segment11,
1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,

Line 1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,

1067: p_segment12 => hr_scl_shd.g_old_rec.segment12,
1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,

Line 1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,

1068: p_segment13 => hr_scl_shd.g_old_rec.segment13,
1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,

Line 1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,

1069: p_segment14 => hr_scl_shd.g_old_rec.segment14,
1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,

Line 1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,

1070: p_segment15 => hr_scl_shd.g_old_rec.segment15,
1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,

Line 1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,

1071: p_segment16 => hr_scl_shd.g_old_rec.segment16,
1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,

Line 1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,

1072: p_segment17 => hr_scl_shd.g_old_rec.segment17,
1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,

Line 1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,

1073: p_segment18 => hr_scl_shd.g_old_rec.segment18,
1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,

Line 1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,

1074: p_segment19 => hr_scl_shd.g_old_rec.segment19,
1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,

Line 1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,

1075: p_segment20 => hr_scl_shd.g_old_rec.segment20,
1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,

Line 1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,

1076: p_segment21 => hr_scl_shd.g_old_rec.segment21,
1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,

Line 1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,

1077: p_segment22 => hr_scl_shd.g_old_rec.segment22,
1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,
1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,

Line 1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,

1078: p_segment23 => hr_scl_shd.g_old_rec.segment23,
1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,
1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,
1086: p_concat_segments_in => null,

Line 1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,

1079: p_segment24 => hr_scl_shd.g_old_rec.segment24,
1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,
1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,
1086: p_concat_segments_in => null,
1087: p_ccid => l_cagr_grade_def_id,

Line 1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,

1080: p_segment25 => hr_scl_shd.g_old_rec.segment25,
1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,
1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,
1086: p_concat_segments_in => null,
1087: p_ccid => l_cagr_grade_def_id,
1088: p_concat_segments_out => l_concat_segments_out );

Line 1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,

1081: p_segment26 => hr_scl_shd.g_old_rec.segment26,
1082: p_segment27 => hr_scl_shd.g_old_rec.segment27,
1083: p_segment28 => hr_scl_shd.g_old_rec.segment28,
1084: p_segment29 => hr_scl_shd.g_old_rec.segment29,
1085: p_segment30 => hr_scl_shd.g_old_rec.segment30,
1086: p_concat_segments_in => null,
1087: p_ccid => l_cagr_grade_def_id,
1088: p_concat_segments_out => l_concat_segments_out );
1089: --