APPS.IGF_SL_CLCHRS_DTLS_PKG dependencies on IGF_SL_CLCHRS_DTLS

Line 1: PACKAGE BODY igf_sl_clchrs_dtls_pkg AS

1: PACKAGE BODY igf_sl_clchrs_dtls_pkg AS
2: /* $Header: IGFLI41B.pls 120.0 2005/06/01 13:02:48 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_clchrs_dtls%ROWTYPE;

Line 5: old_references igf_sl_clchrs_dtls%ROWTYPE;

1: PACKAGE BODY igf_sl_clchrs_dtls_pkg AS
2: /* $Header: IGFLI41B.pls 120.0 2005/06/01 13:02:48 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_clchrs_dtls%ROWTYPE;
6: new_references igf_sl_clchrs_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_clchrs_dtls%ROWTYPE;

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

Line 39: FROM igf_sl_clchrs_dtls

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igf_sl_clchrs_dtls
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 125: FROM igf_sl_clchrs_dtls

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igf_sl_clchrs_dtls
126: WHERE clchgrsp_id = x_clchgrsp_id
127: FOR UPDATE NOWAIT;
128:
129: lv_rowid cur_rowid%RowType;

Line 160: FROM igf_sl_clchrs_dtls

156: */
157:
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igf_sl_clchrs_dtls
161: WHERE ((clrp1_id = x_clrp1_id ));
162:
163: lv_rowid cur_rowid%ROWTYPE;
164: BEGIN

Line 324: fnd_message.set_token ('ROUTINE', 'IGF_SL_CLCHRS_DTLS_PKG.INSERT_ROW');

320: x_program_update_date := SYSDATE;
321: END IF;
322: ELSE
323: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
324: fnd_message.set_token ('ROUTINE', 'IGF_SL_CLCHRS_DTLS_PKG.INSERT_ROW');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328:

Line 351: INSERT INTO igf_sl_clchrs_dtls (

347: x_last_updated_by => x_last_updated_by,
348: x_last_update_login => x_last_update_login
349: );
350:
351: INSERT INTO igf_sl_clchrs_dtls (
352: clchgrsp_id,
353: clrp1_id,
354: record_code,
355: send_record_txt,

Line 372: igf_sl_clchrs_dtls_s.NEXTVAL,

368: program_id,
369: program_application_id,
370: program_update_date
371: ) VALUES (
372: igf_sl_clchrs_dtls_s.NEXTVAL,
373: new_references.clrp1_id,
374: new_references.record_code,
375: new_references.send_record_txt,
376: new_references.error_message_1_code,

Line 430: FROM igf_sl_clchrs_dtls

426: error_message_3_code,
427: error_message_4_code,
428: error_message_5_code,
429: record_process_code
430: FROM igf_sl_clchrs_dtls
431: WHERE rowid = x_rowid
432: FOR UPDATE NOWAIT;
433:
434: tlinfo c1%ROWTYPE;

Line 521: fnd_message.set_token ('ROUTINE', 'IGF_SL_CLCHRS_DTLS_PKG.UPDATE_ROW');

517: x_last_update_login := -1;
518: END IF;
519: ELSE
520: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
521: fnd_message.set_token ('ROUTINE', 'IGF_SL_CLCHRS_DTLS_PKG.UPDATE_ROW');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:

Line 560: UPDATE igf_sl_clchrs_dtls

556: x_program_update_date := SYSDATE;
557: END IF;
558: END IF;
559:
560: UPDATE igf_sl_clchrs_dtls
561: SET
562: clchgrsp_id = new_references.clchgrsp_id,
563: clrp1_id = new_references.clrp1_id,
564: record_code = new_references.record_code,

Line 613: FROM igf_sl_clchrs_dtls

609: || (reverse chronological order - newest change first)
610: */
611: CURSOR c1 IS
612: SELECT rowid
613: FROM igf_sl_clchrs_dtls
614: WHERE clchgrsp_id = x_clchgrsp_id;
615:
616: BEGIN
617:

Line 678: DELETE FROM igf_sl_clchrs_dtls

674: p_action => 'DELETE',
675: x_rowid => x_rowid
676: );
677:
678: DELETE FROM igf_sl_clchrs_dtls
679: WHERE rowid = x_rowid;
680:
681: IF (SQL%NOTFOUND) THEN
682: RAISE NO_DATA_FOUND;

Line 688: END igf_sl_clchrs_dtls_pkg;

684:
685: END delete_row;
686:
687:
688: END igf_sl_clchrs_dtls_pkg;