APPS.IGS_PR_UL_MARK_DTL_PKG dependencies on IGS_PR_UL_MARK_DTL

Line 1: PACKAGE BODY igs_pr_ul_mark_dtl_pkg AS

1: PACKAGE BODY igs_pr_ul_mark_dtl_pkg AS
2: /* $Header: IGSQI47B.pls 115.0 2003/11/07 11:01:10 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_dtl%ROWTYPE;

Line 5: old_references igs_pr_ul_mark_dtl%ROWTYPE;

1: PACKAGE BODY igs_pr_ul_mark_dtl_pkg AS
2: /* $Header: IGSQI47B.pls 115.0 2003/11/07 11:01:10 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_dtl%ROWTYPE;
6: new_references igs_pr_ul_mark_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_ul_mark_dtl%ROWTYPE;

2: /* $Header: IGSQI47B.pls 115.0 2003/11/07 11:01:10 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_dtl%ROWTYPE;
6: new_references igs_pr_ul_mark_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_pr_ul_mark_dtl

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM igs_pr_ul_mark_dtl
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 119: FROM igs_pr_ul_mark_dtl

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_pr_ul_mark_dtl
120: WHERE mark_config_id = x_mark_config_id
121: AND core_indicator_code = x_core_indicator_code
122: FOR UPDATE NOWAIT;
123:

Line 155: FROM igs_pr_ul_mark_dtl

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igs_pr_ul_mark_dtl
156: WHERE ((mark_config_id = x_mark_config_id));
157:
158: lv_rowid cur_rowid%RowType;
159:

Line 291: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_DTL_PKG.INSERT_ROW');

287: x_last_update_login := -1;
288: END IF;
289: ELSE
290: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
291: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_DTL_PKG.INSERT_ROW');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: END IF;
295:

Line 312: INSERT INTO igs_pr_ul_mark_dtl (

308: x_last_updated_by => x_last_updated_by,
309: x_last_update_login => x_last_update_login
310: );
311:
312: INSERT INTO igs_pr_ul_mark_dtl (
313: mark_config_id,
314: core_indicator_code,
315: total_credits,
316: required_flag,

Line 365: FROM igs_pr_ul_mark_dtl

361: total_credits,
362: required_flag,
363: priority_num,
364: unit_selection_code
365: FROM igs_pr_ul_mark_dtl
366: WHERE rowid = x_rowid
367: FOR UPDATE NOWAIT;
368:
369: tlinfo c1%ROWTYPE;

Line 442: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_DTL_PKG.UPDATE_ROW');

438: x_last_update_login := -1;
439: END IF;
440: ELSE
441: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
442: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_DTL_PKG.UPDATE_ROW');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446:

Line 463: UPDATE igs_pr_ul_mark_dtl

459: x_last_updated_by => x_last_updated_by,
460: x_last_update_login => x_last_update_login
461: );
462:
463: UPDATE igs_pr_ul_mark_dtl
464: SET
465: total_credits = new_references.total_credits,
466: required_flag = new_references.required_flag,
467: priority_num = new_references.priority_num,

Line 502: FROM igs_pr_ul_mark_dtl

498: || (reverse chronological order - newest change first)
499: */
500: CURSOR c1 IS
501: SELECT rowid
502: FROM igs_pr_ul_mark_dtl
503: WHERE mark_config_id = x_mark_config_id
504: AND core_indicator_code = x_core_indicator_code;
505:
506: BEGIN

Line 560: DELETE FROM igs_pr_ul_mark_dtl

556: p_action => 'DELETE',
557: x_rowid => x_rowid
558: );
559:
560: DELETE FROM igs_pr_ul_mark_dtl
561: WHERE rowid = x_rowid;
562:
563: IF (SQL%NOTFOUND) THEN
564: RAISE NO_DATA_FOUND;

Line 570: END igs_pr_ul_mark_dtl_pkg;

566:
567: END delete_row;
568:
569:
570: END igs_pr_ul_mark_dtl_pkg;