APPS.AR_INVOICE_TABLE_HANDLER dependencies on DBMS_SQL

Line 1017: lcursor := dbms_sql.open_cursor;

1013: /* JL_BR_SPED_PKG package is installed, so OK to call the package. */
1014:
1015: BEGIN
1016:
1017: lcursor := dbms_sql.open_cursor;
1018: sqlstmt :=
1019: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1020: END;';
1021:

Line 1022: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);

1018: sqlstmt :=
1019: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1020: END;';
1021:
1022: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1023: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1024: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1025:
1026: IF PG_DEBUG in ('Y', 'C') THEN

Line 1023: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);

1019: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1020: END;';
1021:
1022: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1023: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1024: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1025:
1026: IF PG_DEBUG in ('Y', 'C') THEN
1027: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);

Line 1024: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);

1020: END;';
1021:
1022: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1023: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1024: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1025:
1026: IF PG_DEBUG in ('Y', 'C') THEN
1027: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1028: END IF;

Line 1030: lignore := dbms_sql.execute(lcursor);

1026: IF PG_DEBUG in ('Y', 'C') THEN
1027: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1028: END IF;
1029:
1030: lignore := dbms_sql.execute(lcursor);
1031: dbms_sql.close_cursor(lcursor);
1032:
1033: EXCEPTION
1034: WHEN OTHERS THEN

Line 1031: dbms_sql.close_cursor(lcursor);

1027: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1028: END IF;
1029:
1030: lignore := dbms_sql.execute(lcursor);
1031: dbms_sql.close_cursor(lcursor);
1032:
1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: IF PG_DEBUG in ('Y', 'C') THEN

Line 1040: IF dbms_sql.is_open(lcursor)

1036: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attr_for_api.');
1037: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
1038: END IF;
1039:
1040: IF dbms_sql.is_open(lcursor)
1041: THEN
1042: dbms_sql.close_cursor(lcursor);
1043: END IF;
1044: END;

Line 1042: dbms_sql.close_cursor(lcursor);

1038: END IF;
1039:
1040: IF dbms_sql.is_open(lcursor)
1041: THEN
1042: dbms_sql.close_cursor(lcursor);
1043: END IF;
1044: END;
1045: END IF;
1046: