[Home] [Help]
66: | number. Added the function get_party_num
67: | for bugs 2326595, 2309929, 2310806 |
68: | agairola 11-Apr-2002 Used the comments for the description field
69: | while populating the data in the
70: | RA_INTERFACE_LINES_ALL table in case
71: | the description is null
72: | for bugs 2326595, 2309929, 2310806 |
73: | agairola 10-Apr-2002 Modified the code for displaying the |
74: | Accounting Flex fields. Removed the |
85: | institution . |
86: | In the procedure transfer_posting |
87: | added code to copy value of the field |
88: | orig_appl_fee_ref to comments field of|
89: | RA_INTERFACE_LINES_ALL when |
90: | source_transaction_type is APPLFEE |
91: | Also added column orig_appl_fee_ref to|
92: | the IGS_FI_POSTING_INT_PKG.insert_row,|
93: | IGS_FI_POSTING_INT_PKG.update_row |
104: | jbegum 25 Feb 02 As part of Enh bug #2238226
105: | Modified the local procedure get_customer_details
106: | to derive customer account details for the local institution
107: | In the procedure transfer_posting added code to copy value of the field
108: | orig_appl_fee_ref to comments field of RA_INTERFACE_LINES_ALL when
109: | source_transaction_type is APPLFEE.Also added column orig_appl_fee_ref to
110: | the IGS_FI_POSTING_INT_PKG.insert_row ,IGS_FI_POSTING_INT_PKG.update_row
111: | jbegum 20 Feb 02 As part of Enh bug #2228910
112: Removed the source_transaction_id column from the IGS_FI_INVLN_INT_PKG.update_row
147: PROCEDURE derive_comments (
148: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
149: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
150: p_transaction_number OUT NOCOPY VARCHAR2,
151: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
152: );
153:
154: FUNCTION lookup_desc( l_type in igs_lookup_values.lookup_type%TYPE , l_code in igs_lookup_values.lookup_code%TYPE )RETURN VARCHAR2 IS
155: /******************************************************************
269: for bugs 2326595, 2309929, 2310806
270: ******************************************************************/
271:
272: l_v_txn_num VARCHAR2(240);
273: l_v_comments ra_interface_lines_all.comments%TYPE;
274:
275: l_dr_account igs_lookups_view.meaning%TYPE;
276: l_cr_account igs_lookups_view.meaning%TYPE;
277: BEGIN
998: PROCEDURE derive_comments (
999: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
1000: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
1001: p_transaction_number OUT NOCOPY VARCHAR2,
1002: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
1003: ) AS
1004: /*
1005: || Created By : sykrishn
1006: || Created On : 18-FEB-2002
1041: WHERE application_id = cp_transaction_id
1042: AND app.credit_id = crd.credit_id
1043: AND app.invoice_id = inv.invoice_id;
1044:
1045: l_v_comments ra_interface_lines_all.comments%TYPE := NULL;
1046: l_v_invoice_number igs_fi_inv_int.invoice_number%TYPE;
1047: l_v_credit_number igs_fi_credits.credit_number%TYPE;
1048:
1049: BEGIN
1167: || agairola 10_Apr-2002 Modified the cursor cur_postings to include brackets for
1168: || Batch name. Also, added the FOR UPDATE NOWAIT, exception and
1169: || appropriate exception handling for the locking. Removed the
1170: || commit from inside the begin end block for inserting records
1171: || in the RA_INTERFACE_LINES_ALL table.
1172: || for bugs 2326595, 2309929, 2310806
1173: || jbegum 25 Feb 02 As part of Enh bug #2238226
1174: || Added code to copy value of the field orig_appl_fee_ref to
1175: || comments field of RA_INTERFACE_LINES_ALL when
1171: || in the RA_INTERFACE_LINES_ALL table.
1172: || for bugs 2326595, 2309929, 2310806
1173: || jbegum 25 Feb 02 As part of Enh bug #2238226
1174: || Added code to copy value of the field orig_appl_fee_ref to
1175: || comments field of RA_INTERFACE_LINES_ALL when
1176: || source_transaction_type is APPLFEE
1177: || Added column orig_appl_fee_ref to the
1178: || IGS_FI_POSTING_INT_PKG.update_row
1179: || sykrishn 19 Feb 02 As part of Enh bug #2227831