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_SOE_GLB dependencies on PAY_SOE_UTIL

Line 818: pay_soe_util.clear;

814: ,p_defined_balance_lst => l_defined_balance_lst
815: ,p_context_lst => l_context_lst
816: ,p_output_table => l_output_table);
817: --
818: pay_soe_util.clear;
819: --
820: balCount := 0;
821: if l_output_table.count > 0 then
822: --

Line 831: pay_soe_util.setValue('01'

827: for i in l_output_table.first..l_output_table.last loop
828: if l_output_table(i).balance_value <> 0 then
829: balCount := balCount + 1;
830: --
831: pay_soe_util.setValue('01'
832: ,l_balance_type_lst(l_output_table(i).defined_balance_id).balance_name
833: ,TRUE,FALSE);
834: pay_soe_util.setValue('02'
835: ,l_balance_type_lst(l_output_table(i).defined_balance_id).reporting_name

Line 834: pay_soe_util.setValue('02'

830: --
831: pay_soe_util.setValue('01'
832: ,l_balance_type_lst(l_output_table(i).defined_balance_id).balance_name
833: ,TRUE,FALSE);
834: pay_soe_util.setValue('02'
835: ,l_balance_type_lst(l_output_table(i).defined_balance_id).reporting_name
836: ,FALSE,FALSE);
837: pay_soe_util.setValue('03'
838: ,l_balance_type_lst(l_output_table(i).defined_balance_id).dimension_name

Line 837: pay_soe_util.setValue('03'

833: ,TRUE,FALSE);
834: pay_soe_util.setValue('02'
835: ,l_balance_type_lst(l_output_table(i).defined_balance_id).reporting_name
836: ,FALSE,FALSE);
837: pay_soe_util.setValue('03'
838: ,l_balance_type_lst(l_output_table(i).defined_balance_id).dimension_name
839: ,FALSE,FALSE);
840: pay_soe_util.setValue('04'
841: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name

Line 840: pay_soe_util.setValue('04'

836: ,FALSE,FALSE);
837: pay_soe_util.setValue('03'
838: ,l_balance_type_lst(l_output_table(i).defined_balance_id).dimension_name
839: ,FALSE,FALSE);
840: pay_soe_util.setValue('04'
841: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
842: ,FALSE,FALSE);
843: pay_soe_util.setValue('05',
844: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))

Line 843: pay_soe_util.setValue('05',

839: ,FALSE,FALSE);
840: pay_soe_util.setValue('04'
841: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
842: ,FALSE,FALSE);
843: pay_soe_util.setValue('05',
844: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
845: ,FALSE,FALSE);
846: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
847:

Line 846: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);

842: ,FALSE,FALSE);
843: pay_soe_util.setValue('05',
844: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
845: ,FALSE,FALSE);
846: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
847:
848:
849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);

Line 849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);

845: ,FALSE,FALSE);
846: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
847:
848:
849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);
851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);

Line 850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);

846: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
847:
848:
849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);
851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:

Line 851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);

847:
848:
849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);
851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,

Line 852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);

848:
849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);
851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
856: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);

Line 853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);

849: pay_soe_util.setValue('07',l_output_table(i).jurisdiction_code,FALSE,FALSE);
850: pay_soe_util.setValue('08',l_output_table(i).source_id,FALSE,FALSE);
851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
856: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);
857: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);

Line 855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,

851: pay_soe_util.setValue('09',l_output_table(i).source_text,FALSE,FALSE);
852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
856: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);
857: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
858:
859: end if;

Line 857: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);

853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
856: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);
857: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
858:
859: end if;
860: end loop;
861: end if;

Line 864: return pay_soe_util.genCursor;

860: end loop;
861: end if;
862: --
863: if balCount > 0 then
864: return pay_soe_util.genCursor;
865: else
866: --
867: -- Bugfix 5724212
868: -- Return null since we are not fetching any rows.

Line 967: ,pay_soe_util.getBankDetails('':legislation_code''

963: begin
964: l_sql :=
965: 'select ORG_PAYMENT_METHOD_NAME COL01
966: ,pt.payment_type_name COL04
967: ,pay_soe_util.getBankDetails('':legislation_code''
968: ,ppm.external_account_id
969: ,''BANK_NAME''
970: ,null) COL02
971: ,pay_soe_util.getBankDetails('':legislation_code''

Line 971: ,pay_soe_util.getBankDetails('':legislation_code''

967: ,pay_soe_util.getBankDetails('':legislation_code''
968: ,ppm.external_account_id
969: ,''BANK_NAME''
970: ,null) COL02
971: ,pay_soe_util.getBankDetails('':legislation_code''
972: ,ppm.external_account_id
973: ,''BANK_ACCOUNT_NUMBER''
974: ,fnd_profile.value(''HR_MASK_CHARACTERS'')) COL03
975: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

Line 1020: ,pay_soe_util.getConfig('ELEMENTS1'));

1016: function Elements1(p_assignment_action_id number) return long is
1017: begin
1018: hr_utility.trace('Entering elements1');
1019: return getElements(p_assignment_action_id
1020: ,pay_soe_util.getConfig('ELEMENTS1'));
1021: hr_utility.trace('Leaving Elements1');
1022: end Elements1;
1023: --
1024: /* ---------------------------------------------------------------------

Line 1033: ,pay_soe_util.getConfig('ELEMENTS2'));

1029: ------------------------------------------------------------------------ */
1030: function Elements2(p_assignment_action_id number) return long is
1031: begin
1032: return getElements(p_assignment_action_id
1033: ,pay_soe_util.getConfig('ELEMENTS2'));
1034: end Elements2;
1035: --
1036: /* ---------------------------------------------------------------------
1037: Function : SetParameters

Line 1045: ,pay_soe_util.getConfig('ELEMENTS3'));

1041: ------------------------------------------------------------------------ */
1042: function Elements3(p_assignment_action_id number) return long is
1043: begin
1044: return getElements(p_assignment_action_id
1045: ,pay_soe_util.getConfig('ELEMENTS3'));
1046: end Elements3;
1047: --
1048: /* ---------------------------------------------------------------------
1049: Function : SetParameters

Line 1057: ,pay_soe_util.getConfig('ELEMENTS4'));

1053: ------------------------------------------------------------------------ */
1054: function Elements4(p_assignment_action_id number) return long is
1055: begin
1056: return getElements(p_assignment_action_id
1057: ,pay_soe_util.getConfig('ELEMENTS4'));
1058: end Elements4;
1059: --
1060: /* ---------------------------------------------------------------------
1061: Function : SetParameters

Line 1069: ,pay_soe_util.getConfig('ELEMENTS5'));

1065: ------------------------------------------------------------------------ */
1066: function Elements5(p_assignment_action_id number) return long is
1067: begin
1068: return getElements(p_assignment_action_id
1069: ,pay_soe_util.getConfig('ELEMENTS5'));
1070: end Elements5;
1071: --
1072: /* ---------------------------------------------------------------------
1073: Function : SetParameters

Line 1081: ,pay_soe_util.getConfig('ELEMENTS6'));

1077: ------------------------------------------------------------------------ */
1078: function Elements6(p_assignment_action_id number) return long is
1079: begin
1080: return getElements(p_assignment_action_id
1081: ,pay_soe_util.getConfig('ELEMENTS6'));
1082: end Elements6;
1083: --
1084: /* ---------------------------------------------------------------------
1085: Function : SetParameters

Line 1094: ,pay_soe_util.getConfig('INFORMATION1'));

1090: function Information1(p_assignment_action_id number) return long is
1091: begin
1092: hr_utility.trace('in Information1');
1093: return getInformation(p_assignment_action_id
1094: ,pay_soe_util.getConfig('INFORMATION1'));
1095: end Information1;
1096: --
1097: /* ---------------------------------------------------------------------
1098: Function : Balances1

Line 1105: ,pay_soe_util.getConfig('BALANCES1'));

1101: ------------------------------------------------------------------------ */
1102: function Balances1(p_assignment_action_id number) return long is
1103: begin
1104: return getBalances(p_assignment_action_id
1105: ,pay_soe_util.getConfig('BALANCES1'));
1106: end Balances1;
1107: --
1108: /* ---------------------------------------------------------------------
1109: Function : Balances2

Line 1116: ,pay_soe_util.getConfig('BALANCES2'));

1112: ------------------------------------------------------------------------ */
1113: function Balances2(p_assignment_action_id number) return long is
1114: begin
1115: return getBalances(p_assignment_action_id
1116: ,pay_soe_util.getConfig('BALANCES2'));
1117: end Balances2;
1118: --
1119: /* ---------------------------------------------------------------------
1120: Function : Balances3

Line 1127: ,pay_soe_util.getConfig('BALANCES3'));

1123: ------------------------------------------------------------------------ */
1124: function Balances3(p_assignment_action_id number) return long is
1125: begin
1126: return getBalances(p_assignment_action_id
1127: ,pay_soe_util.getConfig('BALANCES3'));
1128: end Balances3;
1129: --
1130: ---------------------------------------------------------------------------
1131: -- Function : get_retro_period, taken from pynlgenr.pkb