[Home] [Help]
240: p_context_index,
241: l_where_clause);
242:
243:
244: IF (p_table_name = 'AR_TRX_LINES_GT')
245: THEN l_stmt := 'SELECT 0, 0 FROM '|| p_table_name;
246: ELSE l_stmt := 'SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID FROM '||
247: p_table_name;
248: END IF;
251: THEN
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 |
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
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'''; */
528: p_interface_line_attribute15
529: );
530:
531: /*-----------------------------------------------------+
532: | Bind variables into the AR_TRX_LINES_GT cursor |
533: +-----------------------------------------------------*/
534:
535: BEGIN
536: Bind_Variable(
555: END IF;
556:
557: p_ril_cursor := Get_Cursor(
558: p_context_index,
559: 'AR_TRX_LINES_GT'
560: );
561:
562: Bind_Variable(
563: p_ril_cursor,
752: THEN
753: ar_invoice_utils.debug('check_uniqueness()-');
754: END IF;
755: return(FALSE);
756: ELSIF ( l_rows > 1 and p_table_name = 'AR_TRX_LINES_GT' )
757: THEN
758: dbms_sql.column_value( p_cursor, 1, l_customer_trx_id);
759: dbms_sql.column_value( p_cursor, 2, l_customer_trx_line_id);
760: p_customer_trx_id := l_customer_trx_id;
760: p_customer_trx_id := l_customer_trx_id;
761: p_customer_trx_line_id := l_customer_trx_line_id;
762: IF pg_debug = 'Y'
763: THEN
764: ar_invoice_utils.debug('check_uniqueness for ar_trx_lines_gt()-');
765: END IF;
766: return(FALSE);
767: END IF;
768:
851: THEN
852:
853: l_ril_cursor := Get_Cursor(
854: l_context_index,
855: 'AR_TRX_LINES_GT' );
856:
857: WHEN OTHERS THEN RAISE;
858: END;
859:
892: return(FALSE);
893: END IF;
894:
895: /*----------------------------------------------------------------------+
896: | check for the uniqueness of the flex in AR_TRX_LINES_GT table |
897: +----------------------------------------------------------------------*/
898: IF (NOT check_uniqueness(
899: 'AR_TRX_LINES_GT',
900: l_ril_cursor,
895: /*----------------------------------------------------------------------+
896: | check for the uniqueness of the flex in AR_TRX_LINES_GT table |
897: +----------------------------------------------------------------------*/
898: IF (NOT check_uniqueness(
899: 'AR_TRX_LINES_GT',
900: l_ril_cursor,
901: l_dummy,
902: l_dummy
903: ) )
1248: trx_header_id,
1249: trx_line_id,
1250: customer_trx_line_id,
1251: customer_trx_id
1252: FROM ar_trx_lines_gt
1253: WHERE interface_line_attribute1 IS NOT NULL
1254: OR interface_line_attribute2 IS NOT NULL
1255: OR interface_line_attribute3 IS NOT NULL
1256: OR interface_line_attribute4 IS NOT NULL
1274: attribute13, attribute14, attribute15,
1275: attribute_category,
1276: trx_header_id,
1277: trx_line_id
1278: FROM ar_trx_lines_gt
1279: WHERE attribute1 IS NOT NULL
1280: OR attribute2 IS NOT NULL
1281: OR attribute3 IS NOT NULL
1282: OR attribute4 IS NOT NULL