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_TRANS_FLEX dependencies on RA_CUSTOMER_TRX

Line 28: pg_ctl_cursors cursor_tbl_type; -- cursors for ra_customer_trx_lines

24: | Ctx2 1 3 5 |
25: | Ctx3 0 3 |
26: +-------------------------------------------------------------------------*/
27: pg_flex_contexts flex_context_type; -- flex context values
28: pg_ctl_cursors cursor_tbl_type; -- cursors for ra_customer_trx_lines
29: pg_ril_cursors cursor_tbl_type; -- cursors for ra_interface_lines
30: pg_active_segs flex_num_type; -- active segment numbers
31: pg_num_segs flex_num_type; -- number of segments for each context
32: pg_start_loc flex_num_type; -- for a context, index to first

Line 313: l_context ra_customer_trx_lines.interface_line_context%type;

309: IS
310: l_seg_num number;
311: l_first boolean := TRUE;
312: l_context_index BINARY_INTEGER;
313: l_context ra_customer_trx_lines.interface_line_context%type;
314:
315: BEGIN
316:
317: arp_util.debug('arp_trans_flex.build_where_clause()+');

Line 432: ra_customer_trx.customer_trx_id%type,

428:
429: FUNCTION check_uniqueness(
430: p_cursor IN OUT NOCOPY BINARY_INTEGER,
431: p_customer_trx_id OUT NOCOPY
432: ra_customer_trx.customer_trx_id%type,
433: p_customer_trx_line_id OUT NOCOPY
434: ra_customer_trx_lines.customer_trx_line_id%type
435: ) RETURN boolean
436: IS

Line 434: ra_customer_trx_lines.customer_trx_line_id%type

430: p_cursor IN OUT NOCOPY BINARY_INTEGER,
431: p_customer_trx_id OUT NOCOPY
432: ra_customer_trx.customer_trx_id%type,
433: p_customer_trx_line_id OUT NOCOPY
434: ra_customer_trx_lines.customer_trx_line_id%type
435: ) RETURN boolean
436: IS
437: l_dummy BINARY_INTEGER;
438: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 438: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

434: ra_customer_trx_lines.customer_trx_line_id%type
435: ) RETURN boolean
436: IS
437: l_dummy BINARY_INTEGER;
438: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
439: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
440: l_rows NUMBER;
441:
442: BEGIN

Line 439: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

435: ) RETURN boolean
436: IS
437: l_dummy BINARY_INTEGER;
438: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
439: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
440: l_rows NUMBER;
441:
442: BEGIN
443:

Line 525: l_context ra_customer_trx_lines.interface_line_context%type;

521: p_context_index IN BINARY_INTEGER,
522: p_table_name IN VARCHAR2
523: ) RETURN BINARY_INTEGER IS
524:
525: l_context ra_customer_trx_lines.interface_line_context%type;
526: l_stmt VARCHAR2(2000);
527: l_where_clause VARCHAR2(2000);
528: l_cursor BINARY_INTEGER;
529:

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

552: /*----------------------------------------------------------------+
553: | Construct additional WHERE clause based on the table that is |
554: | being checked. |
555: | For RA_INTERFACE_LINES, the context is always filled in even |
556: | if it is a Global context and for RA_CUSTOMER_TRX_LINES the |
557: | context is NULL if it is a Global context. Also, do not |
558: | include the current row when checking the uniqueness of the |
559: | transaction flex in RA_CUSTOMER_TRX_LINES |
560: +----------------------------------------------------------------*/

Line 559: | transaction flex in RA_CUSTOMER_TRX_LINES |

555: | For RA_INTERFACE_LINES, the context is always filled in even |
556: | if it is a Global context and for RA_CUSTOMER_TRX_LINES the |
557: | context is NULL if it is a Global context. Also, do not |
558: | include the current row when checking the uniqueness of the |
559: | transaction flex in RA_CUSTOMER_TRX_LINES |
560: +----------------------------------------------------------------*/
561: /* Bug 1677311: Added condition interface status <> 'P' */
562:
563: IF (p_table_name = 'RA_INTERFACE_LINES')

Line 568: ELSIF (p_table_name = 'RA_CUSTOMER_TRX_LINES')

564: THEN
565: l_stmt := l_stmt||' WHERE interface_line_context = '''||
566: nvl(l_context, 'Global Data Elements')||'''';
567: l_stmt := l_stmt||' AND NVL(interface_status,''~'') <> ''P''';
568: ELSIF (p_table_name = 'RA_CUSTOMER_TRX_LINES')
569: THEN
570: IF (nvl(l_context, 'Global Data Elements') = 'Global Data Elements')
571: THEN
572: l_stmt := l_stmt||' WHERE interface_line_context IS NULL ';

Line 596: IF (p_table_name = 'RA_CUSTOMER_TRX_LINES')

592:
593: l_cursor := dbms_sql.open_cursor;
594: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.v7);
595:
596: IF (p_table_name = 'RA_CUSTOMER_TRX_LINES')
597: THEN pg_ctl_cursors( p_context_index ) := l_cursor;
598: ELSE pg_ril_cursors( p_context_index ) := l_cursor;
599: END IF;
600:

Line 727: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,

723: PROCEDURE Bind_All_Variables(
724: p_ctl_cursor IN OUT NOCOPY BINARY_INTEGER,
725: p_ril_cursor IN OUT NOCOPY BINARY_INTEGER,
726: p_context_index IN BINARY_INTEGER,
727: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
728: p_interface_line_context IN
729: ra_customer_trx_lines.interface_line_context%type,
730: p_interface_line_attribute1 IN
731: ra_customer_trx_lines.interface_line_attribute1%type,

Line 729: ra_customer_trx_lines.interface_line_context%type,

725: p_ril_cursor IN OUT NOCOPY BINARY_INTEGER,
726: p_context_index IN BINARY_INTEGER,
727: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
728: p_interface_line_context IN
729: ra_customer_trx_lines.interface_line_context%type,
730: p_interface_line_attribute1 IN
731: ra_customer_trx_lines.interface_line_attribute1%type,
732: p_interface_line_attribute2 IN
733: ra_customer_trx_lines.interface_line_attribute2%type,

Line 731: ra_customer_trx_lines.interface_line_attribute1%type,

727: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
728: p_interface_line_context IN
729: ra_customer_trx_lines.interface_line_context%type,
730: p_interface_line_attribute1 IN
731: ra_customer_trx_lines.interface_line_attribute1%type,
732: p_interface_line_attribute2 IN
733: ra_customer_trx_lines.interface_line_attribute2%type,
734: p_interface_line_attribute3 IN
735: ra_customer_trx_lines.interface_line_attribute3%type,

Line 733: ra_customer_trx_lines.interface_line_attribute2%type,

729: ra_customer_trx_lines.interface_line_context%type,
730: p_interface_line_attribute1 IN
731: ra_customer_trx_lines.interface_line_attribute1%type,
732: p_interface_line_attribute2 IN
733: ra_customer_trx_lines.interface_line_attribute2%type,
734: p_interface_line_attribute3 IN
735: ra_customer_trx_lines.interface_line_attribute3%type,
736: p_interface_line_attribute4 IN
737: ra_customer_trx_lines.interface_line_attribute4%type,

Line 735: ra_customer_trx_lines.interface_line_attribute3%type,

731: ra_customer_trx_lines.interface_line_attribute1%type,
732: p_interface_line_attribute2 IN
733: ra_customer_trx_lines.interface_line_attribute2%type,
734: p_interface_line_attribute3 IN
735: ra_customer_trx_lines.interface_line_attribute3%type,
736: p_interface_line_attribute4 IN
737: ra_customer_trx_lines.interface_line_attribute4%type,
738: p_interface_line_attribute5 IN
739: ra_customer_trx_lines.interface_line_attribute5%type,

Line 737: ra_customer_trx_lines.interface_line_attribute4%type,

733: ra_customer_trx_lines.interface_line_attribute2%type,
734: p_interface_line_attribute3 IN
735: ra_customer_trx_lines.interface_line_attribute3%type,
736: p_interface_line_attribute4 IN
737: ra_customer_trx_lines.interface_line_attribute4%type,
738: p_interface_line_attribute5 IN
739: ra_customer_trx_lines.interface_line_attribute5%type,
740: p_interface_line_attribute6 IN
741: ra_customer_trx_lines.interface_line_attribute6%type,

Line 739: ra_customer_trx_lines.interface_line_attribute5%type,

735: ra_customer_trx_lines.interface_line_attribute3%type,
736: p_interface_line_attribute4 IN
737: ra_customer_trx_lines.interface_line_attribute4%type,
738: p_interface_line_attribute5 IN
739: ra_customer_trx_lines.interface_line_attribute5%type,
740: p_interface_line_attribute6 IN
741: ra_customer_trx_lines.interface_line_attribute6%type,
742: p_interface_line_attribute7 IN
743: ra_customer_trx_lines.interface_line_attribute7%type,

Line 741: ra_customer_trx_lines.interface_line_attribute6%type,

737: ra_customer_trx_lines.interface_line_attribute4%type,
738: p_interface_line_attribute5 IN
739: ra_customer_trx_lines.interface_line_attribute5%type,
740: p_interface_line_attribute6 IN
741: ra_customer_trx_lines.interface_line_attribute6%type,
742: p_interface_line_attribute7 IN
743: ra_customer_trx_lines.interface_line_attribute7%type,
744: p_interface_line_attribute8 IN
745: ra_customer_trx_lines.interface_line_attribute8%type,

Line 743: ra_customer_trx_lines.interface_line_attribute7%type,

739: ra_customer_trx_lines.interface_line_attribute5%type,
740: p_interface_line_attribute6 IN
741: ra_customer_trx_lines.interface_line_attribute6%type,
742: p_interface_line_attribute7 IN
743: ra_customer_trx_lines.interface_line_attribute7%type,
744: p_interface_line_attribute8 IN
745: ra_customer_trx_lines.interface_line_attribute8%type,
746: p_interface_line_attribute9 IN
747: ra_customer_trx_lines.interface_line_attribute9%type,

Line 745: ra_customer_trx_lines.interface_line_attribute8%type,

741: ra_customer_trx_lines.interface_line_attribute6%type,
742: p_interface_line_attribute7 IN
743: ra_customer_trx_lines.interface_line_attribute7%type,
744: p_interface_line_attribute8 IN
745: ra_customer_trx_lines.interface_line_attribute8%type,
746: p_interface_line_attribute9 IN
747: ra_customer_trx_lines.interface_line_attribute9%type,
748: p_interface_line_attribute10 IN
749: ra_customer_trx_lines.interface_line_attribute10%type,

Line 747: ra_customer_trx_lines.interface_line_attribute9%type,

743: ra_customer_trx_lines.interface_line_attribute7%type,
744: p_interface_line_attribute8 IN
745: ra_customer_trx_lines.interface_line_attribute8%type,
746: p_interface_line_attribute9 IN
747: ra_customer_trx_lines.interface_line_attribute9%type,
748: p_interface_line_attribute10 IN
749: ra_customer_trx_lines.interface_line_attribute10%type,
750: p_interface_line_attribute11 IN
751: ra_customer_trx_lines.interface_line_attribute11%type,

Line 749: ra_customer_trx_lines.interface_line_attribute10%type,

745: ra_customer_trx_lines.interface_line_attribute8%type,
746: p_interface_line_attribute9 IN
747: ra_customer_trx_lines.interface_line_attribute9%type,
748: p_interface_line_attribute10 IN
749: ra_customer_trx_lines.interface_line_attribute10%type,
750: p_interface_line_attribute11 IN
751: ra_customer_trx_lines.interface_line_attribute11%type,
752: p_interface_line_attribute12 IN
753: ra_customer_trx_lines.interface_line_attribute12%type,

Line 751: ra_customer_trx_lines.interface_line_attribute11%type,

747: ra_customer_trx_lines.interface_line_attribute9%type,
748: p_interface_line_attribute10 IN
749: ra_customer_trx_lines.interface_line_attribute10%type,
750: p_interface_line_attribute11 IN
751: ra_customer_trx_lines.interface_line_attribute11%type,
752: p_interface_line_attribute12 IN
753: ra_customer_trx_lines.interface_line_attribute12%type,
754: p_interface_line_attribute13 IN
755: ra_customer_trx_lines.interface_line_attribute13%type,

Line 753: ra_customer_trx_lines.interface_line_attribute12%type,

749: ra_customer_trx_lines.interface_line_attribute10%type,
750: p_interface_line_attribute11 IN
751: ra_customer_trx_lines.interface_line_attribute11%type,
752: p_interface_line_attribute12 IN
753: ra_customer_trx_lines.interface_line_attribute12%type,
754: p_interface_line_attribute13 IN
755: ra_customer_trx_lines.interface_line_attribute13%type,
756: p_interface_line_attribute14 IN
757: ra_customer_trx_lines.interface_line_attribute14%type,

Line 755: ra_customer_trx_lines.interface_line_attribute13%type,

751: ra_customer_trx_lines.interface_line_attribute11%type,
752: p_interface_line_attribute12 IN
753: ra_customer_trx_lines.interface_line_attribute12%type,
754: p_interface_line_attribute13 IN
755: ra_customer_trx_lines.interface_line_attribute13%type,
756: p_interface_line_attribute14 IN
757: ra_customer_trx_lines.interface_line_attribute14%type,
758: p_interface_line_attribute15 IN
759: ra_customer_trx_lines.interface_line_attribute15%type) IS

Line 757: ra_customer_trx_lines.interface_line_attribute14%type,

753: ra_customer_trx_lines.interface_line_attribute12%type,
754: p_interface_line_attribute13 IN
755: ra_customer_trx_lines.interface_line_attribute13%type,
756: p_interface_line_attribute14 IN
757: ra_customer_trx_lines.interface_line_attribute14%type,
758: p_interface_line_attribute15 IN
759: ra_customer_trx_lines.interface_line_attribute15%type) IS
760: BEGIN
761:

Line 759: ra_customer_trx_lines.interface_line_attribute15%type) IS

755: ra_customer_trx_lines.interface_line_attribute13%type,
756: p_interface_line_attribute14 IN
757: ra_customer_trx_lines.interface_line_attribute14%type,
758: p_interface_line_attribute15 IN
759: ra_customer_trx_lines.interface_line_attribute15%type) IS
760: BEGIN
761:
762: arp_util.debug('arp_trans_flex.Bind_All_Variables()+');
763:

Line 766: | Bind variables into the ra_customer_trx_line cursor |

762: arp_util.debug('arp_trans_flex.Bind_All_Variables()+');
763:
764:
765: /*-------------------------------------------------------+
766: | Bind variables into the ra_customer_trx_line cursor |
767: +-------------------------------------------------------*/
768:
769: BEGIN
770: Bind_Variable(

Line 789: 'RA_CUSTOMER_TRX_LINES'

785: arp_util.debug('Handling INVALID_CURSOR exception by reparsing');
786:
787: p_ctl_cursor := Get_Cursor(
788: p_context_index,
789: 'RA_CUSTOMER_TRX_LINES'
790: );
791:
792: Bind_Variable(
793: p_ctl_cursor,

Line 1114: ra_customer_trx_lines.customer_trx_line_id%type,

1110: +===========================================================================*/
1111:
1112: FUNCTION unique_trans_flex(
1113: p_ctl_id IN
1114: ra_customer_trx_lines.customer_trx_line_id%type,
1115: p_interface_line_context IN
1116: ra_customer_trx_lines.interface_line_context%type,
1117: p_interface_line_attribute1 IN
1118: ra_customer_trx_lines.interface_line_attribute1%type,

Line 1116: ra_customer_trx_lines.interface_line_context%type,

1112: FUNCTION unique_trans_flex(
1113: p_ctl_id IN
1114: ra_customer_trx_lines.customer_trx_line_id%type,
1115: p_interface_line_context IN
1116: ra_customer_trx_lines.interface_line_context%type,
1117: p_interface_line_attribute1 IN
1118: ra_customer_trx_lines.interface_line_attribute1%type,
1119: p_interface_line_attribute2 IN
1120: ra_customer_trx_lines.interface_line_attribute2%type,

Line 1118: ra_customer_trx_lines.interface_line_attribute1%type,

1114: ra_customer_trx_lines.customer_trx_line_id%type,
1115: p_interface_line_context IN
1116: ra_customer_trx_lines.interface_line_context%type,
1117: p_interface_line_attribute1 IN
1118: ra_customer_trx_lines.interface_line_attribute1%type,
1119: p_interface_line_attribute2 IN
1120: ra_customer_trx_lines.interface_line_attribute2%type,
1121: p_interface_line_attribute3 IN
1122: ra_customer_trx_lines.interface_line_attribute3%type,

Line 1120: ra_customer_trx_lines.interface_line_attribute2%type,

1116: ra_customer_trx_lines.interface_line_context%type,
1117: p_interface_line_attribute1 IN
1118: ra_customer_trx_lines.interface_line_attribute1%type,
1119: p_interface_line_attribute2 IN
1120: ra_customer_trx_lines.interface_line_attribute2%type,
1121: p_interface_line_attribute3 IN
1122: ra_customer_trx_lines.interface_line_attribute3%type,
1123: p_interface_line_attribute4 IN
1124: ra_customer_trx_lines.interface_line_attribute4%type,

Line 1122: ra_customer_trx_lines.interface_line_attribute3%type,

1118: ra_customer_trx_lines.interface_line_attribute1%type,
1119: p_interface_line_attribute2 IN
1120: ra_customer_trx_lines.interface_line_attribute2%type,
1121: p_interface_line_attribute3 IN
1122: ra_customer_trx_lines.interface_line_attribute3%type,
1123: p_interface_line_attribute4 IN
1124: ra_customer_trx_lines.interface_line_attribute4%type,
1125: p_interface_line_attribute5 IN
1126: ra_customer_trx_lines.interface_line_attribute5%type,

Line 1124: ra_customer_trx_lines.interface_line_attribute4%type,

1120: ra_customer_trx_lines.interface_line_attribute2%type,
1121: p_interface_line_attribute3 IN
1122: ra_customer_trx_lines.interface_line_attribute3%type,
1123: p_interface_line_attribute4 IN
1124: ra_customer_trx_lines.interface_line_attribute4%type,
1125: p_interface_line_attribute5 IN
1126: ra_customer_trx_lines.interface_line_attribute5%type,
1127: p_interface_line_attribute6 IN
1128: ra_customer_trx_lines.interface_line_attribute6%type,

Line 1126: ra_customer_trx_lines.interface_line_attribute5%type,

1122: ra_customer_trx_lines.interface_line_attribute3%type,
1123: p_interface_line_attribute4 IN
1124: ra_customer_trx_lines.interface_line_attribute4%type,
1125: p_interface_line_attribute5 IN
1126: ra_customer_trx_lines.interface_line_attribute5%type,
1127: p_interface_line_attribute6 IN
1128: ra_customer_trx_lines.interface_line_attribute6%type,
1129: p_interface_line_attribute7 IN
1130: ra_customer_trx_lines.interface_line_attribute7%type,

Line 1128: ra_customer_trx_lines.interface_line_attribute6%type,

1124: ra_customer_trx_lines.interface_line_attribute4%type,
1125: p_interface_line_attribute5 IN
1126: ra_customer_trx_lines.interface_line_attribute5%type,
1127: p_interface_line_attribute6 IN
1128: ra_customer_trx_lines.interface_line_attribute6%type,
1129: p_interface_line_attribute7 IN
1130: ra_customer_trx_lines.interface_line_attribute7%type,
1131: p_interface_line_attribute8 IN
1132: ra_customer_trx_lines.interface_line_attribute8%type,

Line 1130: ra_customer_trx_lines.interface_line_attribute7%type,

1126: ra_customer_trx_lines.interface_line_attribute5%type,
1127: p_interface_line_attribute6 IN
1128: ra_customer_trx_lines.interface_line_attribute6%type,
1129: p_interface_line_attribute7 IN
1130: ra_customer_trx_lines.interface_line_attribute7%type,
1131: p_interface_line_attribute8 IN
1132: ra_customer_trx_lines.interface_line_attribute8%type,
1133: p_interface_line_attribute9 IN
1134: ra_customer_trx_lines.interface_line_attribute9%type,

Line 1132: ra_customer_trx_lines.interface_line_attribute8%type,

1128: ra_customer_trx_lines.interface_line_attribute6%type,
1129: p_interface_line_attribute7 IN
1130: ra_customer_trx_lines.interface_line_attribute7%type,
1131: p_interface_line_attribute8 IN
1132: ra_customer_trx_lines.interface_line_attribute8%type,
1133: p_interface_line_attribute9 IN
1134: ra_customer_trx_lines.interface_line_attribute9%type,
1135: p_interface_line_attribute10 IN
1136: ra_customer_trx_lines.interface_line_attribute10%type,

Line 1134: ra_customer_trx_lines.interface_line_attribute9%type,

1130: ra_customer_trx_lines.interface_line_attribute7%type,
1131: p_interface_line_attribute8 IN
1132: ra_customer_trx_lines.interface_line_attribute8%type,
1133: p_interface_line_attribute9 IN
1134: ra_customer_trx_lines.interface_line_attribute9%type,
1135: p_interface_line_attribute10 IN
1136: ra_customer_trx_lines.interface_line_attribute10%type,
1137: p_interface_line_attribute11 IN
1138: ra_customer_trx_lines.interface_line_attribute11%type,

Line 1136: ra_customer_trx_lines.interface_line_attribute10%type,

1132: ra_customer_trx_lines.interface_line_attribute8%type,
1133: p_interface_line_attribute9 IN
1134: ra_customer_trx_lines.interface_line_attribute9%type,
1135: p_interface_line_attribute10 IN
1136: ra_customer_trx_lines.interface_line_attribute10%type,
1137: p_interface_line_attribute11 IN
1138: ra_customer_trx_lines.interface_line_attribute11%type,
1139: p_interface_line_attribute12 IN
1140: ra_customer_trx_lines.interface_line_attribute12%type,

Line 1138: ra_customer_trx_lines.interface_line_attribute11%type,

1134: ra_customer_trx_lines.interface_line_attribute9%type,
1135: p_interface_line_attribute10 IN
1136: ra_customer_trx_lines.interface_line_attribute10%type,
1137: p_interface_line_attribute11 IN
1138: ra_customer_trx_lines.interface_line_attribute11%type,
1139: p_interface_line_attribute12 IN
1140: ra_customer_trx_lines.interface_line_attribute12%type,
1141: p_interface_line_attribute13 IN
1142: ra_customer_trx_lines.interface_line_attribute13%type,

Line 1140: ra_customer_trx_lines.interface_line_attribute12%type,

1136: ra_customer_trx_lines.interface_line_attribute10%type,
1137: p_interface_line_attribute11 IN
1138: ra_customer_trx_lines.interface_line_attribute11%type,
1139: p_interface_line_attribute12 IN
1140: ra_customer_trx_lines.interface_line_attribute12%type,
1141: p_interface_line_attribute13 IN
1142: ra_customer_trx_lines.interface_line_attribute13%type,
1143: p_interface_line_attribute14 IN
1144: ra_customer_trx_lines.interface_line_attribute14%type,

Line 1142: ra_customer_trx_lines.interface_line_attribute13%type,

1138: ra_customer_trx_lines.interface_line_attribute11%type,
1139: p_interface_line_attribute12 IN
1140: ra_customer_trx_lines.interface_line_attribute12%type,
1141: p_interface_line_attribute13 IN
1142: ra_customer_trx_lines.interface_line_attribute13%type,
1143: p_interface_line_attribute14 IN
1144: ra_customer_trx_lines.interface_line_attribute14%type,
1145: p_interface_line_attribute15 IN
1146: ra_customer_trx_lines.interface_line_attribute15%type,

Line 1144: ra_customer_trx_lines.interface_line_attribute14%type,

1140: ra_customer_trx_lines.interface_line_attribute12%type,
1141: p_interface_line_attribute13 IN
1142: ra_customer_trx_lines.interface_line_attribute13%type,
1143: p_interface_line_attribute14 IN
1144: ra_customer_trx_lines.interface_line_attribute14%type,
1145: p_interface_line_attribute15 IN
1146: ra_customer_trx_lines.interface_line_attribute15%type,
1147: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1148: p_customer_trx_line_id OUT NOCOPY

Line 1146: ra_customer_trx_lines.interface_line_attribute15%type,

1142: ra_customer_trx_lines.interface_line_attribute13%type,
1143: p_interface_line_attribute14 IN
1144: ra_customer_trx_lines.interface_line_attribute14%type,
1145: p_interface_line_attribute15 IN
1146: ra_customer_trx_lines.interface_line_attribute15%type,
1147: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1148: p_customer_trx_line_id OUT NOCOPY
1149: ra_customer_trx_lines.customer_trx_line_id%type)
1150: RETURN boolean IS

Line 1147: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

1143: p_interface_line_attribute14 IN
1144: ra_customer_trx_lines.interface_line_attribute14%type,
1145: p_interface_line_attribute15 IN
1146: ra_customer_trx_lines.interface_line_attribute15%type,
1147: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1148: p_customer_trx_line_id OUT NOCOPY
1149: ra_customer_trx_lines.customer_trx_line_id%type)
1150: RETURN boolean IS
1151:

Line 1149: ra_customer_trx_lines.customer_trx_line_id%type)

1145: p_interface_line_attribute15 IN
1146: ra_customer_trx_lines.interface_line_attribute15%type,
1147: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1148: p_customer_trx_line_id OUT NOCOPY
1149: ra_customer_trx_lines.customer_trx_line_id%type)
1150: RETURN boolean IS
1151:
1152: l_seg_value seg_value_type;
1153: l_where_clause varchar2(1000);

Line 1183: 'RA_CUSTOMER_TRX_LINES'

1179: EXCEPTION
1180: WHEN NO_DATA_FOUND
1181: THEN l_ctl_cursor := Get_Cursor(
1182: l_context_index,
1183: 'RA_CUSTOMER_TRX_LINES'
1184: );
1185: WHEN OTHERS THEN RAISE;
1186: END;
1187:

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

1220: p_interface_line_attribute15
1221: );
1222:
1223: /*----------------------------------------------------------------------+
1224: | check for the uniqueness of the flex in RA_CUSTOMER_TRX_LINES table |
1225: +----------------------------------------------------------------------*/
1226: IF (NOT check_uniqueness(
1227: l_ctl_cursor,
1228: p_customer_trx_id,

Line 1291: ra_customer_trx_lines.customer_trx_line_id%type,

1287: END;
1288:
1289: FUNCTION unique_trans_flex(
1290: p_ctl_id IN
1291: ra_customer_trx_lines.customer_trx_line_id%type,
1292: p_interface_line_context IN
1293: ra_customer_trx_lines.interface_line_context%type,
1294: p_interface_line_attribute1 IN
1295: ra_customer_trx_lines.interface_line_attribute1%type,

Line 1293: ra_customer_trx_lines.interface_line_context%type,

1289: FUNCTION unique_trans_flex(
1290: p_ctl_id IN
1291: ra_customer_trx_lines.customer_trx_line_id%type,
1292: p_interface_line_context IN
1293: ra_customer_trx_lines.interface_line_context%type,
1294: p_interface_line_attribute1 IN
1295: ra_customer_trx_lines.interface_line_attribute1%type,
1296: p_interface_line_attribute2 IN
1297: ra_customer_trx_lines.interface_line_attribute2%type,

Line 1295: ra_customer_trx_lines.interface_line_attribute1%type,

1291: ra_customer_trx_lines.customer_trx_line_id%type,
1292: p_interface_line_context IN
1293: ra_customer_trx_lines.interface_line_context%type,
1294: p_interface_line_attribute1 IN
1295: ra_customer_trx_lines.interface_line_attribute1%type,
1296: p_interface_line_attribute2 IN
1297: ra_customer_trx_lines.interface_line_attribute2%type,
1298: p_interface_line_attribute3 IN
1299: ra_customer_trx_lines.interface_line_attribute3%type,

Line 1297: ra_customer_trx_lines.interface_line_attribute2%type,

1293: ra_customer_trx_lines.interface_line_context%type,
1294: p_interface_line_attribute1 IN
1295: ra_customer_trx_lines.interface_line_attribute1%type,
1296: p_interface_line_attribute2 IN
1297: ra_customer_trx_lines.interface_line_attribute2%type,
1298: p_interface_line_attribute3 IN
1299: ra_customer_trx_lines.interface_line_attribute3%type,
1300: p_interface_line_attribute4 IN
1301: ra_customer_trx_lines.interface_line_attribute4%type,

Line 1299: ra_customer_trx_lines.interface_line_attribute3%type,

1295: ra_customer_trx_lines.interface_line_attribute1%type,
1296: p_interface_line_attribute2 IN
1297: ra_customer_trx_lines.interface_line_attribute2%type,
1298: p_interface_line_attribute3 IN
1299: ra_customer_trx_lines.interface_line_attribute3%type,
1300: p_interface_line_attribute4 IN
1301: ra_customer_trx_lines.interface_line_attribute4%type,
1302: p_interface_line_attribute5 IN
1303: ra_customer_trx_lines.interface_line_attribute5%type,

Line 1301: ra_customer_trx_lines.interface_line_attribute4%type,

1297: ra_customer_trx_lines.interface_line_attribute2%type,
1298: p_interface_line_attribute3 IN
1299: ra_customer_trx_lines.interface_line_attribute3%type,
1300: p_interface_line_attribute4 IN
1301: ra_customer_trx_lines.interface_line_attribute4%type,
1302: p_interface_line_attribute5 IN
1303: ra_customer_trx_lines.interface_line_attribute5%type,
1304: p_interface_line_attribute6 IN
1305: ra_customer_trx_lines.interface_line_attribute6%type,

Line 1303: ra_customer_trx_lines.interface_line_attribute5%type,

1299: ra_customer_trx_lines.interface_line_attribute3%type,
1300: p_interface_line_attribute4 IN
1301: ra_customer_trx_lines.interface_line_attribute4%type,
1302: p_interface_line_attribute5 IN
1303: ra_customer_trx_lines.interface_line_attribute5%type,
1304: p_interface_line_attribute6 IN
1305: ra_customer_trx_lines.interface_line_attribute6%type,
1306: p_interface_line_attribute7 IN
1307: ra_customer_trx_lines.interface_line_attribute7%type,

Line 1305: ra_customer_trx_lines.interface_line_attribute6%type,

1301: ra_customer_trx_lines.interface_line_attribute4%type,
1302: p_interface_line_attribute5 IN
1303: ra_customer_trx_lines.interface_line_attribute5%type,
1304: p_interface_line_attribute6 IN
1305: ra_customer_trx_lines.interface_line_attribute6%type,
1306: p_interface_line_attribute7 IN
1307: ra_customer_trx_lines.interface_line_attribute7%type,
1308: p_interface_line_attribute8 IN
1309: ra_customer_trx_lines.interface_line_attribute8%type,

Line 1307: ra_customer_trx_lines.interface_line_attribute7%type,

1303: ra_customer_trx_lines.interface_line_attribute5%type,
1304: p_interface_line_attribute6 IN
1305: ra_customer_trx_lines.interface_line_attribute6%type,
1306: p_interface_line_attribute7 IN
1307: ra_customer_trx_lines.interface_line_attribute7%type,
1308: p_interface_line_attribute8 IN
1309: ra_customer_trx_lines.interface_line_attribute8%type,
1310: p_interface_line_attribute9 IN
1311: ra_customer_trx_lines.interface_line_attribute9%type,

Line 1309: ra_customer_trx_lines.interface_line_attribute8%type,

1305: ra_customer_trx_lines.interface_line_attribute6%type,
1306: p_interface_line_attribute7 IN
1307: ra_customer_trx_lines.interface_line_attribute7%type,
1308: p_interface_line_attribute8 IN
1309: ra_customer_trx_lines.interface_line_attribute8%type,
1310: p_interface_line_attribute9 IN
1311: ra_customer_trx_lines.interface_line_attribute9%type,
1312: p_interface_line_attribute10 IN
1313: ra_customer_trx_lines.interface_line_attribute10%type,

Line 1311: ra_customer_trx_lines.interface_line_attribute9%type,

1307: ra_customer_trx_lines.interface_line_attribute7%type,
1308: p_interface_line_attribute8 IN
1309: ra_customer_trx_lines.interface_line_attribute8%type,
1310: p_interface_line_attribute9 IN
1311: ra_customer_trx_lines.interface_line_attribute9%type,
1312: p_interface_line_attribute10 IN
1313: ra_customer_trx_lines.interface_line_attribute10%type,
1314: p_interface_line_attribute11 IN
1315: ra_customer_trx_lines.interface_line_attribute11%type,

Line 1313: ra_customer_trx_lines.interface_line_attribute10%type,

1309: ra_customer_trx_lines.interface_line_attribute8%type,
1310: p_interface_line_attribute9 IN
1311: ra_customer_trx_lines.interface_line_attribute9%type,
1312: p_interface_line_attribute10 IN
1313: ra_customer_trx_lines.interface_line_attribute10%type,
1314: p_interface_line_attribute11 IN
1315: ra_customer_trx_lines.interface_line_attribute11%type,
1316: p_interface_line_attribute12 IN
1317: ra_customer_trx_lines.interface_line_attribute12%type,

Line 1315: ra_customer_trx_lines.interface_line_attribute11%type,

1311: ra_customer_trx_lines.interface_line_attribute9%type,
1312: p_interface_line_attribute10 IN
1313: ra_customer_trx_lines.interface_line_attribute10%type,
1314: p_interface_line_attribute11 IN
1315: ra_customer_trx_lines.interface_line_attribute11%type,
1316: p_interface_line_attribute12 IN
1317: ra_customer_trx_lines.interface_line_attribute12%type,
1318: p_interface_line_attribute13 IN
1319: ra_customer_trx_lines.interface_line_attribute13%type,

Line 1317: ra_customer_trx_lines.interface_line_attribute12%type,

1313: ra_customer_trx_lines.interface_line_attribute10%type,
1314: p_interface_line_attribute11 IN
1315: ra_customer_trx_lines.interface_line_attribute11%type,
1316: p_interface_line_attribute12 IN
1317: ra_customer_trx_lines.interface_line_attribute12%type,
1318: p_interface_line_attribute13 IN
1319: ra_customer_trx_lines.interface_line_attribute13%type,
1320: p_interface_line_attribute14 IN
1321: ra_customer_trx_lines.interface_line_attribute14%type,

Line 1319: ra_customer_trx_lines.interface_line_attribute13%type,

1315: ra_customer_trx_lines.interface_line_attribute11%type,
1316: p_interface_line_attribute12 IN
1317: ra_customer_trx_lines.interface_line_attribute12%type,
1318: p_interface_line_attribute13 IN
1319: ra_customer_trx_lines.interface_line_attribute13%type,
1320: p_interface_line_attribute14 IN
1321: ra_customer_trx_lines.interface_line_attribute14%type,
1322: p_interface_line_attribute15 IN
1323: ra_customer_trx_lines.interface_line_attribute15%type)

Line 1321: ra_customer_trx_lines.interface_line_attribute14%type,

1317: ra_customer_trx_lines.interface_line_attribute12%type,
1318: p_interface_line_attribute13 IN
1319: ra_customer_trx_lines.interface_line_attribute13%type,
1320: p_interface_line_attribute14 IN
1321: ra_customer_trx_lines.interface_line_attribute14%type,
1322: p_interface_line_attribute15 IN
1323: ra_customer_trx_lines.interface_line_attribute15%type)
1324: RETURN BOOLEAN IS
1325:

Line 1323: ra_customer_trx_lines.interface_line_attribute15%type)

1319: ra_customer_trx_lines.interface_line_attribute13%type,
1320: p_interface_line_attribute14 IN
1321: ra_customer_trx_lines.interface_line_attribute14%type,
1322: p_interface_line_attribute15 IN
1323: ra_customer_trx_lines.interface_line_attribute15%type)
1324: RETURN BOOLEAN IS
1325:
1326: l_dummy BINARY_INTEGER;
1327: