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_NO_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

Line 773: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);

769: /* (IF (l_holiday_basis = 3) THEN l_holiday_text := 'Y';
770: END IF ; */
771:
772: IF (l_basis_text IS NOT NULL) THEN
773: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
774: END IF;
775:
776: IF (l_holiday_text IS NOT NULL) THEN
777: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);

Line 777: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);

773: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
774: END IF;
775:
776: IF (l_holiday_text IS NOT NULL) THEN
777: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);
778: END IF;
779:
780:
781: -- check if the element definition has already been archived

Line 1573: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);

1569: FETCH csr_hire_date INTO l_hire_date;
1570: CLOSE csr_hire_date;
1571:
1572: /*NATIONALITY*/
1573: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1574:
1575: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1576:
1577: /*Local Unit*/

Line 1635: l_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_primary_address.postal_code);

1631:
1632: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1633:
1634: IF rec_primary_address.style = 'NO' THEN
1635: l_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_primary_address.postal_code);
1636: ELSE
1637: l_postal_code := rec_primary_address.postal_code;
1638: END IF;
1639:

Line 1643: l_emp_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_employer_address.postal_code);

1639:
1640: l_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
1641:
1642: IF rec_employer_address.style = 'NO' THEN
1643: l_emp_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_employer_address.postal_code);
1644: ELSE
1645: l_emp_postal_code := rec_employer_address.postal_code;
1646: END IF;
1647:

Line 2430: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);

2426: CLOSE csr_hol_sub_class ;
2427: */
2428:
2429: IF (l_basis_text IS NOT NULL) THEN
2430: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
2431: END IF;
2432:
2433: IF (l_holiday_text IS NOT NULL) THEN
2434: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);

Line 2434: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);

2430: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
2431: END IF;
2432:
2433: IF (l_holiday_text IS NOT NULL) THEN
2434: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);
2435: END IF;
2436:
2437: -- fnd_file.put_line (fnd_file.LOG,'3: ' || rec_earnings.rep_name ||','|| l_basis_text ||','|| l_holiday_text );
2438:

Line 2662: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);

2658:
2659: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
2660:
2661: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2662: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2663:
2664: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2665: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2666: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);

Line 2664: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);

2660:
2661: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2662: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2663:
2664: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2665: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2666: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2667: l_acc_curr := rec_pers_pay.acc_curr ;
2668:

Line 2665: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);

2661: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2662: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2663:
2664: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2665: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2666: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2667: l_acc_curr := rec_pers_pay.acc_curr ;
2668:
2669:

Line 2666: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);

2662: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2663:
2664: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2665: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2666: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2667: l_acc_curr := rec_pers_pay.acc_curr ;
2668:
2669:
2670: pay_action_information_api.create_action_information (

Line 2806: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)

2802: CURSOR csr_leave_balance
2803: IS
2804: --
2805: SELECT pap.accrual_plan_name
2806: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
2807: ,pap.accrual_units_of_measure
2808: ,ppa.payroll_id
2809: ,pap.business_group_id
2810: ,pap.accrual_plan_id

Line 3191: l_result_value := hr_general.decode_lookup(g_element_table(l_index).lookup_type , l_result_value);

3187: -- check if a lookup was attached to the input value and fetch the meaning
3188:
3189: IF (l_result_value is not null) AND (g_element_table(l_index).lookup_type is not null) THEN
3190:
3191: l_result_value := hr_general.decode_lookup(g_element_table(l_index).lookup_type , l_result_value);
3192:
3193: ELSIF (l_result_value is not null) AND (g_element_table(l_index).value_set_id is not null) THEN
3194:
3195: l_result_value := pay_input_values_pkg.decode_vset_value( g_element_table(l_index).value_set_id ,l_result_value );

Line 3240: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);

3236: CLOSE csr_ele_code ;
3237:
3238: /*
3239: IF (l_ele_code IS NOT NULL) THEN
3240: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);
3241: END IF;
3242: */
3243:
3244: -- fnd_file.put_line(fnd_file.log,'l_ele_code = ' || l_ele_code);

Line 3944: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',

3940: /* Cursor to get the Zone and meaning from UDT and lookup */
3941:
3942: cursor get_code_meaning ( p_municipal_no VARCHAR2, l_eff_date DATE) IS
3943: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')
3944: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
3945: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))
3946: FROM pay_user_tables t
3947: ,pay_user_rows_f r
3948: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'

Line 4047: g_tax_card_tab(1).screen_entry_val := hr_general.decode_lookup('NO_METHOD_OF_RECEIPT',g_tax_card_tab(1).screen_entry_val);

4043:
4044: -- fnd_file.put_line(fnd_file.log,'getting display values for Tax Card');
4045:
4046: -- Getting the display value for Tax Card input values
4047: g_tax_card_tab(1).screen_entry_val := hr_general.decode_lookup('NO_METHOD_OF_RECEIPT',g_tax_card_tab(1).screen_entry_val);
4048: --
4049: OPEN get_code_meaning(g_tax_card_tab(2).screen_entry_val, l_tax_card_effective_date);
4050: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4051: CLOSE get_code_meaning;

Line 4052: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);

4048: --
4049: OPEN get_code_meaning(g_tax_card_tab(2).screen_entry_val, l_tax_card_effective_date);
4050: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4051: CLOSE get_code_meaning;
4052: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4053: --
4054: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4055: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4056: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);

Line 4054: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);

4050: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4051: CLOSE get_code_meaning;
4052: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4053: --
4054: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4055: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4056: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4057: g_tax_card_tab(8).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(8).screen_entry_val)) ; -- Registration Date
4058: g_tax_card_tab(9).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(9).screen_entry_val)) ; -- Date Returned

Line 4055: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);

4051: CLOSE get_code_meaning;
4052: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4053: --
4054: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4055: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4056: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4057: g_tax_card_tab(8).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(8).screen_entry_val)) ; -- Registration Date
4058: g_tax_card_tab(9).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(9).screen_entry_val)) ; -- Date Returned
4059:

Line 4056: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);

4052: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4053: --
4054: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4055: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4056: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4057: g_tax_card_tab(8).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(8).screen_entry_val)) ; -- Registration Date
4058: g_tax_card_tab(9).screen_entry_val := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_tax_card_tab(9).screen_entry_val)) ; -- Date Returned
4059:
4060: -- calculating the Threshold Remaining

Line 4504: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);

4500: CLOSE csr_ele_code ;
4501:
4502: /*
4503: IF (l_ele_code IS NOT NULL) THEN
4504: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);
4505: END IF;
4506: */
4507:
4508: -- fnd_file.put_line(fnd_file.log,'l_ele_code = ' || l_ele_code);

Line 4590: l_earn_period := hr_general.decode_lookup('NO_PAYROLL_PERIOD',l_earn_period) ;

4586:
4587:
4588: IF ( (l_earn_period IS NOT NULL) AND (l_earn_period_mul IS NOT NULL) ) THEN
4589:
4590: l_earn_period := hr_general.decode_lookup('NO_PAYROLL_PERIOD',l_earn_period) ;
4591: hr_utility.set_message (801, 'PAY_376886_NO_TAX_PER_OVERRIDE' );
4592: hr_utility.set_message_token (801, 'EARN_PERIOD', l_earn_period);
4593: hr_utility.set_message_token (801, 'EARN_PER_MUL', l_earn_period_mul);
4594: l_tax_per_override_msg_txt := hr_utility.get_message ;

Line 4634: l_reduced_tax_rule := hr_general.decode_lookup('NO_TAX_PERIOD_RULES',l_reduced_tax_rule) ;

4630:
4631: -- fnd_file.put_line(fnd_file.log,'l_reduced_tax_rule = ' ||l_reduced_tax_rule );
4632:
4633: IF (l_reduced_tax_rule IN ('H','Z')) THEN
4634: l_reduced_tax_rule := hr_general.decode_lookup('NO_TAX_PERIOD_RULES',l_reduced_tax_rule) ;
4635: hr_utility.set_message (801, 'PAY_376887_NO_REDUCED_TAX');
4636: hr_utility.set_message_token (801, 'REDUCED_TAX', l_reduced_tax_rule);
4637: l_reduced_tax_rule_msg_txt := hr_utility.get_message ;
4638: