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 1580: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);

1576: FETCH csr_hire_date INTO l_hire_date;
1577: CLOSE csr_hire_date;
1578:
1579: /*NATIONALITY*/
1580: l_nationality := hr_general.decode_lookup('NATIONALITY',rec_person_details.nationality);
1581:
1582: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 4');*/
1583:
1584: /*Local Unit*/

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

1638:
1639: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1640:
1641: IF rec_primary_address.style = 'NO' THEN
1642: l_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_primary_address.postal_code);
1643: ELSE
1644: l_postal_code := rec_primary_address.postal_code;
1645: END IF;
1646:

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

1646:
1647: l_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
1648:
1649: IF rec_employer_address.style = 'NO' THEN
1650: l_emp_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_employer_address.postal_code);
1651: ELSE
1652: l_emp_postal_code := rec_employer_address.postal_code;
1653: END IF;
1654:

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

2437: CLOSE csr_hol_sub_class ;
2438: */
2439:
2440: IF (l_basis_text IS NOT NULL) THEN
2441: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
2442: END IF;
2443:
2444: IF (l_holiday_text IS NOT NULL) THEN
2445: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);

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

2441: l_basis_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_basis_text);
2442: END IF;
2443:
2444: IF (l_holiday_text IS NOT NULL) THEN
2445: l_holiday_text := hr_general.decode_lookup('NO_REPORT_LABELS',l_holiday_text);
2446: END IF;
2447:
2448: -- fnd_file.put_line (fnd_file.LOG,'3: ' || rec_earnings.rep_name ||','|| l_basis_text ||','|| l_holiday_text );
2449:

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

2669:
2670: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
2671:
2672: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2673: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2674:
2675: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2676: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2677: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);

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

2671:
2672: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2673: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2674:
2675: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2676: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2677: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2678: l_acc_curr := rec_pers_pay.acc_curr ;
2679:

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

2672: -- l_bank_reg_num := rec_pers_pay.bank_reg_num;
2673: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2674:
2675: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2676: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2677: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2678: l_acc_curr := rec_pers_pay.acc_curr ;
2679:
2680:

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

2673: -- l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' || hr_general.decode_lookup('HR_NO_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
2674:
2675: l_bank_name := hr_general.decode_lookup('HR_NO_BANK',rec_pers_pay.bank_name);
2676: l_acc_name := hr_general.decode_lookup('HR_NO_ACCOUNT_NAME',rec_pers_pay.acct_name);
2677: l_acc_type := hr_general.decode_lookup('HR_NO_ACCOUNT_TYPE',rec_pers_pay.acc_type);
2678: l_acc_curr := rec_pers_pay.acc_curr ;
2679:
2680:
2681: pay_action_information_api.create_action_information (

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

2813: CURSOR csr_leave_balance
2814: IS
2815: --
2816: SELECT pap.accrual_plan_name
2817: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
2818: ,pap.accrual_units_of_measure
2819: ,ppa.payroll_id
2820: ,pap.business_group_id
2821: ,pap.accrual_plan_id

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

3198: -- check if a lookup was attached to the input value and fetch the meaning
3199:
3200: IF (l_result_value is not null) AND (g_element_table(l_index).lookup_type is not null) THEN
3201:
3202: l_result_value := hr_general.decode_lookup(g_element_table(l_index).lookup_type , l_result_value);
3203:
3204: ELSIF (l_result_value is not null) AND (g_element_table(l_index).value_set_id is not null) THEN
3205:
3206: l_result_value := pay_input_values_pkg.decode_vset_value( g_element_table(l_index).value_set_id ,l_result_value );

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

3247: CLOSE csr_ele_code ;
3248:
3249: /*
3250: IF (l_ele_code IS NOT NULL) THEN
3251: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);
3252: END IF;
3253: */
3254:
3255: -- fnd_file.put_line(fnd_file.log,'l_ele_code = ' || l_ele_code);

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

3951: /* Cursor to get the Zone and meaning from UDT and lookup */
3952:
3953: cursor get_code_meaning ( p_municipal_no VARCHAR2, l_eff_date DATE) IS
3954: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')
3955: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
3956: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))
3957: FROM pay_user_tables t
3958: ,pay_user_rows_f r
3959: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'

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

4054:
4055: -- fnd_file.put_line(fnd_file.log,'getting display values for Tax Card');
4056:
4057: -- Getting the display value for Tax Card input values
4058: g_tax_card_tab(1).screen_entry_val := hr_general.decode_lookup('NO_METHOD_OF_RECEIPT',g_tax_card_tab(1).screen_entry_val);
4059: --
4060: OPEN get_code_meaning(g_tax_card_tab(2).screen_entry_val, l_tax_card_effective_date);
4061: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4062: CLOSE get_code_meaning;

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

4059: --
4060: OPEN get_code_meaning(g_tax_card_tab(2).screen_entry_val, l_tax_card_effective_date);
4061: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4062: CLOSE get_code_meaning;
4063: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4064: --
4065: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4066: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4067: 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 4065: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);

4061: FETCH get_code_meaning INTO g_tax_card_tab(2).screen_entry_val;
4062: CLOSE get_code_meaning;
4063: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4064: --
4065: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4066: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4067: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4068: 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
4069: 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 4066: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);

4062: CLOSE get_code_meaning;
4063: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4064: --
4065: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4066: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4067: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4068: 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
4069: 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
4070:

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

4063: --g_tax_card_tab(2).screen_entry_val :=hr_general.decode_lookup('NO_TAX_MUNICIPALITY',g_tax_card_tab(2).screen_entry_val);
4064: --
4065: g_tax_card_tab(3).screen_entry_val := hr_general.decode_lookup('NO_TAX_CARD_TYPE',g_tax_card_tab(3).screen_entry_val);
4066: g_tax_card_tab(5).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_NO',g_tax_card_tab(5).screen_entry_val);
4067: g_tax_card_tab(6).screen_entry_val := hr_general.decode_lookup('NO_TAX_TABLE_TYPE',g_tax_card_tab(6).screen_entry_val);
4068: 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
4069: 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
4070:
4071: -- calculating the Threshold Remaining

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

4511: CLOSE csr_ele_code ;
4512:
4513: /*
4514: IF (l_ele_code IS NOT NULL) THEN
4515: l_ele_code := hr_general.decode_lookup('NO_ELEMENT_CODES',l_ele_code);
4516: END IF;
4517: */
4518:
4519: -- fnd_file.put_line(fnd_file.log,'l_ele_code = ' || l_ele_code);

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

4597:
4598:
4599: IF ( (l_earn_period IS NOT NULL) AND (l_earn_period_mul IS NOT NULL) ) THEN
4600:
4601: l_earn_period := hr_general.decode_lookup('NO_PAYROLL_PERIOD',l_earn_period) ;
4602: hr_utility.set_message (801, 'PAY_376886_NO_TAX_PER_OVERRIDE' );
4603: hr_utility.set_message_token (801, 'EARN_PERIOD', l_earn_period);
4604: hr_utility.set_message_token (801, 'EARN_PER_MUL', l_earn_period_mul);
4605: l_tax_per_override_msg_txt := hr_utility.get_message ;

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

4641:
4642: -- fnd_file.put_line(fnd_file.log,'l_reduced_tax_rule = ' ||l_reduced_tax_rule );
4643:
4644: IF (l_reduced_tax_rule IN ('H','Z')) THEN
4645: l_reduced_tax_rule := hr_general.decode_lookup('NO_TAX_PERIOD_RULES',l_reduced_tax_rule) ;
4646: hr_utility.set_message (801, 'PAY_376887_NO_REDUCED_TAX');
4647: hr_utility.set_message_token (801, 'REDUCED_TAX', l_reduced_tax_rule);
4648: l_reduced_tax_rule_msg_txt := hr_utility.get_message ;
4649: