APPS.ARP_CASH_BASIS_ACCOUNTING dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 2226: | post unposted ar_misc_cash_distributions records |

2222: /*---------------------------------------------------------------------------*
2223: | PRIVATE PROCEDURE |
2224: | PostMiscCashDistributions |
2225: | DESCRIPTION |
2226: | post unposted ar_misc_cash_distributions records |
2227: | within the posting range |
2228: | |
2229: | PARAMETERS |
2230: | |

Line 2258: FROM ar_misc_cash_distributions mcd,

2254: p_Post.UserMisc category,
2255: cr.doc_sequence_id doc_sequence_id,
2256: cr.doc_sequence_value doc_sequence_value,
2257: mcd.ussgl_transaction_code ussgl_transaction_code
2258: FROM ar_misc_cash_distributions mcd,
2259: ar_cash_receipts cr
2260: WHERE mcd.posting_control_id = p_Post.UnpostedPostingControlId
2261: AND mcd.gl_date BETWEEN p_Post.GlDateFrom
2262: AND p_Post.GlDateTo

Line 2282: FROM ar_misc_cash_distributions mcd,

2278: p_Post.UserMisc category,
2279: cr.doc_sequence_id doc_sequence_id,
2280: cr.doc_sequence_value doc_sequence_value,
2281: mcd.ussgl_transaction_code ussgl_transaction_code
2282: FROM ar_misc_cash_distributions mcd,
2283: ar_mc_misc_cash_dists mcd_mrc,
2284: ar_cash_receipts cr
2285: WHERE mcd.posting_control_id = p_Post.UnpostedPostingControlId
2286: AND mcd.gl_date BETWEEN p_Post.GlDateFrom

Line 2302: arp_standard.debug( ' AR_MISC_CASH_DISTRIBUTIONS...' );

2298: l_gl_interface_null gl_interface%ROWTYPE;
2299:
2300: BEGIN
2301: arp_standard.debug( ' ' );
2302: arp_standard.debug( ' AR_MISC_CASH_DISTRIBUTIONS...' );
2303:
2304: -- bug3769452 modified IF condition
2305: IF (p_Post.SetOfBooksType <> 'R')
2306: THEN

Line 2360: l_gl_interface.reference30 := 'AR_MISC_CASH_DISTRIBUTIONS';

2356: l_gl_interface.reference23 := RMcd.MiscCashDistributionId;
2357: l_gl_interface.reference24 := RMcd.ReceiptNumber;
2358: l_gl_interface.reference28 := 'MISC';
2359: l_gl_interface.reference29 := 'MISC_MISC';
2360: l_gl_interface.reference30 := 'AR_MISC_CASH_DISTRIBUTIONS';
2361:
2362: CreateInterface( l_gl_interface );
2363:
2364: --

Line 2365: UPDATE ar_misc_cash_distributions

2361:
2362: CreateInterface( l_gl_interface );
2363:
2364: --
2365: UPDATE ar_misc_cash_distributions
2366: SET posting_control_id = p_Post.PostingControlId,
2367: gl_posted_date = p_Post.GlPostedDate
2368: WHERE ROWID = RMcd.McdRowid;
2369: l_Count := l_Count + 1;

Line 2431: -- l_gl_interface.reference30 := 'AR_MISC_CASH_DISTRIBUTIONS';

2427: -- l_gl_interface.reference23 := RMcd.MiscCashDistributionId;
2428: -- l_gl_interface.reference24 := RMcd.ReceiptNumber;
2429: -- l_gl_interface.reference28 := 'MISC';
2430: -- l_gl_interface.reference29 := 'MISC_MISC';
2431: -- l_gl_interface.reference30 := 'AR_MISC_CASH_DISTRIBUTIONS';
2432:
2433: -- CreateInterface( l_gl_interface ) ;
2434:
2435: --

Line 2527: UPDATE ar_misc_cash_distributions

2523: THEN
2524: -- bug3769452 modified IF condition
2525: IF (p_Post.SetOfBooksType <> 'R')
2526: THEN
2527: UPDATE ar_misc_cash_distributions
2528: SET gl_posted_date = NULL,
2529: posting_control_id = p_Post.UnpostedPostingControlId
2530: WHERE posting_control_id = p_Post.PostingControlId
2531: AND cash_receipt_id = p_BalanceId;