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_US_DEF_COMP_457 dependencies on PAY_US_CONTRIBUTION_HISTORY

Line 20: -- PAY_US_CONTRIBUTION_HISTORY table that are deviating the business

16: -- |------< Business_Rule_Proc >------|
17: -- ----------------------------------------------------------------------------+
18: -- Description
19: -- This procedure is used to report the records present in the
20: -- PAY_US_CONTRIBUTION_HISTORY table that are deviating the business
21: -- rules.
22: --
23: -- Pre Conditions
24: -- None.

Line 81: FROM PAY_US_CONTRIBUTION_HISTORY

77: business_group_id ,
78: MAX(NVL(max_contr_allowed, 0)),
79: SUM(NVL(amt_contr, 0)) ,
80: SUM(NVL(includable_comp, 0))
81: FROM PAY_US_CONTRIBUTION_HISTORY
82: WHERE TO_NUMBER(TO_CHAR(date_from, 'YYYY')) = p_year
83: AND TO_NUMBER(TO_CHAR(date_to , 'YYYY')) = p_year
84: AND tax_unit_id = p_gre_id
85: GROUP BY person_id ,

Line 101: FROM PAY_US_CONTRIBUTION_HISTORY

97: business_group_id ,
98: MAX(NVL(max_contr_allowed, 0)),
99: SUM(NVL(amt_contr, 0)) ,
100: SUM(NVL(includable_comp, 0))
101: FROM PAY_US_CONTRIBUTION_HISTORY
102: WHERE TO_NUMBER(TO_CHAR(date_from, 'YYYY')) = p_year
103: AND TO_NUMBER(TO_CHAR(date_to , 'YYYY')) = p_year
104: AND person_id = p_person_id
105: GROUP BY person_id ,

Line 121: FROM PAY_US_CONTRIBUTION_HISTORY

117: business_group_id ,
118: MAX(NVL(max_contr_allowed, 0)),
119: SUM(NVL(amt_contr, 0)) ,
120: SUM(NVL(includable_comp, 0))
121: FROM PAY_US_CONTRIBUTION_HISTORY
122: WHERE TO_NUMBER(TO_CHAR(date_from, 'YYYY')) = p_year
123: AND TO_NUMBER(TO_CHAR(date_to , 'YYYY')) = p_year
124: AND person_id = p_person_id
125: AND tax_unit_id = p_gre_id

Line 211: -- PAY_US_CONTRIBUTION_HISTORY table

207: -- |------< PAY_CONTRB_INS >------|
208: -- ----------------------------------------------------------------------------+
209: -- Description
210: -- This procedure is used to call the API that inserts data into the
211: -- PAY_US_CONTRIBUTION_HISTORY table
212: --+
213: -- Pre Conditions
214: -- None.
215: --+

Line 287: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||

283: l_object_version_number := 0;
284:
285: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while inserting in' ||
287: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||
288: TO_CHAR(l_person_id) || ' GRE = ' || TO_CHAR(l_tax_unit_id)
289: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
290: ' in ' || l_proc);
291: ELSE

Line 293: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||

289: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
290: ' in ' || l_proc);
291: ELSE
292: hr_utility.set_location('Error occured while inserting in ' ||
293: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||
294: TO_CHAR(l_person_id) || ' GRE = ' || TO_CHAR(l_tax_unit_id)
295: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
296: ' in ' || l_proc, 15);
297: END IF;

Line 305: -- PAY_US_CONTRIBUTION_HISTORY table

301: -- |------< Pay_Contrb_Upd >------|
302: -- ----------------------------------------------------------------------------+
303: -- Description
304: -- This procedure is used to call the API that updates data into the
305: -- PAY_US_CONTRIBUTION_HISTORY table
306: --+
307: -- Pre Conditions
308: -- None.
309: --+

Line 365: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||

361: l_object_version_number := l_ovn;
362:
363: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while Updating in' ||
365: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||
366: TO_CHAR(l_contr_history_id) || ' Object Version Number = ' ||
367: TO_CHAR(l_object_version_number)
368: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
369: ' in ' || l_proc);

Line 372: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||

368: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
369: ' in ' || l_proc);
370: ELSE
371: hr_utility.set_location('Error occured while Updating in ' ||
372: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||
373: TO_CHAR(l_contr_history_id) || ' Object Version Number = ' ||
374: TO_CHAR(l_object_version_number)
375: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
376: ' in ' || l_proc, 15);

Line 497: -- PAY_US_CONTRIBUTION_HISTORY table. If no record is present then the

493: --+
494: -- Description
495: -- This procedure is used to return contr_history_id and object_version_number
496: -- for a particular person and a tax unit Id in a particular year in
497: -- PAY_US_CONTRIBUTION_HISTORY table. If no record is present then the
498: -- contr_history_id and object_version_number are 0.
499: --+
500: -- Pre Conditions
501: -- None.

Line 538: FROM PAY_US_CONTRIBUTION_HISTORY

534: SELECT contr_history_id ,
535: object_version_number
536: INTO p_contr_history_id,
537: p_ovn_number
538: FROM PAY_US_CONTRIBUTION_HISTORY
539: WHERE CONTR_TYPE = g_contr_type
540: AND TO_NUMBER(TO_CHAR(DATE_FROM, 'YYYY')) = p_year
541: AND TO_NUMBER(TO_CHAR(DATE_TO, 'YYYY')) = p_year
542: AND tax_unit_id = p_tax_unit_id

Line 590: -- existing recs in PAY_US_CONTRIBUTION_HISTORY table, If it

586: -- p_person_id Person Id for whom the data has to be transferred.
587: -- If person Id is null, then the program proceeds for
588: -- for the whole GRE (Tax Unit)
589: -- p_override_mode If the mode is YES, then program updates the
590: -- existing recs in PAY_US_CONTRIBUTION_HISTORY table, If it
591: -- is NO, then it just inserts the new records
592: -- Out Parameters
593: -- errbuf Returns the error buffer
594: -- retcode Returns the error code

Line 1025: hr_utility.set_location('Inserting into PAY_US_CONTRIBUTION_HISTORY', 85);

1021: -- l_get_bal_flag stores if the calls to Get_Bal proc were successful or not
1022: -- l_contr_history_id = 0 ensures that this person_id is not having a record
1023: -- for the partucular year
1024:
1025: hr_utility.set_location('Inserting into PAY_US_CONTRIBUTION_HISTORY', 85);
1026: Pay_Contrb_Ins(
1027: l_business_group_id => l_business_group_id ,
1028: l_amt_contr => l_Def_457_Contribution_balance ,
1029: l_max_contr_allowed => l_max_457_contrb_allowed ,

Line 1045: hr_utility.set_location('Updating PAY_US_CONTRIBUTION_HISTORY', 90);

1041: l_get_bal_flag(1) = 'CORRECT' AND
1042: l_get_bal_flag(2) = 'CORRECT' AND
1043: l_get_bal_flag(3) = 'CORRECT') THEN
1044:
1045: hr_utility.set_location('Updating PAY_US_CONTRIBUTION_HISTORY', 90);
1046: Pay_contrb_Upd(
1047: l_contr_history_id => l_contr_history_id,
1048: l_object_version_number => l_ovn_number ,
1049: l_amt_contr => l_Def_457_Contribution_balance,