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.IGIRCBAP dependencies on AR_RECEIVABLE_APPLICATIONS

Line 47: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,

43: -- RECORD holder for pertinent information from a receivable application
44: -- of status = 'APP'
45: TYPE ApplicationType IS RECORD
46: (
47: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
48: GLDate DATE, -- the gl date of the application
49: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
50: AppType ar_receivable_applications.application_type%TYPE
51: );

Line 49: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,

45: TYPE ApplicationType IS RECORD
46: (
47: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
48: GLDate DATE, -- the gl date of the application
49: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
50: AppType ar_receivable_applications.application_type%TYPE
51: );
52: --
53: -- holds ApplicationAmount values

Line 50: AppType ar_receivable_applications.application_type%TYPE

46: (
47: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
48: GLDate DATE, -- the gl date of the application
49: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
50: AppType ar_receivable_applications.application_type%TYPE
51: );
52: --
53: -- holds ApplicationAmount values
54: --

Line 1082: -- post ar_receivable_applications that have status UNAPP, UNID, ACC

1078: RAISE;
1079: END;
1080: --
1081: --
1082: -- post ar_receivable_applications that have status UNAPP, UNID, ACC
1083: --
1084: /*---------------------------------------------------------------------------*
1085: | PRIVATE PROCEDURE |
1086: | PostNonDistApplications |

Line 1088: | post unposted ar_receivable_applications records |

1084: /*---------------------------------------------------------------------------*
1085: | PRIVATE PROCEDURE |
1086: | PostNonDistApplications |
1087: | DESCRIPTION |
1088: | post unposted ar_receivable_applications records |
1089: | |
1090: | |
1091: | PARAMETERS |
1092: | |

Line 1125: FROM ar_receivable_applications ra,

1121: ra.amount_applied_from AmountAppFrom,
1122: ra.acctd_amount_applied_from AcctdAmount,
1123: ra.code_combination_id CodeCombinationId,
1124: ra.status Status
1125: FROM ar_receivable_applications ra,
1126: igi_ar_rec_applications igi_ra,
1127: ar_cash_receipts cr
1128: WHERE ra.receivable_application_id = igi_ra.receivable_application_id
1129: AND igi_ra.arc_posting_control_id = p_Post.UnpostedPostingControlId

Line 1143: WritetoLog( l_state_level, 'PostNonDistApplications',' AR_RECEIVABLE_APPLICATIONS (non-app)...' );

1139: --
1140: l_Count NUMBER :=0;
1141: BEGIN
1142: WritetoLog( l_state_level, 'PostNonDistApplications',' ' );
1143: WritetoLog( l_state_level, 'PostNonDistApplications',' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1144: FOR RRa IN CRa
1145: LOOP
1146: BEGIN
1147: INSERT INTO gl_interface

Line 1248: 'AR_RECEIVABLE_APPLICATIONS' -- reference30

1244: decode(RRa.AmountAppFrom,
1245: null,'TRADE','CCURR'), -- reference28
1246: decode(RRa.AmountAppFrom,
1247: null,'TRADE_APP','CCURR_APP'), -- reference29
1248: 'AR_RECEIVABLE_APPLICATIONS' -- reference30
1249: );
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: WritetoLog(l_excep_level, 'PostNonDistApplications','Exception:PostNonDistApplications.INSERT:' );

Line 1288: | post unposted ar_receivable_applications records |

1284: | PRIVATE PROCEDURE |
1285: | PostDistributedApplications |
1286: | |
1287: | DESCRIPTION |
1288: | post unposted ar_receivable_applications records |
1289: | We need to have ORDER BY clause in the select statement because |
1290: | when comparing with Journal Entry report, they need to match, |
1291: | If order by is not used, there will be rounding difference. |
1292: | |

Line 1387: FROM ar_receivable_applications ra,

1383: l.lookup_code,
1384: '1', NVL(ra.receivables_charges_applied,0),
1385: '2', NVL(-ra.receivables_charges_applied,0)
1386: ) ChargesApplied
1387: FROM ar_receivable_applications ra,
1388: igi_ar_rec_applications igira,
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,

Line 1947: from ar_receivable_applications app

1943: arc_posting_control_id = p_Post.UnpostedPostingControlId
1944: WHERE arc_posting_control_id = p_Post.PostingControlId
1945: AND EXISTS
1946: ( select 'x'
1947: from ar_receivable_applications app
1948: where app.receivable_application_id = igiapp.receivable_application_id
1949: and decode(p_CategoryCode,
1950: 'CMAPP',customer_trx_id,
1951: 'TRADE', cash_receipt_id) = p_BalanceId

Line 2047: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;

2043: --
2044: l_plsql_id number;
2045: l_posting_id number;
2046:
2047: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;
2048: isoutofbalance Boolean := FALSE;
2049: l_outofbal_label1 varchar2(240);
2050: l_outofbal_label2 varchar2(240);
2051: l_outofbal_label3 varchar2(240);

Line 2329: FROM ar_receivable_applications app

2325: AND igicrh.arc_posting_control_id = p_PostingControlId;
2326:
2327: SELECT nvl(max(app.receivable_application_id), 999999999999998)+1
2328: INTO l_Post.NxtReceivableApplicationId
2329: FROM ar_receivable_applications app
2330: , igi_ar_rec_applications igiapp
2331: WHERE app.receivable_application_id = igiapp.receivable_application_id
2332: AND igiapp.arc_posting_control_id = p_PostingControlId;
2333: