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.AR_GDF_VALIDATION dependencies on DBMS_SQL

Line 96: lcursor := dbms_sql.open_cursor;

92: /* JG_ZZ_AUTO_INVOICE package is installed, so OK to call it */
93:
94: BEGIN
95:
96: lcursor := dbms_sql.open_cursor;
97: sqlstmt :=
98: 'BEGIN :return_value:=JG_ZZ_AUTO_INVOICE.validate_gdff(:request_id);
99: END;';
100:

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

97: sqlstmt :=
98: 'BEGIN :return_value:=JG_ZZ_AUTO_INVOICE.validate_gdff(:request_id);
99: END;';
100:
101: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
102: dbms_sql.bind_variable(lcursor, ':request_id', request_id);
103: dbms_sql.bind_variable(lcursor, ':return_value', return_value);
104:
105: IF PG_DEBUG in ('Y', 'C') THEN

Line 102: dbms_sql.bind_variable(lcursor, ':request_id', request_id);

98: 'BEGIN :return_value:=JG_ZZ_AUTO_INVOICE.validate_gdff(:request_id);
99: END;';
100:
101: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
102: dbms_sql.bind_variable(lcursor, ':request_id', request_id);
103: dbms_sql.bind_variable(lcursor, ':return_value', return_value);
104:
105: IF PG_DEBUG in ('Y', 'C') THEN
106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);

Line 103: dbms_sql.bind_variable(lcursor, ':return_value', return_value);

99: END;';
100:
101: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
102: dbms_sql.bind_variable(lcursor, ':request_id', request_id);
103: dbms_sql.bind_variable(lcursor, ':return_value', return_value);
104:
105: IF PG_DEBUG in ('Y', 'C') THEN
106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
107: END IF;

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

105: IF PG_DEBUG in ('Y', 'C') THEN
106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
107: END IF;
108:
109: lignore := dbms_sql.execute(lcursor);
110: dbms_sql.variable_value (lcursor, ':return_value', return_value);
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_standard.debug('is_gdf_valid: ' || 'Return value from JG_ZZ_AUTO_INVOICE.validate_gdff(): ' || return_value);
113: END IF;

Line 110: dbms_sql.variable_value (lcursor, ':return_value', return_value);

106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
107: END IF;
108:
109: lignore := dbms_sql.execute(lcursor);
110: dbms_sql.variable_value (lcursor, ':return_value', return_value);
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_standard.debug('is_gdf_valid: ' || 'Return value from JG_ZZ_AUTO_INVOICE.validate_gdff(): ' || return_value);
113: END IF;
114: dbms_sql.close_cursor(lcursor);

Line 114: dbms_sql.close_cursor(lcursor);

110: dbms_sql.variable_value (lcursor, ':return_value', return_value);
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_standard.debug('is_gdf_valid: ' || 'Return value from JG_ZZ_AUTO_INVOICE.validate_gdff(): ' || return_value);
113: END IF;
114: dbms_sql.close_cursor(lcursor);
115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: IF PG_DEBUG in ('Y', 'C') THEN

Line 123: IF dbms_sql.is_open(lcursor)

119: arp_standard.debug('is_gdf_valid: ' || cr|| 'Exception calling JG_ZZ_AUTO_INVOICE.validate_gdff()');
120: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
121: END IF;
122:
123: IF dbms_sql.is_open(lcursor)
124: THEN
125: dbms_sql.close_cursor(lcursor);
126: END IF;
127:

Line 125: dbms_sql.close_cursor(lcursor);

121: END IF;
122:
123: IF dbms_sql.is_open(lcursor)
124: THEN
125: dbms_sql.close_cursor(lcursor);
126: END IF;
127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 389: lcursor := dbms_sql.open_cursor;

385: /* JG_GLOBE_FLEX_VAL package is installed, so OK to call it */
386:
387: BEGIN
388:
389: lcursor := dbms_sql.open_cursor;
390: sqlstmt :=
391: 'BEGIN JG_GLOBE_FLEX_VAL.ar_cust_interface('|| request_id || ','
392: || org_id || ','
393: || sob || ','

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

397: || program_id || ','
398: || prog_appl_id || ','
399: || last_update_login || '); END;';
400:
401: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_standard.debug('is_gdf_taxid_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
405: END IF;

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

403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_standard.debug('is_gdf_taxid_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
405: END IF;
406:
407: lignore := dbms_sql.execute(lcursor);
408:
409: dbms_sql.close_cursor(lcursor);
410:
411: EXCEPTION

Line 409: dbms_sql.close_cursor(lcursor);

405: END IF;
406:
407: lignore := dbms_sql.execute(lcursor);
408:
409: dbms_sql.close_cursor(lcursor);
410:
411: EXCEPTION
412: when OTHERS then
413: IF PG_DEBUG in ('Y', 'C') THEN

Line 418: IF dbms_sql.is_open(lcursor)

414: arp_standard.debug('is_gdf_taxid_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
415: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
416: END IF;
417:
418: IF dbms_sql.is_open(lcursor)
419: THEN
420: dbms_sql.close_cursor(lcursor);
421: END IF;
422: IF PG_DEBUG in ('Y', 'C') THEN

Line 420: dbms_sql.close_cursor(lcursor);

416: END IF;
417:
418: IF dbms_sql.is_open(lcursor)
419: THEN
420: dbms_sql.close_cursor(lcursor);
421: END IF;
422: IF PG_DEBUG in ('Y', 'C') THEN
423: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
424: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 549: lcursor := dbms_sql.open_cursor;

545: /* JG_GLOBE_FLEX_VAL package is installed, so OK to call it */
546:
547: BEGIN
548:
549: lcursor := dbms_sql.open_cursor;
550:
551: if org_id is null then
552:
553: if(int_table_name='CUSTOMER') then

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

610: ||'''PROFILE'''||'); END;';
611:
612: end if;
613: end if;
614: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
615:
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_standard.debug('is_cust_imp_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
618: END IF;

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

616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_standard.debug('is_cust_imp_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
618: END IF;
619:
620: lignore := dbms_sql.execute(lcursor);
621:
622: dbms_sql.close_cursor(lcursor);
623:
624: EXCEPTION

Line 622: dbms_sql.close_cursor(lcursor);

618: END IF;
619:
620: lignore := dbms_sql.execute(lcursor);
621:
622: dbms_sql.close_cursor(lcursor);
623:
624: EXCEPTION
625: when OTHERS then
626: IF PG_DEBUG in ('Y', 'C') THEN

Line 631: IF dbms_sql.is_open(lcursor)

627: arp_standard.debug('is_cust_imp_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
628: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
629: END IF;
630:
631: IF dbms_sql.is_open(lcursor)
632: THEN
633: dbms_sql.close_cursor(lcursor);
634: END IF;
635: IF PG_DEBUG in ('Y', 'C') THEN

Line 633: dbms_sql.close_cursor(lcursor);

629: END IF;
630:
631: IF dbms_sql.is_open(lcursor)
632: THEN
633: dbms_sql.close_cursor(lcursor);
634: END IF;
635: IF PG_DEBUG in ('Y', 'C') THEN
636: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
637: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 733: lcursor := dbms_sql.open_cursor;

729: /* JL_BR_SPED_PKG package is installed, so OK to call the package. */
730:
731: BEGIN
732:
733: lcursor := dbms_sql.open_cursor;
734: sqlstmt :=
735: 'BEGIN :l_return_value := JL_BR_SPED_PKG.copy_gdf_attributes(:p_request_id, :p_called_from);
736: END;';
737:

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

734: sqlstmt :=
735: 'BEGIN :l_return_value := JL_BR_SPED_PKG.copy_gdf_attributes(:p_request_id, :p_called_from);
736: END;';
737:
738: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
739: dbms_sql.bind_variable(lcursor, ':p_request_id', p_request_id);
740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);
741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);
742:

Line 739: dbms_sql.bind_variable(lcursor, ':p_request_id', p_request_id);

735: 'BEGIN :l_return_value := JL_BR_SPED_PKG.copy_gdf_attributes(:p_request_id, :p_called_from);
736: END;';
737:
738: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
739: dbms_sql.bind_variable(lcursor, ':p_request_id', p_request_id);
740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);
741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);
742:
743: IF PG_DEBUG in ('Y', 'C') THEN

Line 740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);

736: END;';
737:
738: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
739: dbms_sql.bind_variable(lcursor, ':p_request_id', p_request_id);
740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);
741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);
742:
743: IF PG_DEBUG in ('Y', 'C') THEN
744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);

Line 741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);

737:
738: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
739: dbms_sql.bind_variable(lcursor, ':p_request_id', p_request_id);
740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);
741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);
742:
743: IF PG_DEBUG in ('Y', 'C') THEN
744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
745: END IF;

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

743: IF PG_DEBUG in ('Y', 'C') THEN
744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
745: END IF;
746:
747: lignore := dbms_sql.execute(lcursor);
748: dbms_sql.close_cursor(lcursor);
749:
750: EXCEPTION
751: WHEN OTHERS THEN

Line 748: dbms_sql.close_cursor(lcursor);

744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
745: END IF;
746:
747: lignore := dbms_sql.execute(lcursor);
748: dbms_sql.close_cursor(lcursor);
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: IF PG_DEBUG in ('Y', 'C') THEN

Line 758: IF dbms_sql.is_open(lcursor)

754: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
755: l_error := SQLERRM;
756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
757: END IF;
758: IF dbms_sql.is_open(lcursor)
759: THEN
760: dbms_sql.close_cursor(lcursor);
761: END IF;
762: END;

Line 760: dbms_sql.close_cursor(lcursor);

756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
757: END IF;
758: IF dbms_sql.is_open(lcursor)
759: THEN
760: dbms_sql.close_cursor(lcursor);
761: END IF;
762: END;
763:
764: END IF ;