APPS.IGF_SL_COD_DOC_DTLS_PKG dependencies on IGF_SL_COD_DOC_DTLS

Line 1: PACKAGE BODY igf_sl_cod_doc_dtls_pkg AS

1: PACKAGE BODY igf_sl_cod_doc_dtls_pkg AS
2: /* $Header: IGFLI35B.pls 120.0 2005/06/02 18:00:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cod_doc_dtls%ROWTYPE;

Line 5: old_references igf_sl_cod_doc_dtls%ROWTYPE;

1: PACKAGE BODY igf_sl_cod_doc_dtls_pkg AS
2: /* $Header: IGFLI35B.pls 120.0 2005/06/02 18:00:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cod_doc_dtls%ROWTYPE;
6: new_references igf_sl_cod_doc_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cod_doc_dtls%ROWTYPE;

2: /* $Header: IGFLI35B.pls 120.0 2005/06/02 18:00:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cod_doc_dtls%ROWTYPE;
6: new_references igf_sl_cod_doc_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM igf_sl_cod_doc_dtls

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM igf_sl_cod_doc_dtls
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 96: FROM igf_sl_cod_doc_dtls

92: || (reverse chronological order - newest change first)
93: */
94: CURSOR cur_rowid IS
95: SELECT rowid
96: FROM igf_sl_cod_doc_dtls
97: WHERE document_id_txt = x_document_id_txt
98: FOR UPDATE NOWAIT;
99:
100: lv_rowid cur_rowid%RowType;

Line 212: FROM igf_sl_cod_doc_dtls

208: || (reverse chronological order - newest change first)
209: */
210: CURSOR c IS
211: SELECT rowid
212: FROM igf_sl_cod_doc_dtls
213: WHERE document_id_txt = x_document_id_txt;
214:
215: x_last_update_date DATE;
216: x_last_updated_by NUMBER;

Line 252: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.INSERT_ROW');

248: x_program_update_date := SYSDATE;
249: END IF;
250: ELSE
251: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
252: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.INSERT_ROW');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: END IF;
256:

Line 275: INSERT INTO igf_sl_cod_doc_dtls (

271: x_last_updated_by => x_last_updated_by,
272: x_last_update_login => x_last_update_login
273: );
274:
275: INSERT INTO igf_sl_cod_doc_dtls (
276: document_id_txt,
277: outbound_doc,
278: inbound_doc,
279: send_date,

Line 353: FROM igf_sl_cod_doc_dtls

349: ack_date,
350: doc_status,
351: doc_type,
352: full_resp_code
353: FROM igf_sl_cod_doc_dtls
354: WHERE rowid = x_rowid
355: FOR UPDATE NOWAIT;
356:
357: tlinfo c1%ROWTYPE;

Line 437: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.UPDATE_ROW');

433: x_last_update_login := -1;
434: END IF;
435: ELSE
436: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
437: fnd_message.set_token ('ROUTINE', 'IGF_SL_COD_DOC_DTLS_PKG.UPDATE_ROW');
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END IF;
441:

Line 474: UPDATE igf_sl_cod_doc_dtls

470: x_program_update_date := SYSDATE;
471: END IF;
472: END IF;
473:
474: UPDATE igf_sl_cod_doc_dtls
475: SET
476: outbound_doc = new_references.outbound_doc,
477: inbound_doc = new_references.inbound_doc,
478: send_date = new_references.send_date,

Line 522: FROM igf_sl_cod_doc_dtls

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

Line 583: DELETE FROM igf_sl_cod_doc_dtls

579: p_action => 'DELETE',
580: x_rowid => x_rowid
581: );
582:
583: DELETE FROM igf_sl_cod_doc_dtls
584: WHERE rowid = x_rowid;
585:
586: IF (SQL%NOTFOUND) THEN
587: RAISE NO_DATA_FOUND;

Line 593: END igf_sl_cod_doc_dtls_pkg;

589:
590: END delete_row;
591:
592:
593: END igf_sl_cod_doc_dtls_pkg;