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.PSA_XFR_TO_GL_PKG dependencies on GL_INTERFACE

Line 161: ' ##> Trasferring data to GL interface ');

157: Populate_global_variables;
158:
159: -- ========================= FND LOG ===========================
160: psa_utils.debug_other_string(g_state_level,l_full_path,
161: ' ##> Trasferring data to GL interface ');
162: -- ========================= FND LOG ===========================
163:
164: IF arp_global.sysparam.accounting_method = 'ACCRUAL' THEN
165:

Line 345: ' ##> Updating GL interface with proper segments ');

341: END IF;
342:
343: -- ========================= FND LOG ===========================
344: psa_utils.debug_other_string(g_state_level,l_full_path,
345: ' ##> Updating GL interface with proper segments ');
346: -- ========================= FND LOG ===========================
347:
348: Upd_seg_in_gl_interface;
349:

Line 348: Upd_seg_in_gl_interface;

344: psa_utils.debug_other_string(g_state_level,l_full_path,
345: ' ##> Updating GL interface with proper segments ');
346: -- ========================= FND LOG ===========================
347:
348: Upd_seg_in_gl_interface;
349:
350: -- ========================= FND LOG ===========================
351: psa_utils.debug_other_string(g_state_level,l_full_path, ' ');
352: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 431: -- cursor 1 inserts records into gl_interface for a simple misc receipt and its reversal entries.

427: AND crh.posting_control_id = l_pst_ctrl_id;
428:
429:
430: -- GL Transfer will have 4 cursors
431: -- cursor 1 inserts records into gl_interface for a simple misc receipt and its reversal entries.
432: -- Cursor 2 inserts records that reverse core entries
433: -- Cursor 3 inserts records for MFAR Entries resulting from more activties on the receipt (like clearing, unclearing..)
434:
435: CURSOR Cur_MFAR_mrct_lines

Line 702: ' --> Inserting into GL INTERFACE foor - PSA_MF_MISC_DIST_ALL');

698: END;
699:
700: -- ========================= FND LOG ===========================
701: psa_utils.debug_other_string(g_state_level,l_full_path,
702: ' --> Inserting into GL INTERFACE foor - PSA_MF_MISC_DIST_ALL');
703: -- ========================= FND LOG ===========================
704:
705: FOR J IN Cur_MFAR_mrct_lines
706: LOOP

Line 708: INSERT INTO gl_interface

704:
705: FOR J IN Cur_MFAR_mrct_lines
706: LOOP
707:
708: INSERT INTO gl_interface
709: (created_by,
710: date_created,
711: status,
712: actual_flag,

Line 783: ' --> Inserting into GL INTERFACE for - PSA_MF_REVERSE_OF_AR_CRH');

779: END LOOP;
780:
781: -- ========================= FND LOG ===========================
782: psa_utils.debug_other_string(g_state_level,l_full_path,
783: ' --> Inserting into GL INTERFACE for - PSA_MF_REVERSE_OF_AR_CRH');
784: -- ========================= FND LOG ===========================
785:
786: FOR J IN Cur_MFAR_crct_hist_lines
787: LOOP

Line 793: INSERT INTO gl_interface

789: /*
790: ## For each misc_cash_distribution_id the record will be inserted.
791: */
792:
793: INSERT INTO gl_interface
794: (created_by,
795: date_created,
796: status,
797: actual_flag,

Line 868: INSERT INTO gl_interface

864:
865: FOR K IN Cur_MFAR_LINES
866: LOOP
867:
868: INSERT INTO gl_interface
869: (created_by,
870: date_created,
871: status,
872: actual_flag,

Line 943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE

939: END LOOP;
940:
941: /*
942: ## Insert a record into psa_misc_posting to keep track of
943: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
944: */
945:
946: -- ========================= FND LOG ===========================
947: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 1039: ## This procedure will Transfer transactions to gl_interface table like CREDIT MEMO, DEBIT MEMO, CHARGE BACKS.

1035:
1036: v_customer_trx_id NUMBER(15);
1037:
1038: /*
1039: ## This procedure will Transfer transactions to gl_interface table like CREDIT MEMO, DEBIT MEMO, CHARGE BACKS.
1040: */
1041:
1042: /* The l_ variables used in this cursor are Global variables in this package */
1043: CURSOR Cur_MFAR_cust_trx_id

Line 1234: -- Delete core receivables account line (INV_REC) from gl_interface

1230: END IF;
1231: END;
1232:
1233: --
1234: -- Delete core receivables account line (INV_REC) from gl_interface
1235: -- when profile FV: Post Detailed Receipt Accounting = 'N'
1236: --
1237:
1238: -- ========================= FND LOG ===========================

Line 1245: DELETE FROM GL_INTERFACE GI

1241: -- ========================= FND LOG ===========================
1242:
1243: IF l_post_det_acct_flag = 'N' THEN
1244:
1245: DELETE FROM GL_INTERFACE GI
1246: WHERE GI.user_je_source_name = 'Receivables'
1247: AND GI.set_of_books_id = l_sob_id
1248: AND GI.group_id = l_pst_ctrl_id
1249: AND GI.reference29 IN ('INV_REC', 'DM_REC')

Line 1255: ' --> DELETE FROM GL_INTERFACE ' || SQL%ROWCOUNT);

1251: AND GI.reference22 = to_char(I.customer_trx_id);
1252:
1253: -- ========================= FND LOG ===========================
1254: psa_utils.debug_other_string(g_state_level,l_full_path,
1255: ' --> DELETE FROM GL_INTERFACE ' || SQL%ROWCOUNT);
1256: -- ========================= FND LOG ===========================
1257:
1258: END IF;
1259:

Line 1273: INSERT INTO gl_interface

1269: ' --> Customer trx id ==> ' || I.customer_trx_id );
1270: -- ========================= FND LOG ===========================
1271:
1272:
1273: INSERT INTO gl_interface
1274: (created_by,
1275: date_created,
1276: status,
1277: actual_flag,

Line 1336: ' --> Inserting into GL INTERFACE for ==> '

1332:
1333: IF (SQL%FOUND) THEN
1334: -- ========================= FND LOG ===========================
1335: psa_utils.debug_other_string(g_state_level,l_full_path,
1336: ' --> Inserting into GL INTERFACE for ==> '
1337: || I.customer_trx_id );
1338: psa_utils.debug_other_string(g_state_level,l_full_path,
1339: ' CCID => ' || J.ccid
1340: || ' DEBIT => ' || J.entered_dr

Line 1409: /* Bug 3117907 - Create journal lines in gl_interface for on A/c credit memo

1405: END Mfar_trx_to_gl;
1406:
1407: /* ################################## MFAR_RCTS_TO_GL ################################## */
1408:
1409: /* Bug 3117907 - Create journal lines in gl_interface for on A/c credit memo
1410: cur_mfar_rcpt_lines_cm : creates reversal or CM's revenue A/c
1411: creates MFAR revenue account to match the invoice applied.
1412: The following entries created:
1413: 1. Reverse On A/c credit memo's revenue Account

Line 1426: ## This procedure will transfer Receipts to GL INTERFACE.

1422: p_summary_flag IN VARCHAR2)
1423: IS
1424:
1425: /*
1426: ## This procedure will transfer Receipts to GL INTERFACE.
1427: */
1428:
1429: /* The l_ variables used IN this cursor are Global variables in this package */
1430:

Line 1432: -- Loop the GL_INTERFACE insertion for each record in HISTORY table

1428:
1429: /* The l_ variables used IN this cursor are Global variables in this package */
1430:
1431: -- use c_crh_posted to identify the number of transactions that have been posted.
1432: -- Loop the GL_INTERFACE insertion for each record in HISTORY table
1433: -- This helps us create accounting lines for each status change of the receipt.
1434:
1435: Cursor c_crh_posted
1436: IS

Line 1467: -- Added ussgl_transaction_code to cursor cur_mfar_rct_lines and subsequent insert to gl_interface.

1463: AND ra.status = 'APP';
1464:
1465: --
1466: -- Bug 2784180
1467: -- Added ussgl_transaction_code to cursor cur_mfar_rct_lines and subsequent insert to gl_interface.
1468: --
1469:
1470: /*
1471: ###############################################################################

Line 1474: CURSOR mfar_rcpt_lines will insert thw following categories of records in gl_interface

1470: /*
1471: ###############################################################################
1472: Cash management Enhancements:
1473: ----------------------------------
1474: CURSOR mfar_rcpt_lines will insert thw following categories of records in gl_interface
1475: If Payment Method has staus = 'CLEARED' ( No Remittance involved in Receipt processing)
1476: 1. MFAR Receivable Account
1477: 2. MFAR Reversal of Core Receivable Account
1478: 3. MFAR Cash Account

Line 1847: FROM gl_interface gl

1843: CURSOR c_fv_balance_check (c_sob_id NUMBER, c_group_id NUMBER, c_rcv_app_id NUMBER) IS
1844: SELECT to_number(substr(gl.reference22, 1, instr(gl.reference22, 'C')-1)) cash_receipt_id,
1845: sum(accounted_dr) sum_acctd_dr,
1846: sum(accounted_cr) sum_acctd_cr
1847: FROM gl_interface gl
1848: WHERE gl.user_je_source_name = 'Receivables'
1849: AND gl.set_of_books_id = c_sob_id
1850: AND gl.group_id = c_group_id
1851: AND substr(gl.reference29, 7) IN ('CASH', 'REC')

Line 1996: ' --> Inserting into gl interface ');

1992: END IF;
1993:
1994: -- ========================= FND LOG ===========================
1995: psa_utils.debug_other_string(g_state_level,l_full_path,
1996: ' --> Inserting into gl interface ');
1997: -- ========================= FND LOG ===========================
1998:
1999: INSERT INTO gl_interface
2000: (created_by,

Line 1999: INSERT INTO gl_interface

1995: psa_utils.debug_other_string(g_state_level,l_full_path,
1996: ' --> Inserting into gl interface ');
1997: -- ========================= FND LOG ===========================
1998:
1999: INSERT INTO gl_interface
2000: (created_by,
2001: date_created,
2002: status,
2003: actual_flag,

Line 2064: ' --> Inserting into GL INTERFACE for Receipts (Cash Cleared) '||

2060:
2061: IF (SQL%FOUND) THEN
2062: -- ========================= FND LOG ===========================
2063: psa_utils.debug_other_string(g_state_level,l_full_path,
2064: ' --> Inserting into GL INTERFACE for Receipts (Cash Cleared) '||
2065: ' - Receivable Application id ==> ' || I.receivable_application_id);
2066: psa_utils.debug_other_string(g_state_level,l_full_path,
2067: ' CCID => ' || J.ccid
2068: || ' DEBIT => ' || J.entered_dr

Line 2169: DELETE FROM gl_interface gl

2165: -- ========================= FND LOG ===========================
2166:
2167: l_rct_post_det_flag := 'N';
2168:
2169: DELETE FROM gl_interface gl
2170: WHERE gl.user_je_source_name = 'Receivables'
2171: AND gl.set_of_books_id = l_sob_id
2172: AND gl.group_id = l_pst_ctrl_id
2173: AND substr(gl.reference29, 7) IN ('CASH', 'REC')

Line 2179: ' --> DELETE FROM gl_interface -> ' || SQL%ROWCOUNT);

2175: AND to_number(substr(gl.reference22, 1, instr(gl.reference22, 'C')-1)) = l_fv_balance_check.cash_receipt_id;
2176:
2177: -- ========================= FND LOG ===========================
2178: psa_utils.debug_other_string(g_state_level,l_full_path,
2179: ' --> DELETE FROM gl_interface -> ' || SQL%ROWCOUNT);
2180: -- ========================= FND LOG ===========================
2181: ELSE
2182: l_rct_post_det_flag := 'Y';
2183: END IF;

Line 2210: ' --> inserting into gl_interface ');

2206: ' --> inside cursor Cur_mfar_rct_lines ');
2207: psa_utils.debug_other_string(g_state_level,l_full_path,
2208: ' --> Receivable Application id ==> ' || I.receivable_application_id);
2209: psa_utils.debug_other_string(g_state_level,l_full_path,
2210: ' --> inserting into gl_interface ');
2211: -- ========================= FND LOG ===========================
2212:
2213: INSERT INTO gl_interface
2214: (created_by,

Line 2213: INSERT INTO gl_interface

2209: psa_utils.debug_other_string(g_state_level,l_full_path,
2210: ' --> inserting into gl_interface ');
2211: -- ========================= FND LOG ===========================
2212:
2213: INSERT INTO gl_interface
2214: (created_by,
2215: date_created,
2216: status,
2217: actual_flag,

Line 2278: ' --> Inserting into GL INTERFACE for Receipts ' ||

2274:
2275: IF (SQL%FOUND) THEN
2276: -- ========================= FND LOG ===========================
2277: psa_utils.debug_other_string(g_state_level,l_full_path,
2278: ' --> Inserting into GL INTERFACE for Receipts ' ||
2279: ' - Receivable Application id ==> ' || I.receivable_application_id );
2280: psa_utils.debug_other_string(g_state_level,l_full_path,
2281: ' CCID => ' || J.ccid
2282: || ' DEBIT => ' || J.entered_dr

Line 2289: -- Insert accounting lines into gl_interface for on account credit memo

2285: END IF;
2286:
2287: END LOOP;
2288:
2289: -- Insert accounting lines into gl_interface for on account credit memo
2290: -- ========================= FND LOG ===========================
2291: psa_utils.debug_other_string(g_state_level,l_full_path,
2292: ' --> Before cursor Cur_mfar_rct_lines_cm ');
2293: -- ========================= FND LOG ===========================

Line 2310: INSERT INTO gl_interface

2306: psa_utils.debug_other_string(g_state_level,l_full_path,
2307: ' --> Receivable Application id ==> ' || I.receivable_application_id );
2308: -- ========================= FND LOG ===========================
2309:
2310: INSERT INTO gl_interface
2311: (created_by,
2312: date_created,
2313: status,
2314: actual_flag,

Line 2375: ' --> Inserting into GL INTERFACE for Receipts ' ||

2371:
2372: IF (SQL%FOUND) THEN
2373: -- ========================= FND LOG ===========================
2374: psa_utils.debug_other_string(g_state_level,l_full_path,
2375: ' --> Inserting into GL INTERFACE for Receipts ' ||
2376: ' - Receivable Application id ==> ' || I.receivable_application_id );
2377: psa_utils.debug_other_string(g_state_level,l_full_path,
2378: ' CCID => ' || J.ccid
2379: || ' DEBIT => ' || J.entered_dr

Line 2448: ## This will transfer adjustments to gl_interface.

2444: p_summary_flag IN VARCHAR2)
2445: IS
2446:
2447: /*
2448: ## This will transfer adjustments to gl_interface.
2449: */
2450:
2451: /* The l_ variables used in this cursor are Global variables in this package */
2452: CURSOR Cur_lines_to_be_processed

Line 2465: -- Selected the value ussgl_transaction_code in the Cursor below. Also inserted the same value into gl_interface table.

2461: -- Modified cursor to fetch adjustment ccid from ar_distributions
2462: -- New function created get_adj_ccid
2463:
2464: -- Bug 3168282 (Tpradhan)
2465: -- Selected the value ussgl_transaction_code in the Cursor below. Also inserted the same value into gl_interface table.
2466:
2467: CURSOR Cur_mfar_lines (p_adjustment_id NUMBER)
2468: IS
2469: SELECT

Line 2656: DELETE FROM GL_INTERFACE GI

2652: END IF;
2653: END;
2654:
2655: -- Bug 3817595 .. Start
2656: DELETE FROM GL_INTERFACE GI
2657: WHERE GI.user_je_source_name = 'Receivables'
2658: AND GI.set_of_books_id = l_sob_id
2659: AND GI.group_id = l_pst_ctrl_id
2660: AND GI.reference28 = 'ADJ'

Line 2668: ' Deleting rows from Gl interface ' || SQL%ROWCOUNT);

2664: -- Bug 3817595 .. End
2665:
2666: -- ========================= FND LOG ===========================
2667: psa_utils.debug_other_string(g_state_level,l_full_path,
2668: ' Deleting rows from Gl interface ' || SQL%ROWCOUNT);
2669: -- ========================= FND LOG ===========================
2670:
2671: FOR J IN Cur_mfar_lines (I.adjustment_id)
2672: LOOP

Line 2683: INSERT INTO gl_interface

2679: psa_utils.debug_other_string(g_state_level,l_full_path,
2680: ' --> adjustment id ==> ' || I.adjustment_id );
2681: -- ========================= FND LOG ===========================
2682:
2683: INSERT INTO gl_interface
2684: (created_by,
2685: date_created,
2686: status,
2687: actual_flag,

Line 2748: ' --> Inserting into GL INTERFACE for adjustment id ==> '

2744:
2745: IF (SQL%FOUND) THEN
2746: -- ========================= FND LOG ===========================
2747: psa_utils.debug_other_string(g_state_level,l_full_path,
2748: ' --> Inserting into GL INTERFACE for adjustment id ==> '
2749: || I.adjustment_id );
2750: psa_utils.debug_other_string(g_state_level,l_full_path,
2751: ' CCID => ' || J.ccid
2752: || ' DEBIT => ' || J.entered_dr

Line 2809: -- Check whether any CM application is there in gl_interface for any core entries

2805:
2806: -- Bug 3621280.
2807: -- Flow :
2808: -- Get the Balancing or Natural segment based in the Allocation method
2809: -- Check whether any CM application is there in gl_interface for any core entries
2810: -- IF exists then check whether its balanced based on Allocation method
2811: -- IF not balanced then create reversal entry.
2812: --
2813: -- This procedure will be called from transfer_to_gl.

Line 2814: -- And it will process all the CM app records in gl_interface for a group_id.

2810: -- IF exists then check whether its balanced based on Allocation method
2811: -- IF not balanced then create reversal entry.
2812: --
2813: -- This procedure will be called from transfer_to_gl.
2814: -- And it will process all the CM app records in gl_interface for a group_id.
2815: --
2816: -- When you modify the procedure please make sure you modify the debug statements as well.
2817: --
2818:

Line 2833: SELECT distinct reference22 FROM gl_interface

2829: WHERE set_of_books_id = p_sob_id;
2830:
2831: CURSOR Cur_cust_trx_id
2832: IS
2833: SELECT distinct reference22 FROM gl_interface
2834: WHERE group_id = l_pst_ctrl_id
2835: AND reference28 = 'CMAPP'
2836: AND reference29 = 'CMAPP_REC'
2837: AND reference30 = 'AR_RECEIVABLE_APPLICATIONS';

Line 2862: FROM gl_interface

2858: reference27 ref27,
2859: reference28 ref28,
2860: reference29 ref29,
2861: reference30 ref30
2862: FROM gl_interface
2863: WHERE group_id = l_pst_ctrl_id
2864: AND reference22 = p_cust_trx_id
2865: AND reference28 = 'CMAPP'
2866: AND reference29 = 'CMAPP_REC'

Line 2945: -- Picking up details from gl_interface.

2941: psa_utils.debug_other_string(g_state_level,l_full_path,' l_acct_seg_num --> ' || l_acct_seg_num );
2942: -- ========================= FND LOG ===========================
2943: END IF;
2944:
2945: -- Picking up details from gl_interface.
2946: FOR C_cust_trx_dets IN Cur_cust_Trx_id
2947: LOOP
2948:
2949: -- ========================= FND LOG ===========================

Line 2956: ' FROM gl_interface ' ||

2952:
2953: gl_int_dets := gl_int_dets_null;
2954:
2955: l_select := ' SELECT segment' || l_acct_seg_num || ' Segment, SUM(accounted_dr) Debit, SUM(accounted_cr) Credit' ||
2956: ' FROM gl_interface ' ||
2957: ' WHERE reference22 = :1' ||
2958: ' AND reference30 = :2' ||
2959: ' GROUP BY segment' || l_acct_seg_num ||
2960: ' HAVING SUM(nvl(accounted_dr,0)) <> SUM(nvl(accounted_cr,0))' ;

Line 2985: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface');

2981: FOR C_int_dets IN Cur_CM_dets (C_cust_trx_dets.reference22)
2982: LOOP
2983:
2984: -- ========================= FND LOG ===========================
2985: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface');
2986: -- ========================= FND LOG ===========================
2987:
2988: INSERT INTO gl_interface
2989: (created_by,

Line 2988: INSERT INTO gl_interface

2984: -- ========================= FND LOG ===========================
2985: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface');
2986: -- ========================= FND LOG ===========================
2987:
2988: INSERT INTO gl_interface
2989: (created_by,
2990: date_created,
2991: status,
2992: actual_flag,

Line 3049: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface --> ' || SQL%ROWCOUNT);

3045: C_int_dets.ref29,
3046: C_int_dets.ref30);
3047:
3048: -- ========================= FND LOG ===========================
3049: psa_utils.debug_other_string(g_state_level,l_full_path,' Inserting into gl_interface --> ' || SQL%ROWCOUNT);
3050: -- ========================= FND LOG ===========================
3051:
3052: END LOOP;
3053: ELSE

Line 3532: /* ##########################################UPD_SEG_IN_GL_INTERFACE ################################# */

3528:
3529: RETURN l_return_amount;
3530: END get_entered_cr_adj;
3531:
3532: /* ##########################################UPD_SEG_IN_GL_INTERFACE ################################# */
3533:
3534: PROCEDURE Upd_seg_in_gl_interface
3535: IS
3536: -- ========================= FND LOG ===========================

Line 3534: PROCEDURE Upd_seg_in_gl_interface

3530: END get_entered_cr_adj;
3531:
3532: /* ##########################################UPD_SEG_IN_GL_INTERFACE ################################# */
3533:
3534: PROCEDURE Upd_seg_in_gl_interface
3535: IS
3536: -- ========================= FND LOG ===========================
3537: l_full_path VARCHAR2(100) := g_path || 'Upd_seg_in_gl_interface';
3538: -- ========================= FND LOG ===========================

Line 3537: l_full_path VARCHAR2(100) := g_path || 'Upd_seg_in_gl_interface';

3533:
3534: PROCEDURE Upd_seg_in_gl_interface
3535: IS
3536: -- ========================= FND LOG ===========================
3537: l_full_path VARCHAR2(100) := g_path || 'Upd_seg_in_gl_interface';
3538: -- ========================= FND LOG ===========================
3539: BEGIN
3540: -- ========================= FND LOG ===========================
3541: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 3542: ' --> Upd_seg_in_gl_interface - START '

3538: -- ========================= FND LOG ===========================
3539: BEGIN
3540: -- ========================= FND LOG ===========================
3541: psa_utils.debug_other_string(g_state_level,l_full_path,
3542: ' --> Upd_seg_in_gl_interface - START '
3543: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3544: -- ========================= FND LOG ===========================
3545:
3546: UPDATE gl_interface gi

Line 3546: UPDATE gl_interface gi

3542: ' --> Upd_seg_in_gl_interface - START '
3543: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3544: -- ========================= FND LOG ===========================
3545:
3546: UPDATE gl_interface gi
3547: SET (
3548: gi.segment1 , gi.segment2 , gi.segment3 , gi.segment4 , gi.segment5 , gi.segment6 ,
3549: gi.segment7 , gi.segment8 , gi.segment9 , gi.segment10, gi.segment11, gi.segment12,
3550: gi.segment13, gi.segment14, gi.segment15, gi.segment16, gi.segment17, gi.segment18,

Line 3566: ' --> Upd_seg_in_gl_interface - END '

3562: AND reference10 like '%MFAR%';
3563:
3564: -- ========================= FND LOG ===========================
3565: psa_utils.debug_other_string(g_state_level,l_full_path,
3566: ' --> Upd_seg_in_gl_interface - END '
3567: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3568: -- ========================= FND LOG ===========================
3569:
3570: END Upd_seg_in_gl_interface;

Line 3570: END Upd_seg_in_gl_interface;

3566: ' --> Upd_seg_in_gl_interface - END '
3567: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
3568: -- ========================= FND LOG ===========================
3569:
3570: END Upd_seg_in_gl_interface;
3571:
3572:
3573: /* ########################################## GET_ADJ_CCID ################################# */
3574:

Line 3915: FROM gl_interface gl

3911: CURSOR c_fv_balance_check (c_sob_id NUMBER, c_group_id NUMBER, c_rcv_app_id NUMBER) IS
3912: SELECT to_number(substr(gl.reference22, 1, instr(gl.reference22, 'C')-1)) cash_receipt_id,
3913: sum(accounted_dr) sum_acctd_dr,
3914: sum(accounted_cr) sum_acctd_cr
3915: FROM gl_interface gl
3916: WHERE gl.user_je_source_name = 'Receivables'
3917: AND gl.set_of_books_id = c_sob_id
3918: AND gl.group_id = c_group_id
3919: AND substr(gl.reference29, 7) IN ('CASH', 'REC')

Line 3990: DELETE FROM gl_interface gl

3986: l_fv_balance_check.sum_acctd_cr IS NOT NULL ) THEN
3987:
3988: l_rct_post_det_flag := 'N';
3989:
3990: DELETE FROM gl_interface gl
3991: WHERE gl.user_je_source_name = 'Receivables'
3992: AND gl.set_of_books_id = l_sob_id
3993: AND gl.group_id = l_pst_ctrl_id
3994: AND substr(gl.reference29, 7) IN ('CASH', 'REC')

Line 4005: DELETE FROM gl_interface gl

4001: -- 4178626 */
4002: FOR J IN Cur_mfar_rct_lines (I.receivable_application_id)
4003: LOOP
4004:
4005: DELETE FROM gl_interface gl
4006: WHERE gl.user_je_source_name = 'Receivables'
4007: AND gl.set_of_books_id = l_sob_id
4008: AND gl.group_id = l_pst_ctrl_id
4009: AND gl.reference29 = 'TRADE_APP_INV_GL_LINE'

Line 4017: INSERT INTO gl_interface

4013: (select cash_receipt_id
4014: from ar_receivable_applications
4015: where receivable_application_id = I.receivable_application_id);
4016:
4017: INSERT INTO gl_interface
4018: (created_by,
4019: date_created,
4020: status,
4021: actual_flag,

Line 4247: ## Insert into GL_INTERFACE Select from psa_mf_misc_dist_all

4243:
4244: END;
4245:
4246: /*
4247: ## Insert into GL_INTERFACE Select from psa_mf_misc_dist_all
4248: */
4249:
4250: FOR J IN Cur_MFAR_mrct_lines
4251: LOOP

Line 4257: INSERT INTO gl_interface

4253: /*
4254: ## For each misc_cash_distribution_id the record will be inserted.
4255: */
4256:
4257: INSERT INTO gl_interface
4258: (created_by,
4259: date_created,
4260: status,
4261: actual_flag,

Line 4321: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE

4317: END LOOP;
4318:
4319: /*
4320: ## Insert a record into psa_misc_posting to keep track of
4321: ## each reversing record of AR_CASH_RECEIPT_HISTORY, that we insert into GL_INTERFACE
4322: */
4323:
4324: FOR J IN c_crh_post
4325: LOOP