APPS.IGS_AS_DOC_FEE_PMNT_PKG dependencies on IGS_AS_DOC_FEE_PMNT

Line 1: PACKAGE BODY Igs_As_Doc_Fee_Pmnt_Pkg AS

1: PACKAGE BODY Igs_As_Doc_Fee_Pmnt_Pkg AS
2: /* $Header: IGSDI72B.pls 115.3 2002/11/28 23:29:39 nsidana noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_doc_fee_pmnt%ROWTYPE;
5: new_references igs_as_doc_fee_pmnt%ROWTYPE;

Line 4: old_references igs_as_doc_fee_pmnt%ROWTYPE;

1: PACKAGE BODY Igs_As_Doc_Fee_Pmnt_Pkg AS
2: /* $Header: IGSDI72B.pls 115.3 2002/11/28 23:29:39 nsidana noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_doc_fee_pmnt%ROWTYPE;
5: new_references igs_as_doc_fee_pmnt%ROWTYPE;
6: FUNCTION check_unique_calseq (p_person_id IN NUMBER,
7: p_plan_id IN NUMBER,
8: p_cal_type IN VARCHAR2,

Line 5: new_references igs_as_doc_fee_pmnt%ROWTYPE;

1: PACKAGE BODY Igs_As_Doc_Fee_Pmnt_Pkg AS
2: /* $Header: IGSDI72B.pls 115.3 2002/11/28 23:29:39 nsidana noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_as_doc_fee_pmnt%ROWTYPE;
5: new_references igs_as_doc_fee_pmnt%ROWTYPE;
6: FUNCTION check_unique_calseq (p_person_id IN NUMBER,
7: p_plan_id IN NUMBER,
8: p_cal_type IN VARCHAR2,
9: p_seq_num IN NUMBER)

Line 46: FROM igs_as_doc_fee_pmnt

42: || (reverse chronological order - newest change first)
43: */
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM igs_as_doc_fee_pmnt
47: WHERE ROWID = x_rowid;
48: BEGIN
49: l_rowid := x_rowid;
50: -- Code for setting the Old and New Reference Values.

Line 201: FROM igs_as_doc_fee_pmnt

197: || (reverse chronological order - newest change first)
198: */
199: CURSOR c IS
200: SELECT ROWID
201: FROM igs_as_doc_fee_pmnt
202: WHERE person_id = x_person_id;
203: x_last_update_date DATE;
204: x_last_updated_by NUMBER;
205: x_last_update_login NUMBER;

Line 250: INSERT INTO igs_as_doc_fee_pmnt (

246: x_ci_sequence_number => x_ci_sequence_number,
247: x_program_on_file => x_program_on_file
248:
249: );
250: INSERT INTO igs_as_doc_fee_pmnt (
251: person_id,
252: fee_paid_date,
253: fee_amount,
254: fee_recorded_date,

Line 382: FROM igs_as_doc_fee_pmnt

378: prev_paid_plan ,
379: cal_type ,
380: ci_sequence_number,
381: program_on_file
382: FROM igs_as_doc_fee_pmnt
383: WHERE ROWID = x_rowid
384: FOR UPDATE NOWAIT;
385: tlinfo c1%ROWTYPE;
386: BEGIN

Line 536: UPDATE igs_as_doc_fee_pmnt

532: x_cal_type => x_cal_type ,
533: x_ci_sequence_number => x_ci_sequence_number,
534: x_program_on_file => x_program_on_file
535: );
536: UPDATE igs_as_doc_fee_pmnt
537: SET
538: fee_paid_date = new_references.fee_paid_date,
539: fee_amount = new_references.fee_amount,
540: fee_recorded_date = new_references.fee_recorded_date,

Line 648: FROM igs_as_doc_fee_pmnt

644: || (reverse chronological order - newest change first)
645: */
646: CURSOR c1 IS
647: SELECT ROWID
648: FROM igs_as_doc_fee_pmnt
649: WHERE person_id = x_person_id;
650:
651: L_RETURN_STATUS VARCHAR2(10);
652: L_MSG_DATA VARCHAR2(2000);

Line 727: DELETE FROM igs_as_doc_fee_pmnt

723: before_dml (
724: p_action => 'DELETE',
725: x_rowid => x_rowid
726: );
727: DELETE FROM igs_as_doc_fee_pmnt
728: WHERE ROWID = x_rowid;
729: IF (SQL%NOTFOUND) THEN
730: RAISE NO_DATA_FOUND;
731: END IF;

Line 781: FROM igs_as_doc_fee_pmnt

777: cp_plan_id IN NUMBER,
778: cp_cal_type IN VARCHAR2,
779: cp_seq_num IN NUMBER) IS
780: SELECT 'Y'
781: FROM igs_as_doc_fee_pmnt
782: WHERE person_id = cp_person_id AND
783: plan_id = cp_plan_id AND
784: cal_type = cp_cal_type AND
785: ci_sequence_number = cp_seq_num ;

Line 802: END Igs_As_Doc_Fee_Pmnt_Pkg;

798: RETURN (FALSE);
799: END IF;
800: END check_unique_calseq;
801:
802: END Igs_As_Doc_Fee_Pmnt_Pkg;