eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_POSTING_INT_ALL

Line 142: g_n_posting_control_id igs_fi_posting_int_all.posting_control_id%TYPE;

138:
139: g_interface_attr igs_fi_control.interface_line_attribute%TYPE;
140:
141: -- Global Variable for posting control id
142: g_n_posting_control_id igs_fi_posting_int_all.posting_control_id%TYPE;
143:
144: -- For printing total records processed at end of log file.
145: g_n_rec_processed NUMBER := 0;
146:

Line 148: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,

144: -- For printing total records processed at end of log file.
145: g_n_rec_processed NUMBER := 0;
146:
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: );

Line 149: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,

145: g_n_rec_processed NUMBER := 0;
146:
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:

Line 313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

309: fnd_file.new_line(fnd_file.log);
310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*

Line 314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*
318: || Created By : brajendr

Line 315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*
318: || Created By : brajendr
319: || Created On : 24-Apr-2001

Line 345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

341: -- Get all the credit activity records, where GL_DATE lies b/w the passed date ranges that are yet to be posted.
342:
343: -- Cursor is modified to include the check of credit and debit account codes
344: -- by shtatiko as part of Enh Bug# 2584741.
345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
347:
348: SELECT crac.rowid row_id, crac.*
349: FROM igs_fi_cr_activities crac

Line 346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

342:
343: -- Cursor is modified to include the check of credit and debit account codes
344: -- by shtatiko as part of Enh Bug# 2584741.
345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
347:
348: SELECT crac.rowid row_id, crac.*
349: FROM igs_fi_cr_activities crac
350: WHERE crac.gl_date IS NOT NULL

Line 486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

482: END transfer_credit_act_txns;
483:
484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*

Line 487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

483:
484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*
491: || Created By : brajendr

Line 488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*
491: || Created By : brajendr
492: || Created On : 24-Apr-2001

Line 514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

510: */
511:
512: -- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
513:
514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
516:
517: SELECT appl.rowid row_id, appl.*
518: FROM igs_fi_applications appl

Line 515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

511:
512: -- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
513:
514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
516:
517: SELECT appl.rowid row_id, appl.*
518: FROM igs_fi_applications appl
519: WHERE appl.gl_date IS NOT NULL

Line 653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

649: END transfer_appl_txns;
650:
651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*

Line 654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

650:
651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*
658: || Created By : brajendr

Line 655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*
658: || Created By : brajendr
659: || Created On : 24-Apr-2001

Line 683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

679: */
680:
681: -- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
682:
683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv

Line 684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

680:
681: -- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
682:
683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv
688: WHERE invln.gl_date IS NOT NULL

Line 841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

837: app_exception.raise_exception;
838: END transfer_chgs_txns;
839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*

Line 842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

838: END transfer_chgs_txns;
839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*
846: || Created By : SYKRISHN

Line 843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*
846: || Created By : SYKRISHN
847: || Created On : 01-NOV/2002

Line 867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

863: -- Only posting control id needs to be checked in this case
864:
865:
866:
867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
869: SELECT adm.rowid row_id,adm.*
870: FROM igs_ad_app_req adm
871: WHERE adm.gl_date IS NOT NULL

Line 868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

864:
865:
866:
867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
869: SELECT adm.rowid row_id,adm.*
870: FROM igs_ad_app_req adm
871: WHERE adm.gl_date IS NOT NULL
872: AND TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)

Line 890: l_v_orig_appl_fee_ref igs_fi_posting_int_all.orig_appl_fee_ref%TYPE;

886: l_b_exception_flag BOOLEAN := FALSE;
887: l_v_posting_rowid ROWID;
888: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
889: l_v_currency_cd igs_fi_control_all.currency_cd%TYPE := igs_fi_gen_gl.finp_ss_get_cur;
890: l_v_orig_appl_fee_ref igs_fi_posting_int_all.orig_appl_fee_ref%TYPE;
891: l_n_application_id igs_ad_appl.application_id%TYPE;
892:
893: BEGIN
894:

Line 999: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,

995: END transfer_ad_appl_fee_txns;
996:
997:
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

Line 1000: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,

996:
997:
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: /*

Line 1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1016: || (reverse chronological order - newest change first)
1017: */
1018:
1019: --Cursor to fetch the invoice number for the passed invoice_id
1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1021: SELECT inv.invoice_number
1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln
1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;

Line 1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;
1025:
1026: --Cursor to fetch the credit number for the passed credit_id
1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1028: SELECT crd.credit_number
1029: FROM igs_fi_credits crd,
1030: igs_fi_cr_activities cra
1031: WHERE cra.credit_activity_id = cp_transaction_id

Line 1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1031: WHERE cra.credit_activity_id = cp_transaction_id
1032: AND crd.credit_id = cra.credit_id;
1033:
1034: --Cursor to fetch the credit id and invoice id for the passed application id
1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1036: SELECT crd.credit_number,
1037: inv.invoice_number
1038: FROM igs_fi_applications app,
1039: igs_fi_credits crd,

Line 1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,

1139:
1140: PROCEDURE transfer_posting(
1141: ERRBUF OUT NOCOPY VARCHAR2,
1142: RETCODE OUT NOCOPY NUMBER,
1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,
1144: p_posting_date_low IN VARCHAR2,
1145: p_posting_date_high IN VARCHAR2,
1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE
1147: ) AS

Line 1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE

1142: RETCODE OUT NOCOPY NUMBER,
1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,
1144: p_posting_date_low IN VARCHAR2,
1145: p_posting_date_high IN VARCHAR2,
1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE
1147: ) AS
1148: /*
1149: || Created By : brajendr
1150: || Created On : 24-Apr-2001