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.AR_INVOICE_VALIDATE_FLEX dependencies on RA_CUSTOMER_TRX_LINES

Line 130: l_context ra_customer_trx_lines.interface_line_context%type;

126: IS
127: l_seg_num number;
128: l_first boolean := TRUE;
129: l_context_index BINARY_INTEGER;
130: l_context ra_customer_trx_lines.interface_line_context%type;
131:
132: BEGIN
133: IF pg_debug = 'Y'
134: THEN

Line 223: l_context ra_customer_trx_lines.interface_line_context%type;

219: p_context_index IN BINARY_INTEGER,
220: p_table_name IN VARCHAR2
221: ) RETURN BINARY_INTEGER IS
222:
223: l_context ra_customer_trx_lines.interface_line_context%type;
224: l_stmt VARCHAR2(2000);
225: l_where_clause VARCHAR2(2000);
226: l_cursor BINARY_INTEGER;
227:

Line 256: | if it is a Global context and for RA_CUSTOMER_TRX_LINES the |

252: /*----------------------------------------------------------------+
253: | Construct additional WHERE clause based on the table that is |
254: | being checked. |
255: | For AR_TRX_LINES_GT, the context is always filled in even |
256: | if it is a Global context and for RA_CUSTOMER_TRX_LINES the |
257: | context is NULL if it is a Global context. Also, do not |
258: | include the current row when checking the uniqueness of the |
259: | transaction flex in RA_CUSTOMER_TRX_LINES |
260: +----------------------------------------------------------------*/

Line 259: | transaction flex in RA_CUSTOMER_TRX_LINES |

255: | For AR_TRX_LINES_GT, the context is always filled in even |
256: | if it is a Global context and for RA_CUSTOMER_TRX_LINES the |
257: | context is NULL if it is a Global context. Also, do not |
258: | include the current row when checking the uniqueness of the |
259: | transaction flex in RA_CUSTOMER_TRX_LINES |
260: +----------------------------------------------------------------*/
261:
262: IF (p_table_name = 'AR_TRX_LINES_GT')
263: THEN

Line 267: ELSIF (p_table_name = 'RA_CUSTOMER_TRX_LINES')

263: THEN
264: l_stmt := l_stmt||' WHERE interface_line_context = '''||
265: nvl(l_context, 'Global Data Elements')||'''';
266: /*l_stmt := l_stmt||' AND NVL(interface_status,''~'') <> ''P'''; */
267: ELSIF (p_table_name = 'RA_CUSTOMER_TRX_LINES')
268: THEN
269: IF (nvl(l_context, 'Global Data Elements') = 'Global Data Elements')
270: THEN
271: l_stmt := l_stmt||' WHERE interface_line_context IS NULL ';

Line 296: IF (p_table_name = 'RA_CUSTOMER_TRX_LINES')

292:
293: l_cursor := dbms_sql.open_cursor;
294: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.v7);
295:
296: IF (p_table_name = 'RA_CUSTOMER_TRX_LINES')
297: THEN pg_ctl_cursors( p_context_index ) := l_cursor;
298: ELSE pg_ril_cursors( p_context_index ) := l_cursor;
299: END IF;
300: IF pg_debug = 'Y'

Line 360: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

356: PROCEDURE Bind_All_Variables(
357: p_ctl_cursor IN OUT NOCOPY BINARY_INTEGER,
358: p_ril_cursor IN OUT NOCOPY BINARY_INTEGER,
359: p_context_index IN BINARY_INTEGER,
360: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
361: p_interface_line_context IN
362: ra_customer_trx_lines.interface_line_context%type,
363: p_interface_line_attribute1 IN
364: ra_customer_trx_lines.interface_line_attribute1%type,

Line 362: ra_customer_trx_lines.interface_line_context%type,

358: p_ril_cursor IN OUT NOCOPY BINARY_INTEGER,
359: p_context_index IN BINARY_INTEGER,
360: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
361: p_interface_line_context IN
362: ra_customer_trx_lines.interface_line_context%type,
363: p_interface_line_attribute1 IN
364: ra_customer_trx_lines.interface_line_attribute1%type,
365: p_interface_line_attribute2 IN
366: ra_customer_trx_lines.interface_line_attribute2%type,

Line 364: ra_customer_trx_lines.interface_line_attribute1%type,

360: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
361: p_interface_line_context IN
362: ra_customer_trx_lines.interface_line_context%type,
363: p_interface_line_attribute1 IN
364: ra_customer_trx_lines.interface_line_attribute1%type,
365: p_interface_line_attribute2 IN
366: ra_customer_trx_lines.interface_line_attribute2%type,
367: p_interface_line_attribute3 IN
368: ra_customer_trx_lines.interface_line_attribute3%type,

Line 366: ra_customer_trx_lines.interface_line_attribute2%type,

362: ra_customer_trx_lines.interface_line_context%type,
363: p_interface_line_attribute1 IN
364: ra_customer_trx_lines.interface_line_attribute1%type,
365: p_interface_line_attribute2 IN
366: ra_customer_trx_lines.interface_line_attribute2%type,
367: p_interface_line_attribute3 IN
368: ra_customer_trx_lines.interface_line_attribute3%type,
369: p_interface_line_attribute4 IN
370: ra_customer_trx_lines.interface_line_attribute4%type,

Line 368: ra_customer_trx_lines.interface_line_attribute3%type,

364: ra_customer_trx_lines.interface_line_attribute1%type,
365: p_interface_line_attribute2 IN
366: ra_customer_trx_lines.interface_line_attribute2%type,
367: p_interface_line_attribute3 IN
368: ra_customer_trx_lines.interface_line_attribute3%type,
369: p_interface_line_attribute4 IN
370: ra_customer_trx_lines.interface_line_attribute4%type,
371: p_interface_line_attribute5 IN
372: ra_customer_trx_lines.interface_line_attribute5%type,

Line 370: ra_customer_trx_lines.interface_line_attribute4%type,

366: ra_customer_trx_lines.interface_line_attribute2%type,
367: p_interface_line_attribute3 IN
368: ra_customer_trx_lines.interface_line_attribute3%type,
369: p_interface_line_attribute4 IN
370: ra_customer_trx_lines.interface_line_attribute4%type,
371: p_interface_line_attribute5 IN
372: ra_customer_trx_lines.interface_line_attribute5%type,
373: p_interface_line_attribute6 IN
374: ra_customer_trx_lines.interface_line_attribute6%type,

Line 372: ra_customer_trx_lines.interface_line_attribute5%type,

368: ra_customer_trx_lines.interface_line_attribute3%type,
369: p_interface_line_attribute4 IN
370: ra_customer_trx_lines.interface_line_attribute4%type,
371: p_interface_line_attribute5 IN
372: ra_customer_trx_lines.interface_line_attribute5%type,
373: p_interface_line_attribute6 IN
374: ra_customer_trx_lines.interface_line_attribute6%type,
375: p_interface_line_attribute7 IN
376: ra_customer_trx_lines.interface_line_attribute7%type,

Line 374: ra_customer_trx_lines.interface_line_attribute6%type,

370: ra_customer_trx_lines.interface_line_attribute4%type,
371: p_interface_line_attribute5 IN
372: ra_customer_trx_lines.interface_line_attribute5%type,
373: p_interface_line_attribute6 IN
374: ra_customer_trx_lines.interface_line_attribute6%type,
375: p_interface_line_attribute7 IN
376: ra_customer_trx_lines.interface_line_attribute7%type,
377: p_interface_line_attribute8 IN
378: ra_customer_trx_lines.interface_line_attribute8%type,

Line 376: ra_customer_trx_lines.interface_line_attribute7%type,

372: ra_customer_trx_lines.interface_line_attribute5%type,
373: p_interface_line_attribute6 IN
374: ra_customer_trx_lines.interface_line_attribute6%type,
375: p_interface_line_attribute7 IN
376: ra_customer_trx_lines.interface_line_attribute7%type,
377: p_interface_line_attribute8 IN
378: ra_customer_trx_lines.interface_line_attribute8%type,
379: p_interface_line_attribute9 IN
380: ra_customer_trx_lines.interface_line_attribute9%type,

Line 378: ra_customer_trx_lines.interface_line_attribute8%type,

374: ra_customer_trx_lines.interface_line_attribute6%type,
375: p_interface_line_attribute7 IN
376: ra_customer_trx_lines.interface_line_attribute7%type,
377: p_interface_line_attribute8 IN
378: ra_customer_trx_lines.interface_line_attribute8%type,
379: p_interface_line_attribute9 IN
380: ra_customer_trx_lines.interface_line_attribute9%type,
381: p_interface_line_attribute10 IN
382: ra_customer_trx_lines.interface_line_attribute10%type,

Line 380: ra_customer_trx_lines.interface_line_attribute9%type,

376: ra_customer_trx_lines.interface_line_attribute7%type,
377: p_interface_line_attribute8 IN
378: ra_customer_trx_lines.interface_line_attribute8%type,
379: p_interface_line_attribute9 IN
380: ra_customer_trx_lines.interface_line_attribute9%type,
381: p_interface_line_attribute10 IN
382: ra_customer_trx_lines.interface_line_attribute10%type,
383: p_interface_line_attribute11 IN
384: ra_customer_trx_lines.interface_line_attribute11%type,

Line 382: ra_customer_trx_lines.interface_line_attribute10%type,

378: ra_customer_trx_lines.interface_line_attribute8%type,
379: p_interface_line_attribute9 IN
380: ra_customer_trx_lines.interface_line_attribute9%type,
381: p_interface_line_attribute10 IN
382: ra_customer_trx_lines.interface_line_attribute10%type,
383: p_interface_line_attribute11 IN
384: ra_customer_trx_lines.interface_line_attribute11%type,
385: p_interface_line_attribute12 IN
386: ra_customer_trx_lines.interface_line_attribute12%type,

Line 384: ra_customer_trx_lines.interface_line_attribute11%type,

380: ra_customer_trx_lines.interface_line_attribute9%type,
381: p_interface_line_attribute10 IN
382: ra_customer_trx_lines.interface_line_attribute10%type,
383: p_interface_line_attribute11 IN
384: ra_customer_trx_lines.interface_line_attribute11%type,
385: p_interface_line_attribute12 IN
386: ra_customer_trx_lines.interface_line_attribute12%type,
387: p_interface_line_attribute13 IN
388: ra_customer_trx_lines.interface_line_attribute13%type,

Line 386: ra_customer_trx_lines.interface_line_attribute12%type,

382: ra_customer_trx_lines.interface_line_attribute10%type,
383: p_interface_line_attribute11 IN
384: ra_customer_trx_lines.interface_line_attribute11%type,
385: p_interface_line_attribute12 IN
386: ra_customer_trx_lines.interface_line_attribute12%type,
387: p_interface_line_attribute13 IN
388: ra_customer_trx_lines.interface_line_attribute13%type,
389: p_interface_line_attribute14 IN
390: ra_customer_trx_lines.interface_line_attribute14%type,

Line 388: ra_customer_trx_lines.interface_line_attribute13%type,

384: ra_customer_trx_lines.interface_line_attribute11%type,
385: p_interface_line_attribute12 IN
386: ra_customer_trx_lines.interface_line_attribute12%type,
387: p_interface_line_attribute13 IN
388: ra_customer_trx_lines.interface_line_attribute13%type,
389: p_interface_line_attribute14 IN
390: ra_customer_trx_lines.interface_line_attribute14%type,
391: p_interface_line_attribute15 IN
392: ra_customer_trx_lines.interface_line_attribute15%type) IS

Line 390: ra_customer_trx_lines.interface_line_attribute14%type,

386: ra_customer_trx_lines.interface_line_attribute12%type,
387: p_interface_line_attribute13 IN
388: ra_customer_trx_lines.interface_line_attribute13%type,
389: p_interface_line_attribute14 IN
390: ra_customer_trx_lines.interface_line_attribute14%type,
391: p_interface_line_attribute15 IN
392: ra_customer_trx_lines.interface_line_attribute15%type) IS
393: BEGIN
394:

Line 392: ra_customer_trx_lines.interface_line_attribute15%type) IS

388: ra_customer_trx_lines.interface_line_attribute13%type,
389: p_interface_line_attribute14 IN
390: ra_customer_trx_lines.interface_line_attribute14%type,
391: p_interface_line_attribute15 IN
392: ra_customer_trx_lines.interface_line_attribute15%type) IS
393: BEGIN
394:
395: IF pg_debug = 'Y'
396: THEN

Line 428: 'RA_CUSTOMER_TRX_LINES'

424: END IF;
425:
426: p_ctl_cursor := Get_Cursor(
427: p_context_index,
428: 'RA_CUSTOMER_TRX_LINES'
429: );
430:
431: Bind_Variable(
432: p_ctl_cursor,

Line 716: ra_customer_trx_lines.customer_trx_line_id%type

712: p_cursor IN OUT NOCOPY BINARY_INTEGER,
713: p_customer_trx_id OUT NOCOPY
714: ra_customer_trx.customer_trx_id%type,
715: p_customer_trx_line_id OUT NOCOPY
716: ra_customer_trx_lines.customer_trx_line_id%type
717: ) RETURN boolean
718: IS
719: l_dummy BINARY_INTEGER;
720: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 721: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

717: ) RETURN boolean
718: IS
719: l_dummy BINARY_INTEGER;
720: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
721: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
722: l_rows NUMBER;
723:
724: BEGIN
725:

Line 744: IF (l_rows > 0 and p_table_name = 'RA_CUSTOMER_TRX_LINES' )

740: | non-unique, |
741: | return FALSE. Otherwise return TRUE |
742: +-------------------------------------------------------------*/
743:
744: IF (l_rows > 0 and p_table_name = 'RA_CUSTOMER_TRX_LINES' )
745: THEN
746: dbms_sql.column_value( p_cursor, 1, l_customer_trx_id);
747: dbms_sql.column_value( p_cursor, 2, l_customer_trx_line_id);
748: p_customer_trx_id := l_customer_trx_id;

Line 792: ra_customer_trx_lines.customer_trx_line_id%type,

788:
789:
790: FUNCTION unique_flex(
791: p_ctl_id IN
792: ra_customer_trx_lines.customer_trx_line_id%type,
793: p_customer_trx_id IN NUMBER,
794: p_customer_trx_line_id IN NUMBER,
795: p_int_line_rec IN
796: interface_line_rec_type )

Line 837: 'RA_CUSTOMER_TRX_LINES'

833: THEN
834:
835: l_ctl_cursor := Get_Cursor(
836: l_context_index,
837: 'RA_CUSTOMER_TRX_LINES'
838: );
839:
840: WHEN OTHERS THEN RAISE;
841: END;

Line 883: | check for the uniqueness of the flex in RA_CUSTOMER_TRX_LINES table |

879: p_int_line_rec.interface_line_attribute14,
880: p_int_line_rec.interface_line_attribute15
881: );
882: /*----------------------------------------------------------------------+
883: | check for the uniqueness of the flex in RA_CUSTOMER_TRX_LINES table |
884: +----------------------------------------------------------------------*/
885: IF (NOT check_uniqueness(
886: 'RA_CUSTOMER_TRX_LINES',
887: l_ctl_cursor,

Line 886: 'RA_CUSTOMER_TRX_LINES',

882: /*----------------------------------------------------------------------+
883: | check for the uniqueness of the flex in RA_CUSTOMER_TRX_LINES table |
884: +----------------------------------------------------------------------*/
885: IF (NOT check_uniqueness(
886: 'RA_CUSTOMER_TRX_LINES',
887: l_ctl_cursor,
888: l_customer_trx_id,
889: l_customer_trx_line_id
890: ) )

Line 1451: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',

1447: p_trx_attr_rec.attribute15 := clFlexAttrRec.attribute15;
1448:
1449: arp_util.Validate_Desc_Flexfield(
1450: p_desc_flex_rec => p_trx_attr_rec,
1451: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1452: p_return_status => x_return_status );
1453:
1454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1455: THEN

Line 1464: 'RA_CUSTOMER_TRX_LINES') ;

1460: invalid_value) values (
1461: clFlexAttrRec.trx_header_id,
1462: clFlexAttrRec.trx_line_id,
1463: arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
1464: 'RA_CUSTOMER_TRX_LINES') ;
1465: END IF;
1466: END LOOP;
1467:
1468: FOR clFlexIntAttrRec IN clFlexIntAttr