APPS.IGS_CO_OU_CO_PKG dependencies on IGS_CO_OU_CO_ALL

Line 10: old_references igs_co_ou_co_all%ROWTYPE;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to IGS_CO_VAL_OC.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references igs_co_ou_co_all%ROWTYPE;
11: new_references igs_co_ou_co_all%ROWTYPE;
12:
13: PROCEDURE set_column_values (
14: p_action IN VARCHAR2,

Line 11: new_references igs_co_ou_co_all%ROWTYPE;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references igs_co_ou_co_all%ROWTYPE;
11: new_references igs_co_ou_co_all%ROWTYPE;
12:
13: PROCEDURE set_column_values (
14: p_action IN VARCHAR2,
15: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 46: FROM IGS_CO_OU_CO_ALL

42: */
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGS_CO_OU_CO_ALL
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 142: FROM igs_co_ou_co_all

138: || (reverse chronological order - newest change first)
139: */
140: CURSOR cur_rowid IS
141: SELECT rowid
142: FROM igs_co_ou_co_all
143: WHERE ((correspondence_type = x_correspondence_type) AND
144: (spl_sequence_number = x_letter_reference_number));
145:
146: lv_rowid cur_rowid%RowType;

Line 199: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_CO_OU_CO_ALL') THEN

195: WHERE correspondence_type = new_references.correspondence_type AND
196: reference_number = new_references.reference_number;
197: BEGIN
198: -- If trigger has not been disabled, perform required processing
199: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_CO_OU_CO_ALL') THEN
200: -- Fetch the Cor Item Created Date and validate it
201: OPEN c_cor_item;
202: FETCH c_cor_item INTO v_created_date;
203: CLOSE c_cor_item;

Line 237: FROM igs_co_ou_co_all

233: || (reverse chronological order - newest change first)
234: */
235: CURSOR cur_rowid IS
236: SELECT rowid
237: FROM igs_co_ou_co_all
238: WHERE person_id = x_person_id
239: AND correspondence_type = x_correspondence_type
240: AND reference_number = x_reference_number
241: AND issue_dt = x_issue_dt

Line 389: FROM igs_co_ou_co_all

385: || (reverse chronological order - newest change first)
386: */
387: CURSOR c IS
388: SELECT rowid
389: FROM igs_co_ou_co_all
390: WHERE person_id = x_person_id
391: AND correspondence_type = x_correspondence_type
392: AND reference_number = x_reference_number
393: AND issue_dt = new_references.issue_dt;

Line 458: INSERT INTO igs_co_ou_co_all (

454: x_last_updated_by => x_last_updated_by,
455: x_last_update_login => x_last_update_login
456: );
457:
458: INSERT INTO igs_co_ou_co_all (
459: person_id,
460: correspondence_type,
461: reference_number,
462: issue_dt,

Line 548: FROM igs_co_ou_co_all

544: unknown_return_dt,
545: letter_reference_number,
546: spl_sequence_number
547:
548: FROM igs_co_ou_co_all
549: WHERE rowid = x_rowid
550: FOR UPDATE NOWAIT;
551:
552: tlinfo c1%ROWTYPE;

Line 677: UPDATE igs_co_ou_co_all

673: x_program_update_date := SYSDATE;
674: END IF;
675: END IF;
676:
677: UPDATE igs_co_ou_co_all
678: SET
679: addr_type = new_references.addr_type,
680: tracking_id = new_references.tracking_id,
681: comments = new_references.comments,

Line 729: FROM igs_co_ou_co_all

725: || (reverse chronological order - newest change first)
726: */
727: CURSOR c1 IS
728: SELECT rowid
729: FROM igs_co_ou_co_all
730: WHERE person_id = x_person_id
731: AND correspondence_type = x_correspondence_type
732: AND reference_number = x_reference_number
733: AND issue_dt = NVL (x_issue_dt,SYSDATE);

Line 787: FROM IGS_CO_OU_CO_ALL

783: ) AS
784:
785: CURSOR cur_rowid IS
786: SELECT rowid
787: FROM IGS_CO_OU_CO_ALL
788: WHERE addr_type = x_addr_type ;
789:
790: lv_rowid cur_rowid%RowType;
791:

Line 814: FROM IGS_CO_OU_CO_ALL

810: ) AS
811:
812: CURSOR cur_rowid IS
813: SELECT rowid
814: FROM IGS_CO_OU_CO_ALL
815: WHERE correspondence_type = x_correspondence_type
816: AND reference_number = x_reference_number ;
817:
818: lv_rowid cur_rowid%RowType;

Line 841: FROM IGS_CO_OU_CO_ALL

837: ) AS
838:
839: CURSOR cur_rowid IS
840: SELECT rowid
841: FROM IGS_CO_OU_CO_ALL
842: WHERE person_id = x_person_id ;
843:
844: lv_rowid cur_rowid%RowType;
845:

Line 867: FROM IGS_CO_OU_CO_ALL

863: ) AS
864:
865: CURSOR cur_rowid IS
866: SELECT rowid
867: FROM IGS_CO_OU_CO_ALL
868: WHERE tracking_id = x_tracking_id ;
869:
870: lv_rowid cur_rowid%RowType;
871:

Line 908: DELETE FROM igs_co_ou_co_all

904: p_action => 'DELETE',
905: x_rowid => x_rowid
906: );
907:
908: DELETE FROM igs_co_ou_co_all
909: WHERE rowid = x_rowid;
910:
911: IF (SQL%NOTFOUND) THEN
912: RAISE NO_DATA_FOUND;