[Home] [Help]
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,
11: x_balance_id IN NUMBER ,
12: x_party_id IN NUMBER ,
13: x_standard_balance IN NUMBER ,
14: x_fee_balance IN NUMBER ,
15: x_holds_balance IN NUMBER ,
16: x_balance_date IN DATE ,
17: x_fee_balance_rule_id IN NUMBER ,
34: || installment_balance_id and installment_balance_rule_id for
35: || Enh Bug # 2562745
36: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
37: || agairola 30-May-2002 For bug 2364505, obsoleted column
38: standard_balance_rule_id
39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
62:
63: -- Populate New Values.
64: new_references.balance_id := x_balance_id;
65: new_references.party_id := x_party_id;
66: new_references.standard_balance := x_standard_balance;
67: new_references.fee_balance := x_fee_balance;
68: new_references.holds_balance := x_holds_balance;
69: new_references.balance_date := x_balance_date;
70: new_references.fee_balance_rule_id := x_fee_balance_rule_id;
98: || pathipat 30-SEP-2002 Obsoleted columns other_balance_rule_id and
99: || installment_balance_rule_id for Enh Bug # 2562745
100: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
101: || agairola 30-May-2002 For bug 2364505, obsoleted column
102: standard_balance_rule_id
103: */
104:
105: CURSOR cur_rowid IS
106: SELECT rowid
337: p_action IN VARCHAR2,
338: x_rowid IN VARCHAR2 ,
339: x_balance_id IN NUMBER ,
340: x_party_id IN NUMBER ,
341: x_standard_balance IN NUMBER ,
342: x_fee_balance IN NUMBER ,
343: x_holds_balance IN NUMBER ,
344: x_balance_date IN DATE ,
345: x_fee_balance_rule_id IN NUMBER ,
365: || installment_balance_id and installment_balance_rule_id for
366: || Enh Bug # 2562745
367: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
368: || agairola 30-May-2002 For bug 2364505, obsoleted column
369: || standard_balance_rule_id
370: || SCHODAVA 8-OCT-2001 Enh # 2030448 (SFCR010)
371: */
372: BEGIN
373:
375: p_action,
376: x_rowid,
377: x_balance_id,
378: x_party_id,
379: x_standard_balance,
380: x_fee_balance,
381: x_holds_balance,
382: x_balance_date,
383: x_fee_balance_rule_id,
454: PROCEDURE insert_row (
455: x_rowid IN OUT NOCOPY VARCHAR2,
456: x_balance_id IN OUT NOCOPY NUMBER,
457: x_party_id IN NUMBER,
458: x_standard_balance IN NUMBER,
459: x_fee_balance IN NUMBER,
460: x_holds_balance IN NUMBER,
461: x_balance_date IN DATE,
462: x_fee_balance_rule_id IN NUMBER,
475: || installment_balance_id and installment_balance_rule_id for
476: || Enh Bug # 2562745
477: || smvk 17-Sep-2002 Obsoleted column subaccount_id as a part of Bug # 2564643
478: || agairola 30-May-2002 For bug 2364505, obsoleted column
479: standard_balance_rule_id
480: */
481: CURSOR c IS
482: SELECT rowid
483: FROM igs_fi_balances
532: p_action => 'INSERT',
533: x_rowid => x_rowid,
534: x_balance_id => x_balance_id,
535: x_party_id => x_party_id,
536: x_standard_balance => x_standard_balance,
537: x_fee_balance => x_fee_balance,
538: x_holds_balance => x_holds_balance,
539: x_balance_date => x_balance_date,
540: x_fee_balance_rule_id => x_fee_balance_rule_id,
548:
549: INSERT INTO igs_fi_balances (
550: balance_id,
551: party_id,
552: standard_balance,
553: fee_balance,
554: holds_balance,
555: balance_date,
556: fee_balance_rule_id,
566: program_update_date
567: ) VALUES (
568: new_references.balance_id,
569: new_references.party_id,
570: new_references.standard_balance,
571: new_references.fee_balance,
572: new_references.holds_balance,
573: new_references.balance_date,
574: new_references.fee_balance_rule_id,
598: PROCEDURE lock_row (
599: x_rowid IN VARCHAR2,
600: x_balance_id IN NUMBER,
601: x_party_id IN NUMBER,
602: x_standard_balance IN NUMBER,
603: x_fee_balance IN NUMBER,
604: x_holds_balance IN NUMBER,
605: x_balance_date IN DATE,
606: x_fee_balance_rule_id IN NUMBER,
618: || installment_balance_id and installment_balance_rule_id for
619: || Enh Bug # 2562745
620: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
621: || agairola 30-May-2002 For bug 2364505, obsoleted column
622: standard_balance_rule_id
623: */
624: CURSOR c1 IS
625: SELECT
626: party_id,
623: */
624: CURSOR c1 IS
625: SELECT
626: party_id,
627: standard_balance,
628: fee_balance,
629: holds_balance,
630: balance_date,
631: fee_balance_rule_id,
650: CLOSE c1;
651:
652: IF (
653: (tlinfo.party_id = x_party_id)
654: AND ((tlinfo.standard_balance = x_standard_balance) OR ((tlinfo.standard_balance IS NULL) AND (X_standard_balance IS NULL)))
655: AND ((tlinfo.fee_balance = x_fee_balance) OR ((tlinfo.fee_balance IS NULL) AND (X_fee_balance IS NULL)))
656: AND ((tlinfo.holds_balance = x_holds_balance) OR ((tlinfo.holds_balance IS NULL) AND (X_holds_balance IS NULL)))
657: AND (tlinfo.balance_date = x_balance_date)
658: AND ((tlinfo.fee_balance_rule_id = x_fee_balance_rule_id) OR ((tlinfo.fee_balance_rule_id IS NULL) AND (X_fee_balance_rule_id IS NULL)))
673: PROCEDURE update_row (
674: x_rowid IN VARCHAR2,
675: x_balance_id IN NUMBER,
676: x_party_id IN NUMBER,
677: x_standard_balance IN NUMBER,
678: x_fee_balance IN NUMBER,
679: x_holds_balance IN NUMBER,
680: x_balance_date IN DATE,
681: x_fee_balance_rule_id IN NUMBER,
694: || installment_balance_id and installment_balance_rule_id for
695: || Enh Bug # 2562745
696: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
697: || agairola 30-May-2002 For bug 2364505, obsoleted column
698: standard_balance_rule_id
699: */
700: x_last_update_date DATE ;
701: x_last_updated_by NUMBER;
702: x_last_update_login NUMBER;
730: p_action => 'UPDATE',
731: x_rowid => x_rowid,
732: x_balance_id => x_balance_id,
733: x_party_id => x_party_id,
734: x_standard_balance => x_standard_balance,
735: x_fee_balance => x_fee_balance,
736: x_holds_balance => x_holds_balance,
737: x_balance_date => x_balance_date,
738: x_fee_balance_rule_id => x_fee_balance_rule_id,
760:
761: UPDATE igs_fi_balances
762: SET
763: party_id = new_references.party_id,
764: standard_balance = new_references.standard_balance,
765: fee_balance = new_references.fee_balance,
766: holds_balance = new_references.holds_balance,
767: balance_date = new_references.balance_date,
768: fee_balance_rule_id = new_references.fee_balance_rule_id,
794: PROCEDURE add_row (
795: x_rowid IN OUT NOCOPY VARCHAR2,
796: x_balance_id IN OUT NOCOPY NUMBER,
797: x_party_id IN NUMBER,
798: x_standard_balance IN NUMBER,
799: x_fee_balance IN NUMBER,
800: x_holds_balance IN NUMBER,
801: x_balance_date IN DATE,
802: x_fee_balance_rule_id IN NUMBER,
815: || installment_balance_id and installment_balance_rule_id for
816: || Enh Bug # 2562745
817: || smvk 17-Sep-2002 Obsoleted column subaccount_id, as part of Bug # 2564643
818: || agairola 30-May-2002 For bug 2364505, obsoleted column
819: standard_balance_rule_id
820: */
821: CURSOR c1 IS
822: SELECT rowid
823: FROM igs_fi_balances
833: insert_row (
834: x_rowid,
835: x_balance_id,
836: x_party_id,
837: x_standard_balance,
838: x_fee_balance,
839: x_holds_balance,
840: x_balance_date,
841: x_fee_balance_rule_id,
849: update_row (
850: x_rowid,
851: x_balance_id,
852: x_party_id,
853: x_standard_balance,
854: x_fee_balance,
855: x_holds_balance,
856: x_balance_date,
857: x_fee_balance_rule_id,