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_IN_TAX_DECLARATION dependencies on PER_ASSIGNMENTS_F

Line 116: -- IN : p_assignment_id per_assignments_f.assignment_id --

112: -- the flag stating if the employee tax declaration --
113: -- details have been approved or not. . --
114: -- --
115: -- Parameters : --
116: -- IN : p_assignment_id per_assignments_f.assignment_id --
117: -- p_tax_year VARCHAR2 --
118: -- p_extra_info_id assignment_extra_info_id --
119: -- RETURN : VARCHAR2 --
120: -- --

Line 123: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

119: -- RETURN : VARCHAR2 --
120: -- --
121: --------------------------------------------------------------------------
122: FUNCTION get_approval_status
123: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
124: ,p_tax_year IN VARCHAR2
125: ,p_extra_info_id OUT NOCOPY per_assignment_extra_info.assignment_extra_info_id%TYPE)
126: RETURN VARCHAR2;
127:

Line 155: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

151: -- entries's input value on a date which is before the --
152: -- freeze date for the financial year. --
153: -- --
154: -- Parameters : --
155: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
156: -- p_actual_value VARCHAR2 --
157: -- p_ele_entry_id element_entry_id%TYPE --
158: -- p_input_value_id input_value_id%TYPE --
159: -- RETURN : VARCHAR2 --

Line 163: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

159: -- RETURN : VARCHAR2 --
160: -- --
161: --------------------------------------------------------------------------
162: FUNCTION get_planned_value
163: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
164: ,p_actual_value IN VARCHAR2
165: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE
166: ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)
167: RETURN VARCHAR2;

Line 265: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

261: -- Description : The procedure is responsible for storing the detials--
262: -- in 'House Rent Information' element. --
263: -- --
264: -- Parameters : --
265: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
266: -- p_apr NUMBER --
267: -- p_may NUMBER --
268: -- p_jun NUMBER --
269: -- p_jul NUMBER --

Line 283: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

279: -- OUT : p_warnings BOOLEAN --
280: -- --
281: --------------------------------------------------------------------------
282: PROCEDURE declare_house_rent
283: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
284: ,p_apr IN NUMBER
285: ,p_may IN NUMBER
286: ,p_jun IN NUMBER
287: ,p_jul IN NUMBER

Line 309: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

305: -- disability 80u and then stores the detials in the --
306: -- 'Deductions under Chapter VI A' element. --
307: -- --
308: -- Parameters : --
309: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
310: -- p_pension_fund_80ccc NUMBER --
311: -- p_medical_insurance_prem_80d NUMBER --
312: -- p_sec_80ddb_senior_citizen VARCHAR2 --
313: -- p_disease_treatment_80ddb NUMBER --

Line 325: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

321: -- OUT : p_warnings BOOLEAN --
322: -- --
323: --------------------------------------------------------------------------
324: PROCEDURE declare_chapter6a
325: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
326: ,p_pension_fund_80ccc IN NUMBER
327: ,p_medical_insurance_prem_80d IN NUMBER
328: ,p_sec_80ddb_senior_citizen IN VARCHAR2
329: ,p_disease_treatment_80ddb IN NUMBER

Line 348: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

344: -- Description : The procedure is responsible for storing the detials--
345: -- in 'Rebates under Section 88' element. --
346: -- --
347: -- Parameters : --
348: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
349: -- p_public_provident_fund NUMBER --
350: -- p_post_office_savings_scheme NUMBER --
351: -- p_deposit_in_nsc_vi_issue NUMBER --
352: -- p_deposit_in_nsc_viii_issue NUMBER --

Line 368: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

364: -- OUT : p_warnings BOOLEAN --
365: -- --
366: --------------------------------------------------------------------------
367: PROCEDURE declare_section88
368: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
369: ,p_deferred_annuity IN NUMBER
370: ,p_senior_citizen_sav_scheme IN NUMBER
371: ,p_public_provident_fund IN NUMBER
372: ,p_post_office_savings_scheme IN NUMBER

Line 397: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

393: -- Description : The procedure is responsible for storing the --
394: -- detials in 'Other Income' element. --
395: -- --
396: -- Parameters : --
397: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
398: -- p_income_from_house_property NUMBER --
399: -- p_profit_and_gain_from_busines NUMBER --
400: -- p_long_term_capital_gain NUMBER --
401: -- p_short_term_capital_gain NUMBER --

Line 410: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

406: -- OUT : p_warnings BOOLEAN --
407: -- --
408: --------------------------------------------------------------------------
409: PROCEDURE declare_other_income
410: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
411: ,p_income_from_house_property IN NUMBER
412: ,p_profit_and_gain_from_busines IN NUMBER
413: ,p_long_term_capital_gain IN NUMBER
414: ,p_short_term_capital_gain IN NUMBER

Line 430: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

426: -- Description : The procedure is responsible for storing the --
427: -- detials in 'Deduction under Section 80DD' element. --
428: -- --
429: -- Parameters : --
430: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
431: -- p_disability_type VARCHAR2 --
432: -- p_disability_percentage VARCHAR2 --
433: -- p_treatment_amount NUMBER --
434: -- p_effective_date DATE --

Line 440: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

436: -- OUT : p_warnings BOOLEAN --
437: -- --
438: --------------------------------------------------------------------------
439: PROCEDURE declare_section80dd
440: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
441: ,p_disability_type IN VARCHAR2
442: ,p_disability_percentage IN VARCHAR2
443: ,p_treatment_amount IN NUMBER
444: ,p_effective_date IN DATE default null

Line 457: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

453: -- Description : The procedure is responsible for storing the --
454: -- detials in 'Deduction under Section 80G' element. --
455: -- --
456: -- Parameters : --
457: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
458: -- p_donation_type VARCHAR2 --
459: -- p_donation_amount NUMBER --
460: -- p_effective_date DATE --
461: -- p_element_entry_id element_entry_id%TYPE --

Line 466: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

462: -- OUT : p_warnings BOOLEAN --
463: -- --
464: --------------------------------------------------------------------------
465: PROCEDURE declare_section80g
466: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
467: ,p_donation_type IN VARCHAR2
468: ,p_donation_amount IN NUMBER
469: ,p_effective_date IN DATE default null
470: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 482: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

478: -- Description : The procedure is responsible for storing the --
479: -- detials in 'Deduction under Section 80CCE' element. --
480: -- --
481: -- Parameters : --
482: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
483: -- p_investment_type VARCHAR2 --
484: -- p_investment_amount NUMBER --
485: -- p_effective_date DATE --
486: -- p_element_entry_id element_entry_id%TYPE --

Line 491: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

487: -- OUT : p_warnings BOOLEAN --
488: -- --
489: --------------------------------------------------------------------------
490: PROCEDURE declare_section80cce
491: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
492: ,p_investment_type IN VARCHAR2
493: ,p_investment_amount IN NUMBER
494: ,p_effective_date IN DATE default null
495: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 507: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

503: -- Description : The procedure is responsible for storing the --
504: -- detials in 'Life Insurance Premium' element. --
505: -- --
506: -- Parameters : --
507: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
508: -- p_premium_paid VARCHAR2 --
509: -- p_sum_assured NUMBER --
510: -- p_effective_date DATE --
511: -- p_element_entry_id element_entry_id%TYPE --

Line 516: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

512: -- OUT : p_warnings BOOLEAN --
513: -- --
514: --------------------------------------------------------------------------
515: PROCEDURE declare_life_insurance_premium
516: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
517: ,p_premium_paid IN VARCHAR2
518: ,p_sum_assured IN NUMBER
519: ,p_effective_date IN DATE default null
520: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

Line 534: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

530: -- Description : The procedure is responsible for storing the --
531: -- details in 'PF Information' element. --
532: -- --
533: -- Parameters : --
534: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
535: -- p_effective_date DATE --
536: -- p_ee_vol_pf_amount NUMBER --
537: -- p_ee_vol_pf_percent NUMBER
538: -- OUT : p_warnings BOOLEAN --

Line 543: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

539: -- --
540: --------------------------------------------------------------------------
541:
542: PROCEDURE declare_vpf
543: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
544: ,p_effective_date IN DATE DEFAULT NULL
545: ,p_ee_vol_pf_amount IN NUMBER
546: ,p_ee_vol_pf_percent IN NUMBER
547: ,p_warnings OUT NOCOPY BOOLEAN);

Line 558: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

554: -- Description : The procedure is responsible for storing the --
555: -- detials in 'Tuition Fee' element. --
556: -- --
557: -- Parameters : --
558: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
559: -- p_tuition_fee_for_child_1 NUMBER --
560: -- p_tuition_fee_for_child_2 NUMBER --
561: -- p_effective_date DATE --
562: -- p_element_entry_id element_entry_id%TYPE --

Line 567: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

563: -- OUT : p_warnings BOOLEAN --
564: -- --
565: --------------------------------------------------------------------------
566: PROCEDURE declare_tuition_fee
567: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
568: ,p_tuition_fee_for_child_1 IN NUMBER
569: ,p_tuition_fee_for_child_2 IN NUMBER
570: ,p_effective_date IN DATE DEFAULT NULL
571: ,p_warnings OUT NOCOPY BOOLEAN);

Line 574: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

570: ,p_effective_date IN DATE DEFAULT NULL
571: ,p_warnings OUT NOCOPY BOOLEAN);
572:
573: PROCEDURE declare_tax
574: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
575: ,p_is_monthly_rent_changed IN VARCHAR2
576: ,p_apr IN NUMBER default null
577: ,p_may IN NUMBER default null
578: ,p_jun IN NUMBER default null

Line 685: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--

681: -- Description : The procedure is responsible for approval of --
682: -- tax declaration for the assignment in question. --
683: -- --
684: -- Parameters : --
685: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--
686: -- p_approval_flag VARCHAR2 --
687: -- p_effective_date DATE --
688: -- p_comment_text VARCHAR2 --
689: -- --

Line 692: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

688: -- p_comment_text VARCHAR2 --
689: -- --
690: --------------------------------------------------------------------------
691: PROCEDURE approve_declaration
692: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
693: ,p_approval_flag IN VARCHAR2
694: ,p_effective_date IN DATE
695: ,p_comment_text IN VARCHAR2);
696:

Line 933: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

929: -- Description : The procedure is responsible for storing the --
930: -- detials in 'Deduction under Section 80GG' element. --
931: -- --
932: -- Parameters : --
933: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
934: -- p_effective_date DATE --
935: -- p_claim_exemp_under_sec_80gg VARCHAR2 --
936: -- OUT : p_warnings BOOLEAN --
937: -- --

Line 940: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

936: -- OUT : p_warnings BOOLEAN --
937: -- --
938: --------------------------------------------------------------------------
939: PROCEDURE declare_section80gg
940: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
941: ,p_effective_date IN DATE DEFAULT NULL
942: ,p_claim_exemp_under_sec_80gg IN VARCHAR2
943: ,p_warnings OUT NOCOPY BOOLEAN);
944:

Line 954: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

950: -- Description : The procedure is responsible for storing the --
951: -- detials in 'Deduction under Section 80E' element. --
952: -- --
953: -- Parameters : --
954: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
955: -- p_effective_date DATE --
956: -- p_higher_education_loan_80e NUMBER --
957: -- OUT : p_warnings BOOLEAN --
958: -- --

Line 961: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

957: -- OUT : p_warnings BOOLEAN --
958: -- --
959: --------------------------------------------------------------------------
960: PROCEDURE declare_section80e
961: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
962: ,p_effective_date IN DATE DEFAULT NULL
963: ,p_higher_education_loan_80e IN NUMBER DEFAULT NULL
964: ,p_warnings OUT NOCOPY BOOLEAN);
965:

Line 975: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

971: -- Description : The procedure is responsible for storing the --
972: -- detials in 'Deduction under Section 80CCF' element. --
973: -- --
974: -- Parameters : --
975: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
976: -- p_effective_date DATE --
977: -- p_infrastructure_bonds_80ccf NUMBER --
978: -- OUT : p_warnings BOOLEAN --
979: -- --

Line 982: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

978: -- OUT : p_warnings BOOLEAN --
979: -- --
980: --------------------------------------------------------------------------
981: PROCEDURE declare_section80ccf
982: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
983: ,p_effective_date IN DATE DEFAULT NULL
984: ,p_infrastructure_bonds_80ccf IN NUMBER DEFAULT NULL
985: ,p_warnings OUT NOCOPY BOOLEAN);
986:

Line 989: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

985: ,p_warnings OUT NOCOPY BOOLEAN);
986:
987:
988: PROCEDURE declare_section80ccg
989: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
990: ,p_effective_date IN DATE DEFAULT NULL
991: ,p_investment_amt_80ccg IN NUMBER DEFAULT NULL
992: ,p_investment_date_80ccg IN DATE DEFAULT NULL
993: ,p_warnings OUT NOCOPY BOOLEAN);

Line 1004: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1000: -- Description : The procedure is responsible for storing the --
1001: -- detials in 'Deduction under Section 80GGA' element. --
1002: -- --
1003: -- Parameters : --
1004: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1005: -- p_effective_date DATE --
1006: -- p_donation_for_research_80gga NUMBER --
1007: -- OUT : p_warnings BOOLEAN --
1008: -- --

Line 1011: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1007: -- OUT : p_warnings BOOLEAN --
1008: -- --
1009: --------------------------------------------------------------------------
1010: PROCEDURE declare_section80gga
1011: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1012: ,p_effective_date IN DATE DEFAULT NULL
1013: ,p_donation_for_research_80gga IN NUMBER DEFAULT NULL
1014: ,p_warnings OUT NOCOPY BOOLEAN);
1015:

Line 1025: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1021: -- Description : The procedure is responsible for storing the --
1022: -- detials in 'Deduction under Section 80D' element. --
1023: -- --
1024: -- Parameters : --
1025: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1026: -- p_effective_date DATE --
1027: -- p_medical_insurance_prem_80d NUMBER --
1028: -- p_sec_80d_senior_citizen VARCHAR2 --
1029: -- OUT : p_warnings BOOLEAN --

Line 1033: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1029: -- OUT : p_warnings BOOLEAN --
1030: -- --
1031: --------------------------------------------------------------------------
1032: PROCEDURE declare_section80d
1033: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1034: ,p_effective_date IN DATE DEFAULT NULL
1035: ,p_medical_insurance_prem_80d IN NUMBER DEFAULT NULL
1036: ,p_sec_80d_senior_citizen IN VARCHAR2 DEFAULT NULL
1037: ,p_med_par_insurance_prem_80d IN NUMBER DEFAULT NULL

Line 1052: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1048: -- Description : The procedure is responsible for storing the --
1049: -- detials in 'Deduction under Section 80DDB' element. --
1050: -- --
1051: -- Parameters : --
1052: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1053: -- p_effective_date DATE --
1054: -- p_disease_treatment_80ddb NUMBER --
1055: -- p_sec_80ddb_senior_citizen VARCHAR2 --
1056: -- OUT : p_warnings BOOLEAN --

Line 1060: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1056: -- OUT : p_warnings BOOLEAN --
1057: -- --
1058: --------------------------------------------------------------------------
1059: PROCEDURE declare_section80ddb
1060: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1061: ,p_effective_date IN DATE DEFAULT NULL
1062: ,p_disease_treatment_80ddb IN NUMBER DEFAULT NULL
1063: ,p_sec_80ddb_senior_citizen IN VARCHAR2 DEFAULT NULL
1064: ,p_warnings OUT NOCOPY BOOLEAN);

Line 1075: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--

1071: -- Description : The procedure is responsible for storing the --
1072: -- detials in 'Deduction under Section 80U' element. --
1073: -- --
1074: -- Parameters : --
1075: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1076: -- p_effective_date DATE --
1077: -- OUT : p_warnings BOOLEAN --
1078: -- --
1079: --------------------------------------------------------------------------

Line 1081: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

1077: -- OUT : p_warnings BOOLEAN --
1078: -- --
1079: --------------------------------------------------------------------------
1080: PROCEDURE declare_section80U
1081: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1082: ,p_effective_date IN DATE DEFAULT NULL
1083: ,p_warnings OUT NOCOPY BOOLEAN);
1084:
1085: