APPS.IGS_UC_TRANSACTIONS_PKG dependencies on IGS_UC_TRANSACTIONS

Line 1: PACKAGE BODY igs_uc_transactions_pkg AS

1: PACKAGE BODY igs_uc_transactions_pkg AS
2: /* $Header: IGSXI32B.pls 120.3 2006/08/21 03:36:53 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_transactions%ROWTYPE;

Line 5: old_references igs_uc_transactions%ROWTYPE;

1: PACKAGE BODY igs_uc_transactions_pkg AS
2: /* $Header: IGSXI32B.pls 120.3 2006/08/21 03:36:53 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_transactions%ROWTYPE;
6: new_references igs_uc_transactions%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_transactions%ROWTYPE;

2: /* $Header: IGSXI32B.pls 120.3 2006/08/21 03:36:53 jbaber ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_transactions%ROWTYPE;
6: new_references igs_uc_transactions%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 59: FROM IGS_UC_TRANSACTIONS

55: */
56:
57: CURSOR cur_old_ref_values IS
58: SELECT *
59: FROM IGS_UC_TRANSACTIONS
60: WHERE rowid = x_rowid;
61:
62: BEGIN
63:

Line 169: FROM igs_uc_transactions

165: || (reverse chronological order - newest change first)
166: */
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_uc_transactions
170: WHERE uc_tran_id = x_uc_tran_id ;
171:
172: lv_rowid cur_rowid%RowType;
173:

Line 349: FROM igs_uc_transactions

345: || (reverse chronological order - newest change first)
346: */
347: CURSOR c IS
348: SELECT rowid
349: FROM igs_uc_transactions
350: WHERE uc_tran_id = x_uc_tran_id;
351:
352: x_last_update_date DATE;
353: x_last_updated_by NUMBER;

Line 377: SELECT igs_uc_transactions_s.NEXTVAL

373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:
377: SELECT igs_uc_transactions_s.NEXTVAL
378: INTO x_uc_tran_id
379: FROM dual;
380:
381: before_dml(

Line 422: INSERT INTO igs_uc_transactions (

418:
419: IF (x_mode = 'S') THEN
420: igs_sc_gen_001.set_ctx('R');
421: END IF;
422: INSERT INTO igs_uc_transactions (
423: uc_tran_id,
424: transaction_id,
425: datetimestamp,
426: updater,

Line 591: FROM igs_uc_transactions

587: system_code,
588: ucas_cycle,
589: modular,
590: part_time
591: FROM igs_uc_transactions
592: WHERE rowid = x_rowid
593: FOR UPDATE NOWAIT;
594:
595: tlinfo c1%ROWTYPE;

Line 760: UPDATE igs_uc_transactions

756:
757: IF (x_mode = 'S') THEN
758: igs_sc_gen_001.set_ctx('R');
759: END IF;
760: UPDATE igs_uc_transactions
761: SET
762: transaction_id = new_references.transaction_id,
763: datetimestamp = new_references.datetimestamp,
764: updater = new_references.updater,

Line 865: FROM igs_uc_transactions

861: || (reverse chronological order - newest change first)
862: */
863: CURSOR c1 IS
864: SELECT rowid
865: FROM igs_uc_transactions
866: WHERE uc_tran_id = x_uc_tran_id;
867:
868: BEGIN
869:

Line 970: DELETE FROM igs_uc_transactions

966:
967: IF (x_mode = 'S') THEN
968: igs_sc_gen_001.set_ctx('R');
969: END IF;
970: DELETE FROM igs_uc_transactions
971: WHERE rowid = x_rowid;
972:
973: IF (SQL%NOTFOUND) THEN
974: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 987: END igs_uc_transactions_pkg;

983:
984: END delete_row;
985:
986:
987: END igs_uc_transactions_pkg;