APPS.IGS_PE_INCOME_TAX_PKG dependencies on IGS_PE_INCOME_TAX_ALL

Line 5: old_references IGS_PE_INCOME_TAX_ALL%RowType;

1: PACKAGE BODY igs_pe_income_tax_pkg AS
2: /* $Header: IGSNI53B.pls 120.3 2005/10/17 04:23:31 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_INCOME_TAX_ALL%RowType;
6: new_references IGS_PE_INCOME_TAX_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_INCOME_TAX_ALL%RowType;

2: /* $Header: IGSNI53B.pls 120.3 2005/10/17 04:23:31 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_INCOME_TAX_ALL%RowType;
6: new_references IGS_PE_INCOME_TAX_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM IGS_PE_INCOME_TAX_ALL

35: ***************************************************************/
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_PE_INCOME_TAX_ALL
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 159: FROM IGS_PE_INCOME_TAX_ALL

155: ***************************************************************/
156:
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM IGS_PE_INCOME_TAX_ALL
160: WHERE tax_id = x_tax_id
161: FOR UPDATE NOWAIT;
162:
163: lv_rowid cur_rowid%RowType;

Line 195: FROM IGS_PE_INCOME_TAX_ALL

191: ***************************************************************/
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM IGS_PE_INCOME_TAX_ALL
196: WHERE person_id = x_person_id ;
197:
198: lv_rowid cur_rowid%RowType;
199:

Line 234: FROM igs_pe_income_tax_all

230: ***************************************************************/
231:
232: CURSOR cur_rowid(cp_type_code varchar2,cp_type_code_id number) IS
233: SELECT rowid
234: FROM igs_pe_income_tax_all
235: WHERE person_id = x_person_id
236: AND ((cp_type_code is null and cp_type_code_id is not null and NVL(type_code_id,-1) = cp_type_code_id)
237: OR (cp_type_code is not null and cp_type_code_id is null and NVL(type_code,' ') = cp_type_code))
238: AND ((l_rowid is null) or (rowid <> l_rowid))

Line 431: cursor C is select ROWID from IGS_PE_INCOME_TAX_ALL

427:
428: (reverse chronological order - newest change first)
429: ***************************************************************/
430:
431: cursor C is select ROWID from IGS_PE_INCOME_TAX_ALL
432: where TAX_ID= X_TAX_ID
433: ;
434: X_LAST_UPDATE_DATE DATE ;
435: X_LAST_UPDATED_BY NUMBER ;

Line 437: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;

433: ;
434: X_LAST_UPDATE_DATE DATE ;
435: X_LAST_UPDATED_BY NUMBER ;
436: X_LAST_UPDATE_LOGIN NUMBER ;
437: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
438: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
439: begin
440: X_LAST_UPDATE_DATE := SYSDATE;
441: if(X_MODE = 'I') then

Line 438: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;

434: X_LAST_UPDATE_DATE DATE ;
435: X_LAST_UPDATED_BY NUMBER ;
436: X_LAST_UPDATE_LOGIN NUMBER ;
437: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
438: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
439: begin
440: X_LAST_UPDATE_DATE := SYSDATE;
441: if(X_MODE = 'I') then
442: X_LAST_UPDATED_BY := 1;

Line 491: insert into IGS_PE_INCOME_TAX_ALL (

487:
488: IF (x_mode = 'S') THEN
489: igs_sc_gen_001.set_ctx('R');
490: END IF;
491: insert into IGS_PE_INCOME_TAX_ALL (
492: TAX_ID
493: ,PERSON_ID
494: ,TAX_INFO
495: ,TYPE_CODE

Line 579: from IGS_PE_INCOME_TAX_ALL

575: , TYPE_CODE
576: , TYPE_CODE_ID
577: , START_DATE
578: , END_DATE
579: from IGS_PE_INCOME_TAX_ALL
580: where ROWID = X_ROWID
581: for update nowait;
582: tlinfo c1%rowtype;
583: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;

Line 583: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;

579: from IGS_PE_INCOME_TAX_ALL
580: where ROWID = X_ROWID
581: for update nowait;
582: tlinfo c1%rowtype;
583: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
584: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
585: begin
586: open c1;
587: fetch c1 into tlinfo;

Line 584: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;

580: where ROWID = X_ROWID
581: for update nowait;
582: tlinfo c1%rowtype;
583: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
584: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
585: begin
586: open c1;
587: fetch c1 into tlinfo;
588: if (c1%notfound) then

Line 651: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;

647:
648: X_LAST_UPDATE_DATE DATE ;
649: X_LAST_UPDATED_BY NUMBER ;
650: X_LAST_UPDATE_LOGIN NUMBER ;
651: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
652: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
653: begin
654: X_LAST_UPDATE_DATE := SYSDATE;
655: if(X_MODE = 'I') then

Line 652: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;

648: X_LAST_UPDATE_DATE DATE ;
649: X_LAST_UPDATED_BY NUMBER ;
650: X_LAST_UPDATE_LOGIN NUMBER ;
651: l_TYPE_CODE igs_pe_income_tax_all.type_code%TYPE;
652: l_TYPE_CODE_ID igs_pe_income_tax_all.type_code_id%TYPE;
653: begin
654: X_LAST_UPDATE_DATE := SYSDATE;
655: if(X_MODE = 'I') then
656: X_LAST_UPDATED_BY := 1;

Line 699: update IGS_PE_INCOME_TAX_ALL set

695: x_last_update_login=>X_LAST_UPDATE_LOGIN);
696: IF (x_mode = 'S') THEN
697: igs_sc_gen_001.set_ctx('R');
698: END IF;
699: update IGS_PE_INCOME_TAX_ALL set
700: PERSON_ID = NEW_REFERENCES.PERSON_ID,
701: TAX_INFO = NEW_REFERENCES.TAX_INFO,
702: TYPE_CODE = NEW_REFERENCES.TYPE_CODE,
703: TYPE_CODE_ID = NEW_REFERENCES.TYPE_CODE_ID,

Line 762: cursor c1 is select ROWID from IGS_PE_INCOME_TAX_ALL

758:
759: (reverse chronological order - newest change first)
760: ***************************************************************/
761:
762: cursor c1 is select ROWID from IGS_PE_INCOME_TAX_ALL
763: where TAX_ID= X_TAX_ID
764: ;
765: begin
766: open c1;

Line 821: delete from IGS_PE_INCOME_TAX_ALL

817: );
818: IF (x_mode = 'S') THEN
819: igs_sc_gen_001.set_ctx('R');
820: END IF;
821: delete from IGS_PE_INCOME_TAX_ALL
822: where ROWID = X_ROWID;
823: if (sql%notfound) then
824: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
825: igs_ge_msg_stack.add;