APPS.IGS_AD_PNL_HIS_DTLS_PKG dependencies on IGS_AD_PNL_HIS_DTLS

Line 1: PACKAGE BODY igs_ad_pnl_his_dtls_pkg AS

1: PACKAGE BODY igs_ad_pnl_his_dtls_pkg AS
2: /* $Header: IGSAIH4B.pls 120.0 2005/06/01 23:45:07 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnl_his_dtls%ROWTYPE;

Line 5: old_references igs_ad_pnl_his_dtls%ROWTYPE;

1: PACKAGE BODY igs_ad_pnl_his_dtls_pkg AS
2: /* $Header: IGSAIH4B.pls 120.0 2005/06/01 23:45:07 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnl_his_dtls%ROWTYPE;
6: new_references igs_ad_pnl_his_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_pnl_his_dtls%ROWTYPE;

2: /* $Header: IGSAIH4B.pls 120.0 2005/06/01 23:45:07 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_pnl_his_dtls%ROWTYPE;
6: new_references igs_ad_pnl_his_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_ad_pnl_his_dtls

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_ad_pnl_his_dtls
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 128: FROM igs_ad_pnl_his_dtls

124: || (reverse chronological order - newest change first)
125: */
126: CURSOR cur_rowid IS
127: SELECT rowid
128: FROM igs_ad_pnl_his_dtls
129: WHERE panel_dtls_id = x_panel_dtls_id
130: AND history_date = x_history_date
131: FOR UPDATE NOWAIT;
132:

Line 164: FROM igs_ad_pnl_his_dtls

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igs_ad_pnl_his_dtls
165: WHERE ((panel_dtls_id = x_panel_dtls_id));
166:
167: lv_rowid cur_rowid%RowType;
168:

Line 200: FROM igs_ad_pnl_his_dtls

196: || (reverse chronological order - newest change first)
197: */
198: CURSOR cur_rowid IS
199: SELECT rowid
200: FROM igs_ad_pnl_his_dtls
201: WHERE ((final_decision_code = x_name) AND
202: (final_decision_type = x_class));
203:
204: lv_rowid cur_rowid%RowType;

Line 331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');

327: x_last_update_login := -1;
328: END IF;
329: ELSE
330: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:

Line 350: INSERT INTO igs_ad_pnl_his_dtls (

346: x_last_updated_by => x_last_updated_by,
347: x_last_update_login => x_last_update_login
348: );
349:
350: INSERT INTO igs_ad_pnl_his_dtls (
351: panel_dtls_id,
352: history_date,
353: final_decision_code,
354: final_decision_type,

Line 410: FROM igs_ad_pnl_his_dtls

406: CURSOR c1 IS
407: SELECT
408: final_decision_code,
409: final_decision_type
410: FROM igs_ad_pnl_his_dtls
411: WHERE rowid = x_rowid
412: FOR UPDATE NOWAIT;
413:
414: tlinfo c1%ROWTYPE;

Line 483: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');

479: x_last_update_login := -1;
480: END IF;
481: ELSE
482: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
483: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:

Line 502: UPDATE igs_ad_pnl_his_dtls

498: x_last_updated_by => x_last_updated_by,
499: x_last_update_login => x_last_update_login
500: );
501:
502: UPDATE igs_ad_pnl_his_dtls
503: SET
504: final_decision_code = new_references.final_decision_code,
505: final_decision_type = new_references.final_decision_type,
506: last_update_date = x_last_update_date,

Line 554: FROM igs_ad_pnl_his_dtls

550: || (reverse chronological order - newest change first)
551: */
552: CURSOR c1 IS
553: SELECT rowid
554: FROM igs_ad_pnl_his_dtls
555: WHERE panel_dtls_id = x_panel_dtls_id
556: AND history_date = x_history_date;
557:
558: BEGIN

Line 608: DELETE FROM igs_ad_pnl_his_dtls

604: p_action => 'DELETE',
605: x_rowid => x_rowid
606: );
607:
608: DELETE FROM igs_ad_pnl_his_dtls
609: WHERE rowid = x_rowid;
610:
611: IF (SQL%NOTFOUND) THEN
612: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 635: END igs_ad_pnl_his_dtls_pkg;

631: END IF;
632: END delete_row;
633:
634:
635: END igs_ad_pnl_his_dtls_pkg;