APPS.PAY_US_FEDERAL_TAX_INFO_F_PKG dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 1: package body PAY_US_FEDERAL_TAX_INFO_F_PKG as

1: package body PAY_US_FEDERAL_TAX_INFO_F_PKG as
2: /* $Header: pyufti.pkb 115.1 2003/12/02 16:05:39 tmathers noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_FEDERAL_TAX_INFO_ID in NUMBER,

Line 75: cursor C is select ROWID from PAY_US_FEDERAL_TAX_INFO_F

71: X_LAST_UPDATE_DATE in DATE,
72: X_LAST_UPDATED_BY in NUMBER,
73: X_LAST_UPDATE_LOGIN in NUMBER
74: ) is
75: cursor C is select ROWID from PAY_US_FEDERAL_TAX_INFO_F
76: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
77: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
78: and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE
79: ;

Line 81: insert into PAY_US_FEDERAL_TAX_INFO_F (

77: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
78: and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE
79: ;
80: begin
81: insert into PAY_US_FEDERAL_TAX_INFO_F (
82: FEDERAL_TAX_INFO_ID,
83: EFFECTIVE_START_DATE,
84: EFFECTIVE_END_DATE,
85: FUTA_WAGE_LIMIT,

Line 301: from PAY_US_FEDERAL_TAX_INFO_F

297: X_LAST_UPDATE_LOGIN in NUMBER
298: ) is
299: cursor c1(X_FEDERAL_TAX_INFO_ID NUMBER) is
300: select 'Y'
301: from PAY_US_FEDERAL_TAX_INFO_F
302: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID;
303: --
304: cursor c2(X_FEDERAL_TAX_INFO_ID NUMBER,X_EFFECTIVE_START_DATE DATE) is
305: select *

Line 306: from PAY_US_FEDERAL_TAX_INFO_F

302: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID;
303: --
304: cursor c2(X_FEDERAL_TAX_INFO_ID NUMBER,X_EFFECTIVE_START_DATE DATE) is
305: select *
306: from PAY_US_FEDERAL_TAX_INFO_F
307: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
308: and X_EFFECTIVE_START_DATE > EFFECTIVE_START_DATE
309: and X_EFFECTIVE_START_DATE < EFFECTIVE_END_DATE
310: FOR UPDATE OF EFFECTIVE_END_DATE;

Line 314: from PAY_US_FEDERAL_TAX_INFO_F

310: FOR UPDATE OF EFFECTIVE_END_DATE;
311: --
312: cursor c3(X_FEDERAL_TAX_INFO_ID NUMBER, X_EFFECTIVE_END_DATE DATE) is
313: select *
314: from PAY_US_FEDERAL_TAX_INFO_F
315: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
316: and X_EFFECTIVE_END_DATE > EFFECTIVE_START_DATE
317: and X_EFFECTIVE_END_DATE < EFFECTIVE_END_DATE
318: FOR UPDATE OF EFFECTIVE_START_DATE;

Line 321: l_rec PAY_US_FEDERAL_TAX_INFO_F%ROWTYPE;

317: and X_EFFECTIVE_END_DATE < EFFECTIVE_END_DATE
318: FOR UPDATE OF EFFECTIVE_START_DATE;
319: --
320: l_temp VARCHAR2(1);
321: l_rec PAY_US_FEDERAL_TAX_INFO_F%ROWTYPE;
322: l_rowid VARCHAR2(100);
323: begin
324: update PAY_US_FEDERAL_TAX_INFO_F set
325: FUTA_WAGE_LIMIT = X_FUTA_WAGE_LIMIT,

Line 324: update PAY_US_FEDERAL_TAX_INFO_F set

320: l_temp VARCHAR2(1);
321: l_rec PAY_US_FEDERAL_TAX_INFO_F%ROWTYPE;
322: l_rowid VARCHAR2(100);
323: begin
324: update PAY_US_FEDERAL_TAX_INFO_F set
325: FUTA_WAGE_LIMIT = X_FUTA_WAGE_LIMIT,
326: FUTA_RATE = X_FUTA_RATE,
327: SS_EE_WAGE_LIMIT = X_SS_EE_WAGE_LIMIT,
328: SS_EE_RATE = X_SS_EE_RATE,

Line 403: UPDATE PAY_US_FEDERAL_TAX_INFO_F

399: -- does the start date intersect with an existing row
400: open c2(X_FEDERAL_TAX_INFO_ID, X_EFFECTIVE_START_DATE);
401: fetch c2 into l_rec;
402: if c2%FOUND then
403: UPDATE PAY_US_FEDERAL_TAX_INFO_F
404: SET EFFECTIVE_END_DATE = X_EFFECTIVE_START_DATE -1
405: WHERE CURRENT OF c2;
406: end if;
407: close c2;

Line 412: UPDATE PAY_US_FEDERAL_TAX_INFO_F

408: -- does the end date intersect with an existing row?
409: open c3(X_FEDERAL_TAX_INFO_ID, X_EFFECTIVE_END_DATE);
410: fetch c3 into l_rec;
411: if c3%FOUND then
412: UPDATE PAY_US_FEDERAL_TAX_INFO_F
413: SET EFFECTIVE_START_DATE = X_EFFECTIVE_END_DATE +1
414: WHERE CURRENT OF c3;
415: end if;
416: close c3;

Line 421: PAY_US_FEDERAL_TAX_INFO_F_PKG.INSERT_ROW(

417: END;
418: end if;
419: CLOSE c1;
420: -- Insert our new row.
421: PAY_US_FEDERAL_TAX_INFO_F_PKG.INSERT_ROW(
422: X_ROWID => l_rowid,
423: X_FEDERAL_TAX_INFO_ID => X_FEDERAL_TAX_INFO_ID,
424: X_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE,
425: X_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE,

Line 502: delete from PAY_US_FEDERAL_TAX_INFO_F

498: X_EFFECTIVE_START_DATE in DATE,
499: X_EFFECTIVE_END_DATE in DATE
500: ) is
501: begin
502: delete from PAY_US_FEDERAL_TAX_INFO_F
503: where FEDERAL_TAX_INFO_ID = X_FEDERAL_TAX_INFO_ID
504: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
505: and EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE;
506:

Line 512: end PAY_US_FEDERAL_TAX_INFO_F_PKG;

508: raise no_data_found;
509: end if;
510: end DELETE_ROW;
511:
512: end PAY_US_FEDERAL_TAX_INFO_F_PKG;