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.ARP_PROCESS_FREIGHT dependencies on RA_CUSTOMER_TRX

Line 42: p_frt_rec IN ra_customer_trx_lines%rowtype)

38: | |
39: +===========================================================================*/
40:
41: PROCEDURE check_frt_line_count(
42: p_frt_rec IN ra_customer_trx_lines%rowtype)
43: IS
44: l_frt_count number;
45:
46: BEGIN

Line 52: FROM ra_customer_trx_lines ctl

48: arp_util.debug('arp_process_freight.check_frt_line_count()+');
49:
50: SELECT count(*)
51: INTO l_frt_count
52: FROM ra_customer_trx_lines ctl
53: WHERE ctl.customer_trx_id = p_frt_rec.customer_trx_id
54: AND ctl.line_type = 'FREIGHT'
55: AND (
56: (

Line 96: | Validates row that is going to be inserted into ra_customer_trx_lines |

92: | PROCEDURE |
93: | validate_insert_freight |
94: | |
95: | DESCRIPTION |
96: | Validates row that is going to be inserted into ra_customer_trx_lines |
97: | |
98: | SCOPE - PRIVATE |
99: | |
100: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 118: p_frt_rec IN ra_customer_trx_lines%rowtype)

114: | |
115: +===========================================================================*/
116:
117: PROCEDURE validate_insert_freight(
118: p_frt_rec IN ra_customer_trx_lines%rowtype)
119: IS
120:
121: BEGIN
122:

Line 169: p_frt_rec IN ra_customer_trx_lines%rowtype)

165: | |
166: +===========================================================================*/
167:
168: PROCEDURE validate_update_freight(
169: p_frt_rec IN ra_customer_trx_lines%rowtype)
170: IS
171:
172: BEGIN
173:

Line 215: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

211: | |
212: +===========================================================================*/
213:
214: PROCEDURE validate_delete_freight(
215: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
216: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
217: p_complete_flag IN ra_customer_trx.complete_flag%type
218: )
219: IS

Line 216: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

212: +===========================================================================*/
213:
214: PROCEDURE validate_delete_freight(
215: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
216: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
217: p_complete_flag IN ra_customer_trx.complete_flag%type
218: )
219: IS
220:

Line 217: p_complete_flag IN ra_customer_trx.complete_flag%type

213:
214: PROCEDURE validate_delete_freight(
215: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
216: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
217: p_complete_flag IN ra_customer_trx.complete_flag%type
218: )
219: IS
220:
221: BEGIN

Line 272: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

268: | 12-JUL-95 Subash Chadalavada Created |
269: | |
270: +===========================================================================*/
271: PROCEDURE set_flags(
272: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
273: p_new_frt_rec IN ra_customer_trx_lines%rowtype,
274: p_new_ccid IN
275: ra_cust_trx_line_gl_dist.code_combination_id%type,
276: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,

Line 273: p_new_frt_rec IN ra_customer_trx_lines%rowtype,

269: | |
270: +===========================================================================*/
271: PROCEDURE set_flags(
272: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
273: p_new_frt_rec IN ra_customer_trx_lines%rowtype,
274: p_new_ccid IN
275: ra_cust_trx_line_gl_dist.code_combination_id%type,
276: p_new_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
277: p_amount_changed_flag OUT NOCOPY boolean,

Line 281: l_old_frt_rec ra_customer_trx_lines%rowtype;

277: p_amount_changed_flag OUT NOCOPY boolean,
278: p_ccid_changed_flag OUT NOCOPY boolean,
279: p_gl_date_changed_flag OUT NOCOPY boolean) IS
280:
281: l_old_frt_rec ra_customer_trx_lines%rowtype;
282: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
283: l_old_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
284:
285: BEGIN

Line 340: | Inserts a freight record into RA_CUSTOMER_TRX_LINES |

336: | PROCEDURE |
337: | insert_freight |
338: | |
339: | DESCRIPTION |
340: | Inserts a freight record into RA_CUSTOMER_TRX_LINES |
341: | |
342: | SCOPE - PRIVATE |
343: | |
344: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 372: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

368:
369: PROCEDURE insert_freight(
370: p_form_name IN varchar2,
371: p_form_version IN number,
372: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
373: p_trx_class IN ra_cust_trx_types.type%type,
374: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
375: p_frt_ccid IN
376: ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 378: ra_customer_trx_lines.customer_trx_line_id%type,

374: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
375: p_frt_ccid IN
376: ra_cust_trx_line_gl_dist.code_combination_id%type,
377: p_customer_trx_line_id OUT NOCOPY
378: ra_customer_trx_lines.customer_trx_line_id%type,
379: p_status OUT NOCOPY varchar2,
380: p_run_autoacc_flag IN varchar2 DEFAULT 'Y')
381:
382: IS

Line 384: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

380: p_run_autoacc_flag IN varchar2 DEFAULT 'Y')
381:
382: IS
383:
384: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
385: l_result integer;
386: l_ccid
387: ra_cust_trx_line_gl_dist.code_combination_id%type;
388: l_concat_segments varchar2(200);

Line 515: | Updates freight record in RA_CUSTOMER_TRX_LINES |

511: | PROCEDURE |
512: | update_freight |
513: | |
514: | DESCRIPTION |
515: | Updates freight record in RA_CUSTOMER_TRX_LINES |
516: | |
517: | SCOPE - PRIVATE |
518: | |
519: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 547: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

543: +===========================================================================*/
544: PROCEDURE update_freight(
545: p_form_name IN varchar2,
546: p_form_version IN number,
547: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
548: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
549: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
550: p_trx_class IN ra_cust_trx_types.type%type,
551: p_gl_date IN

Line 548: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

544: PROCEDURE update_freight(
545: p_form_name IN varchar2,
546: p_form_version IN number,
547: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
548: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
549: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
550: p_trx_class IN ra_cust_trx_types.type%type,
551: p_gl_date IN
552: ra_cust_trx_line_gl_dist.gl_date%type,

Line 549: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,

545: p_form_name IN varchar2,
546: p_form_version IN number,
547: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
548: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
549: p_frt_rec IN OUT NOCOPY ra_customer_trx_lines%rowtype,
550: p_trx_class IN ra_cust_trx_types.type%type,
551: p_gl_date IN
552: ra_cust_trx_line_gl_dist.gl_date%type,
553: p_frt_ccid IN

Line 686: | Deletes freight record from RA_CUSTOMER_TRX_LINES |

682: | PROCEDURE |
683: | delete_freight |
684: | |
685: | DESCRIPTION |
686: | Deletes freight record from RA_CUSTOMER_TRX_LINES |
687: | |
688: | SCOPE - PRIVATE |
689: | |
690: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 721: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

717: p_form_version IN number,
718: p_trx_class IN ra_cust_trx_types.type%type,
719: p_complete_flag IN varchar2,
720: p_open_rec_flag IN varchar2,
721: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
722: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
723: IS
724: l_gt_one_line BOOLEAN;
725:

Line 722: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)

718: p_trx_class IN ra_cust_trx_types.type%type,
719: p_complete_flag IN varchar2,
720: p_open_rec_flag IN varchar2,
721: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
722: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type)
723: IS
724: l_gt_one_line BOOLEAN;
725:
726: /* bug 3604027 */