DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on RA_CUSTOMER_TRX

Line 63: (p_customer_trx IN ra_customer_trx%ROWTYPE,

59: | p_app_rec ar receivable application record
60: | p_ae_sys_rec ar system parameter
61: +-------------------------------------------------------------------------*/
62: PROCEDURE Trx_level_cash_apply
63: (p_customer_trx IN ra_customer_trx%ROWTYPE,
64: p_app_rec IN ar_receivable_applications%ROWTYPE,
65: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
66: p_gt_id IN VARCHAR2 DEFAULT NULL);
67:

Line 87: (p_customer_trx IN ra_customer_trx%ROWTYPE,

83: | p_app_rec ar receivable application record
84: | p_ae_sys_rec ar system parameter
85: +-------------------------------------------------------------------------*/
86: PROCEDURE Trx_gp_level_cash_apply
87: (p_customer_trx IN ra_customer_trx%ROWTYPE,
88: -- p_group_id IN VARCHAR2,
89: --{HYUBPAGP
90: p_source_data_key1 IN VARCHAR2,
91: p_source_data_key2 IN VARCHAR2,

Line 119: (p_customer_trx IN ra_customer_trx%ROWTYPE,

115: | p_app_rec ar receivable application record
116: | p_ae_sys_rec ar system parameter
117: +-------------------------------------------------------------------------*/
118: PROCEDURE Trx_line_level_cash_apply
119: (p_customer_trx IN ra_customer_trx%ROWTYPE,
120: p_customer_trx_line_id IN VARCHAR2,
121: p_log_inv_line IN VARCHAR2 DEFAULT 'N',
122: p_app_rec IN ar_receivable_applications%ROWTYPE,
123: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

Line 144: (p_customer_trx IN ra_customer_trx%ROWTYPE,

140: | p_adj_rec ar adjustment record
141: | p_ae_sys_rec ar system parameter
142: +-------------------------------------------------------------------------*/
143: PROCEDURE Trx_level_direct_adjust
144: (p_customer_trx IN ra_customer_trx%ROWTYPE,
145: p_adj_rec IN ar_adjustments%ROWTYPE,
146: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
147: p_gt_id IN NUMBER DEFAULT NULL);
148:

Line 167: (p_customer_trx IN ra_customer_trx%ROWTYPE,

163: | does not have any activities on it. It should be called |
164: | ideally on transaction completion point |
165: +-----------------------------------------------------------*/
166: PROCEDURE set_original_rem_amt
167: (p_customer_trx IN ra_customer_trx%ROWTYPE,
168: p_adj_id IN NUMBER DEFAULT NULL,
169: p_app_id IN NUMBER DEFAULT NULL,
170: --{HYUNLB
171: p_from_llca IN VARCHAR2 DEFAULT 'N');

Line 177: | trx_lines into ra_customer_trx_lines_gt. |

173: /*-----------------------------------------------------------+
174: | PROCEDURE copy_trx_lines |
175: +-----------------------------------------------------------+
176: | Note: procedure copy the invoice line from ra_customer |
177: | trx_lines into ra_customer_trx_lines_gt. |
178: +-----------------------------------------------------------*/
179: PROCEDURE copy_trx_lines
180: (p_customer_trx_id IN NUMBER,
181: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,

Line 182: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL);

178: +-----------------------------------------------------------*/
179: PROCEDURE copy_trx_lines
180: (p_customer_trx_id IN NUMBER,
181: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
182: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL);
183:
184:
185: /*-----------------------------------------------------------+
186: | PROCEDURE final_update_inv_ctl_rem_orig |

Line 192: (p_customer_trx IN ra_customer_trx%ROWTYPE);

188: | Note: procedure updates the balance on ctl line once user |
189: | commit the activities on the transactions. |
190: +-----------------------------------------------------------*/
191: PROCEDURE final_update_inv_ctl_rem_orig
192: (p_customer_trx IN ra_customer_trx%ROWTYPE);
193:
194:
195: /*-----------------------------------------------------------+
196: | PROCEDURE create_final_split |

Line 202: (p_customer_trx IN ra_customer_trx%ROWTYPE,

198: | Note: procedure creates the detail distributions in |
199: | ar_line_application_detail at commit point |
200: +-----------------------------------------------------------*/
201: PROCEDURE create_final_split
202: (p_customer_trx IN ra_customer_trx%ROWTYPE,
203: p_app_rec IN ar_receivable_applications%ROWTYPE,
204: p_adj_rec IN ar_adjustments%ROWTYPE,
205: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type);
206:

Line 241: (p_customer_trx IN ra_customer_trx%ROWTYPE,

237: | p_app_rec ar receivable application record |
238: | p_ae_sys_rec ar system parameter |
239: +-------------------------------------------------------------------------*/
240: PROCEDURE Trx_level_direct_cash_apply
241: (p_customer_trx IN ra_customer_trx%ROWTYPE,
242: p_app_rec IN ar_receivable_applications%ROWTYPE,
243: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
244: p_gt_id IN NUMBER DEFAULT NULL,
245: p_inv_cm IN VARCHAR2 DEFAULT 'I');

Line 320: p_cust_inv_rec IN ra_customer_trx%ROWTYPE);

316: PROCEDURE exec_adj_api_if_required
317: (p_adj_rec IN ar_adjustments%ROWTYPE,
318: p_app_rec IN ar_receivable_applications%ROWTYPE,
319: p_ae_rule_rec IN ae_rule_rec_type,
320: p_cust_inv_rec IN ra_customer_trx%ROWTYPE);
321:
322: PROCEDURE exec_revrec_if_required
323: ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
324: p_app_rec IN ar_receivable_applications%ROWTYPE,

Line 323: ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

319: p_ae_rule_rec IN ae_rule_rec_type,
320: p_cust_inv_rec IN ra_customer_trx%ROWTYPE);
321:
322: PROCEDURE exec_revrec_if_required
323: ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
324: p_app_rec IN ar_receivable_applications%ROWTYPE,
325: p_adj_rec IN ar_adjustments%ROWTYPE);
326:
327: PROCEDURE update_for_mrc_dist

Line 353: (p_customer_trx IN ra_customer_trx%ROWTYPE,

349: x_out_res OUT NOCOPY VARCHAR2);
350:
351:
352: PROCEDURE online_lazy_apply
353: (p_customer_trx IN ra_customer_trx%ROWTYPE,
354: p_app_rec IN ar_receivable_applications%ROWTYPE,
355: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
356: p_gt_id IN NUMBER,
357: p_inv_cm IN VARCHAR2 DEFAULT 'I');

Line 379: | Read the remaining amount on ra_customer_trx_lines_gt |

375: | x_freight_rem The remaining freight amount for the level TRANSACTION only|
376: | x_charges_rem The remaining charges amount for the level TRANSACTION only|
377: +-----------------------------------------------------------------------------+
378: | Action : |
379: | Read the remaining amount on ra_customer_trx_lines_gt |
380: +-----------------------------------------------------------------------------*/
381: PROCEDURE get_latest_amount_remaining
382: (p_customer_trx_id IN NUMBER,
383: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION',

Line 417: (p_customer_trx IN ra_customer_trx%ROWTYPE,

413: p_uned_line_flag IN VARCHAR2 DEFAULT 'NORMAL',
414: p_uned_tax_flag IN VARCHAR2 DEFAULT 'NORMAL');
415:
416: PROCEDURE adjustment_with_interface
417: (p_customer_trx IN ra_customer_trx%ROWTYPE,
418: p_adj_rec IN ar_adjustments%ROWTYPE,
419: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
420: p_gt_id IN NUMBER,
421: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',

Line 428: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL);

424: x_return_status IN OUT NOCOPY VARCHAR2,
425: x_msg_count IN OUT NOCOPY NUMBER,
426: x_msg_data IN OUT NOCOPY VARCHAR2,
427: p_llca_from_call IN VARCHAR2 DEFAULT NULL,
428: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL);
429:
430: PROCEDURE application_with_interface
431: (p_customer_trx IN ra_customer_trx%ROWTYPE,
432: p_app_rec IN ar_receivable_applications%ROWTYPE,

Line 431: (p_customer_trx IN ra_customer_trx%ROWTYPE,

427: p_llca_from_call IN VARCHAR2 DEFAULT NULL,
428: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL);
429:
430: PROCEDURE application_with_interface
431: (p_customer_trx IN ra_customer_trx%ROWTYPE,
432: p_app_rec IN ar_receivable_applications%ROWTYPE,
433: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
434: p_gt_id IN NUMBER,
435: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',

Line 493: (p_customer_trx IN ra_customer_trx%ROWTYPE,

489: ,x_msg_count OUT NOCOPY NUMBER
490: ,x_msg_data OUT NOCOPY VARCHAR2);
491:
492: PROCEDURE set_original_rem_amt_r12
493: (p_customer_trx IN ra_customer_trx%ROWTYPE,
494: x_return_status IN OUT NOCOPY VARCHAR2,
495: x_msg_count IN OUT NOCOPY NUMBER,
496: x_msg_data IN OUT NOCOPY VARCHAR2,
497: p_from_llca IN VARCHAR2 DEFAULT 'N');