APPS.IGS_PE_VOTE_INFO_PKG dependencies on IGS_PE_VOTE_INFO_ALL

Line 5: old_references igs_pe_vote_info_all%RowType;

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

Line 6: new_references igs_pe_vote_info_all%RowType;

2: /* $Header: IGSNI50B.pls 120.3 2005/10/17 04:23:52 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_vote_info_all%RowType;
6: new_references igs_pe_vote_info_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_vote_info_all

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

Line 158: FROM igs_pe_vote_info_all

154: ***************************************************************/
155:
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_pe_vote_info_all
159: WHERE voter_id = x_voter_id
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 194: FROM igs_pe_vote_info_all

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

Line 234: FROM igs_pe_vote_info_all

230: ***************************************************************/
231:
232: CURSOR cur_rowid(cp_type_code varchar2,cp_type_code_id number) IS
233: SELECT rowid
234: FROM igs_pe_vote_info_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 436: cursor C is select ROWID from igs_pe_vote_info_all

432:
433: (reverse chronological order - newest change first)
434: ***************************************************************/
435:
436: cursor C is select ROWID from igs_pe_vote_info_all
437: where VOTER_ID= X_VOTER_ID;
438: X_LAST_UPDATE_DATE DATE ;
439: X_LAST_UPDATED_BY NUMBER ;
440: X_LAST_UPDATE_LOGIN NUMBER ;

Line 441: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;

437: where VOTER_ID= X_VOTER_ID;
438: X_LAST_UPDATE_DATE DATE ;
439: X_LAST_UPDATED_BY NUMBER ;
440: X_LAST_UPDATE_LOGIN NUMBER ;
441: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
442: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
443:
444: begin
445: X_LAST_UPDATE_DATE := SYSDATE;

Line 442: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;

438: X_LAST_UPDATE_DATE DATE ;
439: X_LAST_UPDATED_BY NUMBER ;
440: X_LAST_UPDATE_LOGIN NUMBER ;
441: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
442: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
443:
444: begin
445: X_LAST_UPDATE_DATE := SYSDATE;
446: if(X_MODE = 'I') then

Line 499: insert into igs_pe_vote_info_all (

495: );
496: IF (x_mode = 'S') THEN
497: igs_sc_gen_001.set_ctx('R');
498: END IF;
499: insert into igs_pe_vote_info_all (
500: VOTER_ID
501: ,PERSON_ID
502: ,VOTER_INFO
503: ,TYPE_CODE

Line 586: from igs_pe_vote_info_all

582: , TYPE_CODE
583: , TYPE_CODE_ID
584: , VOTER_REGN_ST_DATE
585: , VOTER_REGN_END_DATE
586: from igs_pe_vote_info_all
587: where ROWID = X_ROWID
588: for update nowait;
589: tlinfo c1%rowtype;
590:

Line 591: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;

587: where ROWID = X_ROWID
588: for update nowait;
589: tlinfo c1%rowtype;
590:
591: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
592: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
593:
594: BEGIN
595: open c1;

Line 592: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;

588: for update nowait;
589: tlinfo c1%rowtype;
590:
591: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
592: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
593:
594: BEGIN
595: open c1;
596: fetch c1 into tlinfo;

Line 659: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;

655:
656: X_LAST_UPDATE_DATE DATE ;
657: X_LAST_UPDATED_BY NUMBER ;
658: X_LAST_UPDATE_LOGIN NUMBER ;
659: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
660: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
661:
662: begin
663: X_LAST_UPDATE_DATE := SYSDATE;

Line 660: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;

656: X_LAST_UPDATE_DATE DATE ;
657: X_LAST_UPDATED_BY NUMBER ;
658: X_LAST_UPDATE_LOGIN NUMBER ;
659: l_TYPE_CODE igs_pe_vote_info_all.type_code%TYPE;
660: l_TYPE_CODE_ID igs_pe_vote_info_all.type_code_id%TYPE;
661:
662: begin
663: X_LAST_UPDATE_DATE := SYSDATE;
664: if(X_MODE = 'I') then

Line 708: update igs_pe_vote_info_all set

704: x_last_update_login=>X_LAST_UPDATE_LOGIN);
705: IF (x_mode = 'S') THEN
706: igs_sc_gen_001.set_ctx('R');
707: END IF;
708: update igs_pe_vote_info_all set
709: PERSON_ID = NEW_REFERENCES.PERSON_ID,
710: VOTER_INFO = NEW_REFERENCES.VOTER_INFO,
711: TYPE_CODE = NEW_REFERENCES.TYPE_CODE,
712: TYPE_CODE_ID = NEW_REFERENCES.TYPE_CODE_ID,

Line 772: cursor c1 is select ROWID from igs_pe_vote_info_all

768:
769: (reverse chronological order - newest change first)
770: ***************************************************************/
771:
772: cursor c1 is select ROWID from igs_pe_vote_info_all
773: where VOTER_ID= X_VOTER_ID;
774: begin
775: open c1;
776: fetch c1 into X_ROWID;

Line 826: delete from igs_pe_vote_info_all

822: );
823: IF (x_mode = 'S') THEN
824: igs_sc_gen_001.set_ctx('R');
825: END IF;
826: delete from igs_pe_vote_info_all
827: where ROWID = X_ROWID;
828: if (sql%notfound) then
829: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
830: igs_ge_msg_stack.add;