APPS.IGR_I_A_LINES_PKG dependencies on IGR_I_A_LINES

Line 1: PACKAGE BODY igr_i_a_lines_pkg AS

1: PACKAGE BODY igr_i_a_lines_pkg AS
2: /* $Header: IGSRH17B.pls 120.0 2005/06/01 22:35:22 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_a_lines%ROWTYPE;

Line 5: old_references igr_i_a_lines%ROWTYPE;

1: PACKAGE BODY igr_i_a_lines_pkg AS
2: /* $Header: IGSRH17B.pls 120.0 2005/06/01 22:35:22 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igr_i_a_lines%ROWTYPE;
6: new_references igr_i_a_lines%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igr_i_a_lines%ROWTYPE;

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

Line 33: FROM igr_i_a_lines

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

Line 117: FROM igr_i_a_lines

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM igr_i_a_lines
118: WHERE sales_lead_line_id = x_sales_lead_line_id
119: FOR UPDATE NOWAIT;
120:
121: lv_rowid cur_rowid%RowType;

Line 153: FROM igr_i_a_lines

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igr_i_a_lines
154: WHERE ((enquiry_appl_number = x_enquiry_appl_number) AND
155: (person_id = x_person_id));
156:
157: lv_rowid cur_rowid%RowType;

Line 298: fnd_message.set_token ('ROUTINE', 'IGR_I_A_LINES_PKG.INSERT_ROW');

294: x_program_update_date := SYSDATE;
295: END IF;
296: ELSE
297: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
298: fnd_message.set_token ('ROUTINE', 'IGR_I_A_LINES_PKG.INSERT_ROW');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: END IF;
302:

Line 317: INSERT INTO igr_i_a_lines (

313: x_last_updated_by => x_last_updated_by,
314: x_last_update_login => x_last_update_login
315: );
316:
317: INSERT INTO igr_i_a_lines (
318: person_id,
319: enquiry_appl_number,
320: sales_lead_line_id,
321: preference,

Line 371: FROM igr_i_a_lines

367: SELECT
368: person_id,
369: enquiry_appl_number,
370: preference
371: FROM igr_i_a_lines
372: WHERE rowid = x_rowid
373: FOR UPDATE NOWAIT;
374:
375: tlinfo c1%ROWTYPE;

Line 449: fnd_message.set_token ('ROUTINE', 'IGR_I_A_LINES_PKG.UPDATE_ROW');

445: x_last_update_login := -1;
446: END IF;
447: ELSE
448: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
449: fnd_message.set_token ('ROUTINE', 'IGR_I_A_LINES_PKG.UPDATE_ROW');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: END IF;
453:

Line 482: UPDATE igr_i_a_lines

478: x_program_update_date := SYSDATE;
479: END IF;
480: END IF;
481:
482: UPDATE igr_i_a_lines
483: SET
484: person_id = new_references.person_id,
485: enquiry_appl_number = new_references.enquiry_appl_number,
486: preference = new_references.preference,

Line 522: FROM igr_i_a_lines

518: || (reverse chronological order - newest change first)
519: */
520: CURSOR c1 IS
521: SELECT rowid
522: FROM igr_i_a_lines
523: WHERE sales_lead_line_id = x_sales_lead_line_id;
524:
525: BEGIN
526:

Line 575: DELETE FROM igr_i_a_lines

571: p_action => 'DELETE',
572: x_rowid => x_rowid
573: );
574:
575: DELETE FROM igr_i_a_lines
576: WHERE rowid = x_rowid;
577:
578: IF (SQL%NOTFOUND) THEN
579: RAISE NO_DATA_FOUND;

Line 585: END igr_i_a_lines_pkg;

581:
582: END delete_row;
583:
584:
585: END igr_i_a_lines_pkg;