APPS.ARP_TRANS_FLEX dependencies on RA_INTERFACE_LINES

Line 12: ra_interface_lines.interface_line_attribute1%type

8:
9: TYPE flex_num_type IS TABLE OF number INDEX by binary_integer;
10:
11: TYPE seg_value_type IS TABLE OF
12: ra_interface_lines.interface_line_attribute1%type
13: INDEX by binary_integer;
14:
15: TYPE cursor_tbl_type IS
16: TABLE OF BINARY_INTEGER

Line 29: pg_ril_cursors cursor_tbl_type; -- cursors for ra_interface_lines

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
33: -- segment in pg_active_segs

Line 544: IF (p_table_name = 'RA_INTERFACE_LINES')

540: p_context_index,
541: l_where_clause);
542:
543:
544: IF (p_table_name = 'RA_INTERFACE_LINES')
545: THEN l_stmt := 'SELECT 0, 0 FROM '|| p_table_name;
546: ELSE l_stmt := 'SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID FROM '||
547: p_table_name;
548: END IF;

Line 555: | For RA_INTERFACE_LINES, the context is always filled in even |

551: THEN
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 |

Line 563: IF (p_table_name = 'RA_INTERFACE_LINES')

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')
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''';

Line 893: | Bind variables into the ra_interface_lines cursor |

889: p_interface_line_attribute15
890: );
891:
892: /*-----------------------------------------------------+
893: | Bind variables into the ra_interface_lines cursor |
894: +-----------------------------------------------------*/
895:
896: BEGIN
897: Bind_Variable(

Line 917: 'RA_INTERFACE_LINES'

913: arp_util.debug('Handling INVALID_CURSOR exception by reparsing');
914:
915: p_ril_cursor := Get_Cursor(
916: p_context_index,
917: 'RA_INTERFACE_LINES'
918: );
919:
920: Bind_Variable(
921: p_ril_cursor,

Line 1195: 'RA_INTERFACE_LINES' );

1191: EXCEPTION
1192: WHEN NO_DATA_FOUND
1193: THEN l_ril_cursor := Get_Cursor(
1194: l_context_index,
1195: 'RA_INTERFACE_LINES' );
1196:
1197: WHEN OTHERS THEN RAISE;
1198: END;
1199:

Line 1236: | check for the uniqueness of the flex in RA_INTERFACE_LINES table |

1232: return(FALSE);
1233: END IF;
1234:
1235: /*----------------------------------------------------------------------+
1236: | check for the uniqueness of the flex in RA_INTERFACE_LINES table |
1237: +----------------------------------------------------------------------*/
1238: IF (NOT check_uniqueness(
1239: l_ril_cursor,
1240: l_dummy,

Line 1361: setup_descr_flex(222, 'RA_INTERFACE_LINES');

1357: /*-----------------------------------------------------------------------+
1358: | initialization section. Initialize the package PL/SQL variables with |
1359: | the transaction flex information |
1360: +-----------------------------------------------------------------------*/
1361: setup_descr_flex(222, 'RA_INTERFACE_LINES');
1362:
1363: END;