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.

APPS.IGS_FI_GL_INTERFACE dependencies on GL_INTERFACE

Line 1: PACKAGE BODY igs_fi_gl_interface AS

1: PACKAGE BODY igs_fi_gl_interface AS
2: /* $Header: IGSFI76B.pls 120.8 2006/05/26 13:19:45 skharida ship $ */
3: /* **********************************************************************************************
4:
5: Created By : Amit Gairola

Line 7: Purpose : This package contains the procedures for processing the GL Interface

3: /* **********************************************************************************************
4:
5: Created By : Amit Gairola
6: Date Created By: 1-Nov-2002
7: Purpose : This package contains the procedures for processing the GL Interface
8: Known limitations,enhancements,remarks:
9: Change History
10: Who When What
11: abshriva 12-May-2006 Bug 5217319: Amount precision change in insert_gl_int

Line 392: Purpose : This procedure will create the records in the GL Interface table

388: /***********************************************************************************************
389:
390: Created By : Amit Gairola
391: Date Created By: 1-Nov-2002
392: Purpose : This procedure will create the records in the GL Interface table
393: Known limitations,enhancements,remarks:
394: Change History
395: Who When What
396: abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB

Line 398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;

394: Change History
395: Who When What
396: abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
397: ********************************************************************************************** */
398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;
399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;
400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;

Line 399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;

395: Who When What
396: abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
397: ********************************************************************************************** */
398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;
399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;
400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:

Line 400: l_n_amnt gl_interface.entered_dr%TYPE;

396: abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
397: ********************************************************************************************** */
398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;
399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;
400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:
404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS

Line 401: l_n_user_id gl_interface.created_by%TYPE;

397: ********************************************************************************************** */
398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;
399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;
400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:
404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS
405: SELECT user_je_category_name

Line 402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;

398: l_n_dr_ccid gl_interface.code_combination_id%TYPE;
399: l_n_cr_ccid gl_interface.code_combination_id%TYPE;
400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:
404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS
405: SELECT user_je_category_name
406: FROM gl_je_categories

Line 429: -- Create a transaction in the GL Interface for the debit account

425: l_n_cr_ccid := p_dr_ccid;
426: l_n_amnt := ABS(l_n_amnt);
427: END IF;
428:
429: -- Create a transaction in the GL Interface for the debit account
430: INSERT INTO gl_interface(status,
431: set_of_books_id,
432: accounting_date,
433: currency_code,

Line 430: INSERT INTO gl_interface(status,

426: l_n_amnt := ABS(l_n_amnt);
427: END IF;
428:
429: -- Create a transaction in the GL Interface for the debit account
430: INSERT INTO gl_interface(status,
431: set_of_books_id,
432: accounting_date,
433: currency_code,
434: date_created,

Line 469: -- Create a transaction in the GL Interface for the credit account

465: p_ref23,
466: p_ref30,
467: g_n_batch_id);
468:
469: -- Create a transaction in the GL Interface for the credit account
470: INSERT INTO gl_interface(status,
471: set_of_books_id,
472: accounting_date,
473: currency_code,

Line 470: INSERT INTO gl_interface(status,

466: p_ref30,
467: g_n_batch_id);
468:
469: -- Create a transaction in the GL Interface for the credit account
470: INSERT INTO gl_interface(status,
471: set_of_books_id,
472: accounting_date,
473: currency_code,
474: date_created,

Line 517: Purpose : This procedure will transfer the credit transactions to the GL Interface

513: /***********************************************************************************************
514:
515: Created By : Amit Gairola
516: Date Created By: 1-Nov-2002
517: Purpose : This procedure will transfer the credit transactions to the GL Interface
518: Known limitations,enhancements,remarks:
519: Change History
520: Who When What
521: bannamal 05-Jul-2005 Bug# 3392095, Tuition Waivers Build.

Line 546: l_v_crd_desc gl_interface.reference10%TYPE;

542: AND cra.status <> g_v_transferred;
543:
544: l_b_exception_flag BOOLEAN;
545: l_v_crd_cat gl_je_categories.je_category_name%TYPE;
546: l_v_crd_desc gl_interface.reference10%TYPE;
547: l_b_waiver_flag BOOLEAN;
548:
549: BEGIN
550:

Line 580: -- Create the transactions in the GL Interface table

576: l_v_crd_desc := l_v_crd_desc||' ;'||g_v_party_number||' :';
577: l_v_crd_desc := l_v_crd_desc||get_party_number(crdrec.party_id);
578: l_v_crd_desc := SUBSTR(l_v_crd_desc,1,240);
579:
580: -- Create the transactions in the GL Interface table
581: BEGIN
582: insert_gl_int(p_d_gl_date => crdrec.gl_date,
583: p_user_cat_name => l_v_crd_cat,
584: p_dr_ccid => crdrec.dr_gl_ccid,

Line 629: Purpose : This procedure will transfer the charge transactions to the GL Interface

625: /***********************************************************************************************
626:
627: Created By : Amit Gairola
628: Date Created By: 1-Nov-2002
629: Purpose : This procedure will transfer the charge transactions to the GL Interface
630: Known limitations,enhancements,remarks:
631: Change History
632: Who When What
633: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding

Line 643: l_v_inv_desc gl_interface.reference10%TYPE;

639: i.e. error_account is treated as 'N'
640: ********************************************************************************************** */
641: l_b_exception_flag BOOLEAN;
642: l_v_inv_cat gl_je_categories.je_category_name%TYPE;
643: l_v_inv_desc gl_interface.reference10%TYPE;
644:
645: -- Cursor for selecting the Charge transactions from the Invoice Lines table
646: CURSOR cur_chg(cp_gl_date_start igs_fi_invln_int.gl_date%TYPE,
647: cp_gl_date_end igs_fi_invln_int.gl_date%TYPE) IS

Line 685: -- Create transactions in the GL Interface

681: l_v_inv_desc := l_v_inv_desc||' :'||get_party_number(chgrec.person_id);
682:
683: l_v_inv_desc := SUBSTR(l_v_inv_desc,1,240);
684:
685: -- Create transactions in the GL Interface
686: SAVEPOINT SP_INV1;
687: BEGIN
688: insert_gl_int(p_d_gl_date => chgrec.gl_date,
689: p_user_cat_name => l_v_inv_cat,

Line 764: Purpose : This procedure will transfer the application transactions to the GL Interface

760: /***********************************************************************************************
761:
762: Created By : Amit Gairola
763: Date Created By: 1-Nov-2002
764: Purpose : This procedure will transfer the application transactions to the GL Interface
765: Known limitations,enhancements,remarks:
766: Change History
767: Who When What
768: bannamal 05-Jul-05 Bug# 3392095, Tuition Waivers Build.

Line 772: l_v_app_desc gl_interface.reference10%TYPE;

768: bannamal 05-Jul-05 Bug# 3392095, Tuition Waivers Build.
769: Added code to skip the waiver application record if the post_waiver_gl_flag is set to 'N'.
770: ********************************************************************************************** */
771: l_v_app_cat gl_je_categories.je_category_name%TYPE;
772: l_v_app_desc gl_interface.reference10%TYPE;
773: l_b_exception_flag BOOLEAN;
774: l_b_waiver_flag BOOLEAN;
775:
776: -- Cursor for selecting the unposted application records

Line 824: -- Create the transactions in the GL interface table

820: g_v_party_number||' :'||
821: get_party_number(apprec.person_id),
822: 1,240);
823:
824: -- Create the transactions in the GL interface table
825: SAVEPOINT SP_APP1;
826: BEGIN
827:
828: insert_gl_int(p_d_gl_date => apprec.gl_date,

Line 845: -- If there is no error in creation of the transaction in the GL Interface table,

841: fnd_file.put_line(fnd_file.log,
842: sqlerrm);
843: END;
844:
845: -- If there is no error in creation of the transaction in the GL Interface table,
846: -- then update the application record with the posting control id and the gl posted date
847: IF NOT l_b_exception_flag THEN
848: igs_fi_applications_pkg.update_row(x_rowid => apprec.row_id,
849: x_application_id => apprec.application_id,

Line 881: transactions to the GL Interface

877:
878: Created By : Amit Gairola
879: Date Created By: 1-Nov-2002
880: Purpose : This procedure will transfer the admission application
881: transactions to the GL Interface
882: Known limitations,enhancements,remarks:
883: Change History
884: Who When What
885: vvutukur 15-Dec-2003 Bug#3310756.Modified cursor cur_adm to check for cash_gl_ccid is not null also.

Line 893: l_v_adm_desc gl_interface.reference10%TYPE;

889: Modified call to igs_ad_app_req_pkg.update_row - added 3 new parameters
890: ********************************************************************************************** */
891: l_b_exception_flag BOOLEAN;
892: l_v_adm_cat gl_je_categories.je_category_name%TYPE;
893: l_v_adm_desc gl_interface.reference10%TYPE;
894:
895: -- Cursor for selecting the records from the admission application table
896: CURSOR cur_adm(cp_gl_date_start DATE,
897: cp_gl_date_end DATE) IS

Line 926: -- Create transactions in the GL Interface table

922: admrec.app_req_id||' ;'||
923: g_v_party_number||' :'||
924: get_party_number(admrec.person_id),1,240);
925:
926: -- Create transactions in the GL Interface table
927: SAVEPOINT SP_ADAPP1;
928: BEGIN
929: insert_gl_int(p_d_gl_date => admrec.gl_date,
930: p_user_cat_name => l_v_adm_cat,

Line 945: -- If there is no error in creating transaction in the GL Interface table,

941: fnd_file.put_line(fnd_file.log,
942: sqlerrm);
943: END;
944:
945: -- If there is no error in creating transaction in the GL Interface table,
946: -- then update the admission application record by the value of the Posting control id
947: -- and the GL Posted Date
948: IF NOT l_b_exception_flag THEN
949: igs_ad_gen_015.update_igs_ad_app_req(

Line 1262: -- If the Posting Detail parameter is DETAIL then pass N to GL Interface

1258: l_n_req_id NUMBER(38);
1259: l_v_post_detail VARCHAR2(1);
1260: BEGIN
1261:
1262: -- If the Posting Detail parameter is DETAIL then pass N to GL Interface
1263: -- Else Y for Create Summary Journal parameter
1264: IF p_v_post_detail = 'DETAIL' THEN
1265: l_v_post_detail := 'N';
1266: ELSE

Line 1271: -- l_n_unique_id := gl_interface_control_pkg.get_unique_run_id;

1267: l_v_post_detail := 'Y';
1268: END IF;
1269:
1270: -- Get the unique run id using the get_unique_run_id procedure
1271: -- l_n_unique_id := gl_interface_control_pkg.get_unique_run_id;
1272:
1273: -- Create a record in the GL_INTERFACE_CONTROL_PKG
1274: /* gl_interface_control_pkg.insert_row(xset_of_books_id => g_n_sob_id,
1275: xinterface_run_id => l_n_unique_id,

Line 1273: -- Create a record in the GL_INTERFACE_CONTROL_PKG

1269:
1270: -- Get the unique run id using the get_unique_run_id procedure
1271: -- l_n_unique_id := gl_interface_control_pkg.get_unique_run_id;
1272:
1273: -- Create a record in the GL_INTERFACE_CONTROL_PKG
1274: /* gl_interface_control_pkg.insert_row(xset_of_books_id => g_n_sob_id,
1275: xinterface_run_id => l_n_unique_id,
1276: xje_source_name => g_v_je_source_name,
1277: xgroup_id => g_n_batch_id,

Line 1274: /* gl_interface_control_pkg.insert_row(xset_of_books_id => g_n_sob_id,

1270: -- Get the unique run id using the get_unique_run_id procedure
1271: -- l_n_unique_id := gl_interface_control_pkg.get_unique_run_id;
1272:
1273: -- Create a record in the GL_INTERFACE_CONTROL_PKG
1274: /* gl_interface_control_pkg.insert_row(xset_of_books_id => g_n_sob_id,
1275: xinterface_run_id => l_n_unique_id,
1276: xje_source_name => g_v_je_source_name,
1277: xgroup_id => g_n_batch_id,
1278: xpacket_id => NULL); */

Line 1319: l_n_dr_amnt gl_interface.entered_dr%TYPE;

1315: agairola 27-Jan-2003 Bug 2711195: Modified the code to display No Data Found in the log file
1316: ********************************************************************************************** */
1317: l_v_line_txt VARCHAR2(80);
1318: l_n_cntr PLS_INTEGER;
1319: l_n_dr_amnt gl_interface.entered_dr%TYPE;
1320: l_n_cr_amnt gl_interface.entered_cr%TYPE;
1321:
1322: -- Cursor for getting the debit and credit amount group by the user_je_category name
1323: CURSOR cur_glint(cp_batch_id NUMBER,

Line 1320: l_n_cr_amnt gl_interface.entered_cr%TYPE;

1316: ********************************************************************************************** */
1317: l_v_line_txt VARCHAR2(80);
1318: l_n_cntr PLS_INTEGER;
1319: l_n_dr_amnt gl_interface.entered_dr%TYPE;
1320: l_n_cr_amnt gl_interface.entered_cr%TYPE;
1321:
1322: -- Cursor for getting the debit and credit amount group by the user_je_category name
1323: CURSOR cur_glint(cp_batch_id NUMBER,
1324: cp_source_name VARCHAR2,

Line 1329: FROM gl_interface

1325: cp_sob_id NUMBER) IS
1326: SELECT user_je_category_name,
1327: SUM(decode(entered_dr,NULL,0,entered_dr)) dr_amnt,
1328: SUM(decode(entered_cr,NULL,0,entered_cr)) cr_amnt
1329: FROM gl_interface
1330: WHERE group_id = cp_batch_id
1331: AND set_of_books_id = cp_sob_id
1332: AND user_je_source_name = cp_source_name
1333: GROUP BY user_je_category_name

Line 1352: -- Loop across the GL Interface table

1348: fnd_message.get);
1349: fnd_file.put_line(fnd_file.log,
1350: l_v_line_txt);
1351:
1352: -- Loop across the GL Interface table
1353: FOR glrec IN cur_glint(g_n_batch_id,
1354: g_v_user_je_src_name,
1355: g_n_sob_id) LOOP
1356: l_n_dr_amnt := NVL(l_n_dr_amnt,0) + NVL(glrec.dr_amnt,0);

Line 1375: -- created in the GL_INTERFACE table,then log the message NO

1371:
1372: fnd_file.new_line(fnd_file.log);
1373:
1374: -- Log the total entered debits and credits. If no data has been
1375: -- created in the GL_INTERFACE table,then log the message NO
1376: -- DATA FOUND
1377: IF g_b_rec_found THEN
1378: fnd_file.put_line(fnd_file.log,
1379: l_v_line_txt);

Line 1409: when the records have been created in the GL_INTERFACE table

1405: Change History
1406: Who When What
1407: sapanigr 05-May-2006 Bug 5178077: Added call to igs_ge_gen_003.set_org_id. to disable process in R12
1408: agairola 27-Jan-2003 Bug 2711195: Modified the code to run the Journal Import only
1409: when the records have been created in the GL_INTERFACE table
1410: ********************************************************************************************** */
1411: l_d_gl_date_start DATE;
1412: l_d_gl_date_end DATE;
1413: l_d_gl_date_posted DATE;

Line 1473: -- If the records have been inserted in the GL_INTERFACE, then

1469:
1470: -- Generate the log
1471: generate_log;
1472:
1473: -- If the records have been inserted in the GL_INTERFACE, then
1474: -- then the Journal Import Process should be run.
1475: IF g_b_rec_found THEN
1476: -- If the Journal Import parameter is Yes, then
1477: IF p_v_jrnl_import = 'Y' THEN

Line 1516: END igs_fi_gl_interface;

1512: sqlerrm);
1513: igs_ge_msg_stack.conc_exception_hndl;
1514: END transfer;
1515:
1516: END igs_fi_gl_interface;