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

Line 372: v_dbms := DBMS_SQL.OPEN_CURSOR;

368: p_stored_ind := 'N';
369: RETURN TRUE;
370: END IF;
371: -- Open a cursor for dynamic SQL
372: v_dbms := DBMS_SQL.OPEN_CURSOR;
373: -- Put the block of code from the IGS_CO_S_LTR_PARAM table
374: -- into the dynmaic SQL cursor
375: DBMS_SQL.PARSE(
376: v_dbms,

Line 375: DBMS_SQL.PARSE(

371: -- Open a cursor for dynamic SQL
372: v_dbms := DBMS_SQL.OPEN_CURSOR;
373: -- Put the block of code from the IGS_CO_S_LTR_PARAM table
374: -- into the dynmaic SQL cursor
375: DBMS_SQL.PARSE(
376: v_dbms,
377: v_code_block,
378: DBMS_SQL.NATIVE);
379: -- Set up all the bind variables that could be passed into the

Line 378: DBMS_SQL.NATIVE);

374: -- into the dynmaic SQL cursor
375: DBMS_SQL.PARSE(
376: v_dbms,
377: v_code_block,
378: DBMS_SQL.NATIVE);
379: -- Set up all the bind variables that could be passed into the
380: -- dynamic SQL
381: FOR v_slpta_in_rec IN c_slpta_in (
382: v_slpt_s_letter_parameter_type) LOOP

Line 384: DBMS_SQL.BIND_VARIABLE(

380: -- dynamic SQL
381: FOR v_slpta_in_rec IN c_slpta_in (
382: v_slpt_s_letter_parameter_type) LOOP
383: IF v_slpta_in_rec.bind_variable = cst_rec_num THEN
384: DBMS_SQL.BIND_VARIABLE(
385: v_dbms,
386: 'p_record_number',
387: p_record_number);
388: ELSIF v_slpta_in_rec.bind_variable = cst_let_context_param THEN

Line 389: DBMS_SQL.BIND_VARIABLE(

385: v_dbms,
386: 'p_record_number',
387: p_record_number);
388: ELSIF v_slpta_in_rec.bind_variable = cst_let_context_param THEN
389: DBMS_SQL.BIND_VARIABLE(
390: v_dbms,
391: 'p_letter_context_parameter',
392: p_letter_context_parameter);
393: ELSIF v_slpta_in_rec.bind_variable = cst_person_id THEN

Line 394: DBMS_SQL.BIND_VARIABLE(

390: v_dbms,
391: 'p_letter_context_parameter',
392: p_letter_context_parameter);
393: ELSIF v_slpta_in_rec.bind_variable = cst_person_id THEN
394: DBMS_SQL.BIND_VARIABLE(
395: v_dbms,
396: 'p_person_id',
397: p_person_id);
398: ELSIF v_slpta_in_rec.bind_variable = cst_cor_type THEN

Line 399: DBMS_SQL.BIND_VARIABLE(

395: v_dbms,
396: 'p_person_id',
397: p_person_id);
398: ELSIF v_slpta_in_rec.bind_variable = cst_cor_type THEN
399: DBMS_SQL.BIND_VARIABLE(
400: v_dbms,
401: 'p_correspondence_type',
402: p_correspondence_type);
403: ELSIF v_slpta_in_rec.bind_variable = cst_let_ref_num THEN

Line 404: DBMS_SQL.BIND_VARIABLE(

400: v_dbms,
401: 'p_correspondence_type',
402: p_correspondence_type);
403: ELSIF v_slpta_in_rec.bind_variable = cst_let_ref_num THEN
404: DBMS_SQL.BIND_VARIABLE(
405: v_dbms,
406: 'p_letter_reference_number',
407: p_letter_reference_number);
408: ELSIF v_slpta_in_rec.bind_variable = cst_s_let_param_type then

Line 409: DBMS_SQL.BIND_VARIABLE(

405: v_dbms,
406: 'p_letter_reference_number',
407: p_letter_reference_number);
408: ELSIF v_slpta_in_rec.bind_variable = cst_s_let_param_type then
409: DBMS_SQL.BIND_VARIABLE(
410: v_dbms,
411: 'v_s_letter_parameter_type',
412: v_lpt_s_letter_parameter_type);
413: END IF;

Line 419: DBMS_SQL.BIND_VARIABLE(

415: -- set up all the bind variables that may be passed out NOCOPY of the dynamic SQL
416: FOR v_slpta_out_rec IN c_slpta_out (
417: v_slpt_s_letter_parameter_type) LOOP
418: IF v_slpta_out_rec.bind_variable = cst_v_value THEN
419: DBMS_SQL.BIND_VARIABLE(
420: v_dbms,
421: 'v_value',
422: NULL,
423: 2000);

Line 425: DBMS_SQL.BIND_VARIABLE(

421: 'v_value',
422: NULL,
423: 2000);
424: ELSIF v_slpta_out_rec.bind_variable = cst_v_extra_context THEN
425: DBMS_SQL.BIND_VARIABLE(
426: v_dbms,
427: 'v_extra_context',
428: NULL,
429: 2000);

Line 433: v_dbms_return := DBMS_SQL.EXECUTE(v_dbms);

429: 2000);
430: END IF;
431: END LOOP;
432: -- execute the dynmaic SQL block of code.
433: v_dbms_return := DBMS_SQL.EXECUTE(v_dbms);
434: -- Copy values of bind variables to program variables.
435: FOR v_slpta_out_rec IN c_slpta_out (
436: v_slpt_s_letter_parameter_type) LOOP
437: IF v_slpta_out_rec.bind_variable = cst_v_value THEN

Line 438: DBMS_SQL.VARIABLE_VALUE(

434: -- Copy values of bind variables to program variables.
435: FOR v_slpta_out_rec IN c_slpta_out (
436: v_slpt_s_letter_parameter_type) LOOP
437: IF v_slpta_out_rec.bind_variable = cst_v_value THEN
438: DBMS_SQL.VARIABLE_VALUE(
439: v_dbms,
440: 'v_value',
441: v_value);
442: ELSIF v_slpta_out_rec.bind_variable = cst_v_extra_context THEN

Line 443: DBMS_SQL.VARIABLE_VALUE(

439: v_dbms,
440: 'v_value',
441: v_value);
442: ELSIF v_slpta_out_rec.bind_variable = cst_v_extra_context THEN
443: DBMS_SQL.VARIABLE_VALUE(
444: v_dbms,
445: 'v_extra_context',
446: p_extra_context);
447: END IF;

Line 450: DBMS_SQL.CLOSE_CURSOR(v_dbms);

446: p_extra_context);
447: END IF;
448: END LOOP;
449: -- Close the dynamic SQL cursor
450: DBMS_SQL.CLOSE_CURSOR(v_dbms);
451: END IF; -- v_letter_text IS NULL
452: -- After all the tests are done check if v_value is NULL
453: IF(v_value IS NOT NULL) THEN
454: p_stored_ind := 'Y';

Line 517: IF DBMS_SQL.IS_OPEN(v_dbms) THEN

513: END IF;
514: RETURN TRUE;
515: EXCEPTION
516: WHEN OTHERS THEN
517: IF DBMS_SQL.IS_OPEN(v_dbms) THEN
518: DBMS_SQL.CLOSE_CURSOR(v_dbms);
519: END IF;
520: IF c_get_nxt_seq%ISOPEN THEN
521: CLOSE c_get_nxt_seq;

Line 518: DBMS_SQL.CLOSE_CURSOR(v_dbms);

514: RETURN TRUE;
515: EXCEPTION
516: WHEN OTHERS THEN
517: IF DBMS_SQL.IS_OPEN(v_dbms) THEN
518: DBMS_SQL.CLOSE_CURSOR(v_dbms);
519: END IF;
520: IF c_get_nxt_seq%ISOPEN THEN
521: CLOSE c_get_nxt_seq;
522: END IF;