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 115: -- IN : p_assignment_id per_assignments_f.assignment_id --

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

Line 122: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 162: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 282: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 324: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 367: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 408: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 437: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 463: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 488: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

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

Line 513: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

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

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

525: -- Description : The procedure is responsible for storing the --
526: -- detials in 'Tuition Fee' element. --
527: -- --
528: -- Parameters : --
529: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
530: -- p_tuition_fee_for_child_1 NUMBER --
531: -- p_tuition_fee_for_child_2 NUMBER --
532: -- p_effective_date DATE --
533: -- p_element_entry_id element_entry_id%TYPE --

Line 538: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

534: -- OUT : p_warnings BOOLEAN --
535: -- --
536: --------------------------------------------------------------------------
537: PROCEDURE declare_tuition_fee
538: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
539: ,p_tuition_fee_for_child_1 IN NUMBER
540: ,p_tuition_fee_for_child_2 IN NUMBER
541: ,p_effective_date IN DATE DEFAULT NULL
542: ,p_warnings OUT NOCOPY BOOLEAN);

Line 545: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

541: ,p_effective_date IN DATE DEFAULT NULL
542: ,p_warnings OUT NOCOPY BOOLEAN);
543:
544: PROCEDURE declare_tax
545: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
546: ,p_is_monthly_rent_changed IN VARCHAR2
547: ,p_apr IN NUMBER default null
548: ,p_may IN NUMBER default null
549: ,p_jun IN NUMBER default null

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

636: -- Description : The procedure is responsible for approval of --
637: -- tax declaration for the assignment in question. --
638: -- --
639: -- Parameters : --
640: -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--
641: -- p_approval_flag VARCHAR2 --
642: -- p_effective_date DATE --
643: -- p_comment_text VARCHAR2 --
644: -- --

Line 647: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

643: -- p_comment_text VARCHAR2 --
644: -- --
645: --------------------------------------------------------------------------
646: PROCEDURE approve_declaration
647: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
648: ,p_approval_flag IN VARCHAR2
649: ,p_effective_date IN DATE
650: ,p_comment_text IN VARCHAR2);
651:

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

824: -- Description : The procedure is responsible for storing the --
825: -- detials in 'Deduction under Section 80GG' element. --
826: -- --
827: -- Parameters : --
828: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
829: -- p_effective_date DATE --
830: -- p_claim_exemp_under_sec_80gg VARCHAR2 --
831: -- OUT : p_warnings BOOLEAN --
832: -- --

Line 835: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

831: -- OUT : p_warnings BOOLEAN --
832: -- --
833: --------------------------------------------------------------------------
834: PROCEDURE declare_section80gg
835: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
836: ,p_effective_date IN DATE DEFAULT NULL
837: ,p_claim_exemp_under_sec_80gg IN VARCHAR2
838: ,p_warnings OUT NOCOPY BOOLEAN);
839:

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

845: -- Description : The procedure is responsible for storing the --
846: -- detials in 'Deduction under Section 80E' element. --
847: -- --
848: -- Parameters : --
849: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
850: -- p_effective_date DATE --
851: -- p_higher_education_loan_80e NUMBER --
852: -- OUT : p_warnings BOOLEAN --
853: -- --

Line 856: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

852: -- OUT : p_warnings BOOLEAN --
853: -- --
854: --------------------------------------------------------------------------
855: PROCEDURE declare_section80e
856: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
857: ,p_effective_date IN DATE DEFAULT NULL
858: ,p_higher_education_loan_80e IN NUMBER DEFAULT NULL
859: ,p_warnings OUT NOCOPY BOOLEAN);
860:

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

866: -- Description : The procedure is responsible for storing the --
867: -- detials in 'Deduction under Section 80GGA' element. --
868: -- --
869: -- Parameters : --
870: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
871: -- p_effective_date DATE --
872: -- p_donation_for_research_80gga NUMBER --
873: -- OUT : p_warnings BOOLEAN --
874: -- --

Line 877: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

873: -- OUT : p_warnings BOOLEAN --
874: -- --
875: --------------------------------------------------------------------------
876: PROCEDURE declare_section80gga
877: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
878: ,p_effective_date IN DATE DEFAULT NULL
879: ,p_donation_for_research_80gga IN NUMBER DEFAULT NULL
880: ,p_warnings OUT NOCOPY BOOLEAN);
881:

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

887: -- Description : The procedure is responsible for storing the --
888: -- detials in 'Deduction under Section 80D' element. --
889: -- --
890: -- Parameters : --
891: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
892: -- p_effective_date DATE --
893: -- p_medical_insurance_prem_80d NUMBER --
894: -- p_sec_80d_senior_citizen VARCHAR2 --
895: -- OUT : p_warnings BOOLEAN --

Line 899: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

895: -- OUT : p_warnings BOOLEAN --
896: -- --
897: --------------------------------------------------------------------------
898: PROCEDURE declare_section80d
899: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
900: ,p_effective_date IN DATE DEFAULT NULL
901: ,p_medical_insurance_prem_80d IN NUMBER DEFAULT NULL
902: ,p_sec_80d_senior_citizen IN VARCHAR2 DEFAULT NULL
903: ,p_med_par_insurance_prem_80d IN NUMBER DEFAULT NULL

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

912: -- Description : The procedure is responsible for storing the --
913: -- detials in 'Deduction under Section 80DDB' element. --
914: -- --
915: -- Parameters : --
916: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
917: -- p_effective_date DATE --
918: -- p_disease_treatment_80ddb NUMBER --
919: -- p_sec_80ddb_senior_citizen VARCHAR2 --
920: -- OUT : p_warnings BOOLEAN --

Line 924: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

920: -- OUT : p_warnings BOOLEAN --
921: -- --
922: --------------------------------------------------------------------------
923: PROCEDURE declare_section80ddb
924: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
925: ,p_effective_date IN DATE DEFAULT NULL
926: ,p_disease_treatment_80ddb IN NUMBER DEFAULT NULL
927: ,p_sec_80ddb_senior_citizen IN VARCHAR2 DEFAULT NULL
928: ,p_warnings OUT NOCOPY BOOLEAN);

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

935: -- Description : The procedure is responsible for storing the --
936: -- detials in 'Deduction under Section 80U' element. --
937: -- --
938: -- Parameters : --
939: -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
940: -- p_effective_date DATE --
941: -- OUT : p_warnings BOOLEAN --
942: -- --
943: --------------------------------------------------------------------------

Line 945: (p_assignment_id IN per_assignments_f.assignment_id%TYPE

941: -- OUT : p_warnings BOOLEAN --
942: -- --
943: --------------------------------------------------------------------------
944: PROCEDURE declare_section80U
945: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
946: ,p_effective_date IN DATE DEFAULT NULL
947: ,p_warnings OUT NOCOPY BOOLEAN);
948:
949: