APPS.AR_INVOICE_TABLE_HANDLER dependencies on DBMS_SQL

Line 1067: lcursor := dbms_sql.open_cursor;

1063: /* JL_BR_SPED_PKG package is installed, so OK to call the package. */
1064:
1065: BEGIN
1066:
1067: lcursor := dbms_sql.open_cursor;
1068: sqlstmt :=
1069: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1070: END;';
1071:

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

1068: sqlstmt :=
1069: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1070: END;';
1071:
1072: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1073: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1074: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1075:
1076: IF PG_DEBUG in ('Y', 'C') THEN

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

1069: 'BEGIN :l_return_value_gdf := JL_BR_SPED_PKG.COPY_GDF_ATTRIBUTES_API(:p_customer_trx_id);
1070: END;';
1071:
1072: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1073: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1074: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1075:
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);

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

1070: END;';
1071:
1072: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
1073: dbms_sql.bind_variable(lcursor, ':p_customer_trx_id', ar_trx_header_rec.customer_trx_id);
1074: dbms_sql.bind_variable(lcursor, ':l_return_value_gdf', l_return_value_gdf);
1075:
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1078: END IF;

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

1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1078: END IF;
1079:
1080: lignore := dbms_sql.execute(lcursor);
1081: dbms_sql.close_cursor(lcursor);
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN

Line 1081: dbms_sql.close_cursor(lcursor);

1077: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
1078: END IF;
1079:
1080: lignore := dbms_sql.execute(lcursor);
1081: dbms_sql.close_cursor(lcursor);
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF PG_DEBUG in ('Y', 'C') THEN

Line 1090: IF dbms_sql.is_open(lcursor)

1086: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attr_for_api.');
1087: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
1088: END IF;
1089:
1090: IF dbms_sql.is_open(lcursor)
1091: THEN
1092: dbms_sql.close_cursor(lcursor);
1093: END IF;
1094: END;

Line 1092: dbms_sql.close_cursor(lcursor);

1088: END IF;
1089:
1090: IF dbms_sql.is_open(lcursor)
1091: THEN
1092: dbms_sql.close_cursor(lcursor);
1093: END IF;
1094: END;
1095: END IF;
1096: