APPS.IGF_AW_AWD_LTR_TMP_PKG dependencies on IGF_AW_AWD_LTR_TMP

Line 1: PACKAGE BODY igf_aw_awd_ltr_tmp_pkg AS

1: PACKAGE BODY igf_aw_awd_ltr_tmp_pkg AS
2: /* $Header: IGFWI51B.pls 120.0 2005/06/01 13:53:06 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGF_AW_AWD_LTR_TMP%ROWTYPE;

Line 5: old_references IGF_AW_AWD_LTR_TMP%ROWTYPE;

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

Line 6: new_references IGF_AW_AWD_LTR_TMP%ROWTYPE;

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

Line 38: FROM IGF_AW_AWD_LTR_TMP

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGF_AW_AWD_LTR_TMP
39: WHERE ROWID = x_rowid;
40:
41: BEGIN
42:

Line 190: FROM IGF_AW_AWD_LTR_TMP

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR c IS
189: SELECT ROWID
190: FROM IGF_AW_AWD_LTR_TMP
191: WHERE line_id = new_references.line_id ;
192:
193: x_last_update_date DATE;
194: x_last_updated_by NUMBER;

Line 237: INSERT INTO IGF_AW_AWD_LTR_TMP (

233: x_last_updated_by => x_last_updated_by,
234: x_last_update_login => x_last_update_login
235: );
236:
237: INSERT INTO IGF_AW_AWD_LTR_TMP (
238: line_id,
239: person_id,
240: fund_code,
241: fund_description,

Line 312: FROM IGF_AW_AWD_LTR_TMP

308: ci_cal_type,
309: ci_sequence_number,
310: award_total ,
311: term_amount_text
312: FROM IGF_AW_AWD_LTR_TMP
313: WHERE ROWID = x_rowid
314: FOR UPDATE NOWAIT;
315:
316: tlinfo c1%ROWTYPE;

Line 370: FROM igf_aw_awd_ltr_tmp

366: || (reverse chronological order - newest change first)
367: */
368: CURSOR cur_rowid IS
369: SELECT rowid
370: FROM igf_aw_awd_ltr_tmp
371: WHERE person_id = x_person_id
372: AND line_id = x_line_id
373: AND ci_cal_type = x_ci_cal_type
374: AND ci_sequence_number = x_ci_sequence_number

Line 458: UPDATE IGF_AW_AWD_LTR_TMP

454: x_last_updated_by => x_last_updated_by,
455: x_last_update_login => x_last_update_login
456: );
457:
458: UPDATE IGF_AW_AWD_LTR_TMP
459: SET
460: line_id = new_references.line_id,
461: person_id = new_references.person_id,
462: fund_code = new_references.fund_code,

Line 504: FROM IGF_AW_AWD_LTR_TMP

500: || (reverse chronological order - newest change first)
501: */
502: CURSOR c1 IS
503: SELECT ROWID
504: FROM IGF_AW_AWD_LTR_TMP
505: WHERE line_id = x_line_id;
506:
507: BEGIN
508:

Line 567: DELETE FROM IGF_AW_AWD_LTR_TMP

563: p_action => 'DELETE',
564: x_rowid => x_rowid
565: );
566:
567: DELETE FROM IGF_AW_AWD_LTR_TMP
568: WHERE ROWID = x_rowid;
569:
570: IF (SQL%NOTFOUND) THEN
571: RAISE NO_DATA_FOUND;

Line 577: END igf_aw_awd_ltr_tmp_pkg;

573:
574: END delete_row;
575:
576:
577: END igf_aw_awd_ltr_tmp_pkg;