eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_ARCHIVE

Line 858: l_context_no := pay_archive.g_context_values.sz;

854: if g_debug then
855: hr_utility.trace('Start of archive_data');
856: end if;
857:
858: l_context_no := pay_archive.g_context_values.sz;
859: for i in 1..l_context_no loop
860: pay_archive.g_context_values.name(i) := NULL;
861: pay_archive.g_context_values.value(i) := NULL;
862: end loop;

Line 860: pay_archive.g_context_values.name(i) := NULL;

856: end if;
857:
858: l_context_no := pay_archive.g_context_values.sz;
859: for i in 1..l_context_no loop
860: pay_archive.g_context_values.name(i) := NULL;
861: pay_archive.g_context_values.value(i) := NULL;
862: end loop;
863: pay_archive.g_context_values.sz := 0;
864: --

Line 861: pay_archive.g_context_values.value(i) := NULL;

857:
858: l_context_no := pay_archive.g_context_values.sz;
859: for i in 1..l_context_no loop
860: pay_archive.g_context_values.name(i) := NULL;
861: pay_archive.g_context_values.value(i) := NULL;
862: end loop;
863: pay_archive.g_context_values.sz := 0;
864: --
865: open csr_context;

Line 863: pay_archive.g_context_values.sz := 0;

859: for i in 1..l_context_no loop
860: pay_archive.g_context_values.name(i) := NULL;
861: pay_archive.g_context_values.value(i) := NULL;
862: end loop;
863: pay_archive.g_context_values.sz := 0;
864: --
865: open csr_context;
866: fetch csr_context into
867: l_business_group_id,

Line 881: pay_archive.g_context_values.name(cnt) := 'BUSINESS_GROUP_ID';

877: -- Set Context for DB Item
878: --
879: if l_business_group_id is not null then
880: cnt := cnt + 1;
881: pay_archive.g_context_values.name(cnt) := 'BUSINESS_GROUP_ID';
882: pay_archive.g_context_values.value(cnt) := l_business_group_id;
883: end if;
884: --
885: if l_payroll_id is not null then

Line 882: pay_archive.g_context_values.value(cnt) := l_business_group_id;

878: --
879: if l_business_group_id is not null then
880: cnt := cnt + 1;
881: pay_archive.g_context_values.name(cnt) := 'BUSINESS_GROUP_ID';
882: pay_archive.g_context_values.value(cnt) := l_business_group_id;
883: end if;
884: --
885: if l_payroll_id is not null then
886: cnt := cnt + 1;

Line 887: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ID';

883: end if;
884: --
885: if l_payroll_id is not null then
886: cnt := cnt + 1;
887: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ID';
888: pay_archive.g_context_values.value(cnt) := l_payroll_id;
889: end if;
890: --
891: if l_payroll_action_id is not null then

Line 888: pay_archive.g_context_values.value(cnt) := l_payroll_id;

884: --
885: if l_payroll_id is not null then
886: cnt := cnt + 1;
887: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ID';
888: pay_archive.g_context_values.value(cnt) := l_payroll_id;
889: end if;
890: --
891: if l_payroll_action_id is not null then
892: cnt := cnt + 1;

Line 893: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ACTION_ID';

889: end if;
890: --
891: if l_payroll_action_id is not null then
892: cnt := cnt + 1;
893: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ACTION_ID';
894: pay_archive.g_context_values.value(cnt) := l_payroll_action_id;
895: end if;
896: --
897: if l_assignment_id is not null then

Line 894: pay_archive.g_context_values.value(cnt) := l_payroll_action_id;

890: --
891: if l_payroll_action_id is not null then
892: cnt := cnt + 1;
893: pay_archive.g_context_values.name(cnt) := 'PAYROLL_ACTION_ID';
894: pay_archive.g_context_values.value(cnt) := l_payroll_action_id;
895: end if;
896: --
897: if l_assignment_id is not null then
898: cnt := cnt + 1;

Line 899: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ID';

895: end if;
896: --
897: if l_assignment_id is not null then
898: cnt := cnt + 1;
899: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ID';
900: pay_archive.g_context_values.value(cnt) := l_assignment_id;
901: end if;
902: --
903: if l_assignment_action_id is not null then

Line 900: pay_archive.g_context_values.value(cnt) := l_assignment_id;

896: --
897: if l_assignment_id is not null then
898: cnt := cnt + 1;
899: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ID';
900: pay_archive.g_context_values.value(cnt) := l_assignment_id;
901: end if;
902: --
903: if l_assignment_action_id is not null then
904: cnt := cnt + 1;

Line 905: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ACTION_ID';

901: end if;
902: --
903: if l_assignment_action_id is not null then
904: cnt := cnt + 1;
905: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ACTION_ID';
906: pay_archive.g_context_values.value(cnt) := l_assignment_action_id;
907: -- Set Assignment Action id to get Balance
908: pay_archive.balance_aa := l_assignment_action_id;
909: pay_archive.archive_aa := l_assignment_action_id;

Line 906: pay_archive.g_context_values.value(cnt) := l_assignment_action_id;

902: --
903: if l_assignment_action_id is not null then
904: cnt := cnt + 1;
905: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ACTION_ID';
906: pay_archive.g_context_values.value(cnt) := l_assignment_action_id;
907: -- Set Assignment Action id to get Balance
908: pay_archive.balance_aa := l_assignment_action_id;
909: pay_archive.archive_aa := l_assignment_action_id;
910: end if;

Line 908: pay_archive.balance_aa := l_assignment_action_id;

904: cnt := cnt + 1;
905: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ACTION_ID';
906: pay_archive.g_context_values.value(cnt) := l_assignment_action_id;
907: -- Set Assignment Action id to get Balance
908: pay_archive.balance_aa := l_assignment_action_id;
909: pay_archive.archive_aa := l_assignment_action_id;
910: end if;
911: --
912: if l_date_earned is not null then

Line 909: pay_archive.archive_aa := l_assignment_action_id;

905: pay_archive.g_context_values.name(cnt) := 'ASSIGNMENT_ACTION_ID';
906: pay_archive.g_context_values.value(cnt) := l_assignment_action_id;
907: -- Set Assignment Action id to get Balance
908: pay_archive.balance_aa := l_assignment_action_id;
909: pay_archive.archive_aa := l_assignment_action_id;
910: end if;
911: --
912: if l_date_earned is not null then
913: cnt := cnt + 1;

Line 914: pay_archive.g_context_values.name(cnt) := 'DATE_EARNED';

910: end if;
911: --
912: if l_date_earned is not null then
913: cnt := cnt + 1;
914: pay_archive.g_context_values.name(cnt) := 'DATE_EARNED';
915: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);
916: end if;
917: --
918: if l_tax_unit_id is not null then

Line 915: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);

911: --
912: if l_date_earned is not null then
913: cnt := cnt + 1;
914: pay_archive.g_context_values.name(cnt) := 'DATE_EARNED';
915: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);
916: end if;
917: --
918: if l_tax_unit_id is not null then
919: cnt := cnt + 1;

Line 920: pay_archive.g_context_values.name(cnt) := 'TAX_UNIT_ID';

916: end if;
917: --
918: if l_tax_unit_id is not null then
919: cnt := cnt + 1;
920: pay_archive.g_context_values.name(cnt) := 'TAX_UNIT_ID';
921: pay_archive.g_context_values.value(cnt) := l_tax_unit_id;
922: end if;
923: --
924: -- This value is used in pay_archive.archive_dbi

Line 921: pay_archive.g_context_values.value(cnt) := l_tax_unit_id;

917: --
918: if l_tax_unit_id is not null then
919: cnt := cnt + 1;
920: pay_archive.g_context_values.name(cnt) := 'TAX_UNIT_ID';
921: pay_archive.g_context_values.value(cnt) := l_tax_unit_id;
922: end if;
923: --
924: -- This value is used in pay_archive.archive_dbi
925: pay_archive.g_context_values.sz := cnt;

Line 924: -- This value is used in pay_archive.archive_dbi

920: pay_archive.g_context_values.name(cnt) := 'TAX_UNIT_ID';
921: pay_archive.g_context_values.value(cnt) := l_tax_unit_id;
922: end if;
923: --
924: -- This value is used in pay_archive.archive_dbi
925: pay_archive.g_context_values.sz := cnt;
926: --
927: --
928: --

Line 925: pay_archive.g_context_values.sz := cnt;

921: pay_archive.g_context_values.value(cnt) := l_tax_unit_id;
922: end if;
923: --
924: -- This value is used in pay_archive.archive_dbi
925: pay_archive.g_context_values.sz := cnt;
926: --
927: --
928: --
929: if g_debug then