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.

[Home] [Help]

APPS.IGS_AD_GEN_016 dependencies on IGS_AD_CODE_CLASSES

Line 451: ln_code_id igs_ad_code_classes.code_id%TYPE;

447: FUNCTION get_codeclass (p_class IN VARCHAR2,
448: p_code_id IN NUMBER)
449: RETURN VARCHAR2 -- Returns TRUE/FALSE
450: IS
451: ln_code_id igs_ad_code_classes.code_id%TYPE;
452: lv_name igs_ad_code_classes.name%TYPE;
453: lv_system_status igs_ad_code_classes.system_status%TYPE;
454: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
455: BEGIN

Line 452: lv_name igs_ad_code_classes.name%TYPE;

448: p_code_id IN NUMBER)
449: RETURN VARCHAR2 -- Returns TRUE/FALSE
450: IS
451: ln_code_id igs_ad_code_classes.code_id%TYPE;
452: lv_name igs_ad_code_classes.name%TYPE;
453: lv_system_status igs_ad_code_classes.system_status%TYPE;
454: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
455: BEGIN
456: ln_code_id := p_code_id;

Line 453: lv_system_status igs_ad_code_classes.system_status%TYPE;

449: RETURN VARCHAR2 -- Returns TRUE/FALSE
450: IS
451: ln_code_id igs_ad_code_classes.code_id%TYPE;
452: lv_name igs_ad_code_classes.name%TYPE;
453: lv_system_status igs_ad_code_classes.system_status%TYPE;
454: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
455: BEGIN
456: ln_code_id := p_code_id;
457: lv_closed_ind := 'N';

Line 454: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;

450: IS
451: ln_code_id igs_ad_code_classes.code_id%TYPE;
452: lv_name igs_ad_code_classes.name%TYPE;
453: lv_system_status igs_ad_code_classes.system_status%TYPE;
454: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
455: BEGIN
456: ln_code_id := p_code_id;
457: lv_closed_ind := 'N';
458: RETURN (get_codeclass (p_class => p_class,

Line 469: ln_code_id igs_ad_code_classes.code_id%TYPE;

465: FUNCTION get_codeclass (p_class IN VARCHAR2,
466: p_name IN VARCHAR2)
467: RETURN VARCHAR2 -- Returns TRUE/FALSE
468: IS
469: ln_code_id igs_ad_code_classes.code_id%TYPE;
470: lv_name igs_ad_code_classes.name%TYPE;
471: lv_system_status igs_ad_code_classes.system_status%TYPE;
472: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
473: BEGIN

Line 470: lv_name igs_ad_code_classes.name%TYPE;

466: p_name IN VARCHAR2)
467: RETURN VARCHAR2 -- Returns TRUE/FALSE
468: IS
469: ln_code_id igs_ad_code_classes.code_id%TYPE;
470: lv_name igs_ad_code_classes.name%TYPE;
471: lv_system_status igs_ad_code_classes.system_status%TYPE;
472: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
473: BEGIN
474: lv_name := p_name;

Line 471: lv_system_status igs_ad_code_classes.system_status%TYPE;

467: RETURN VARCHAR2 -- Returns TRUE/FALSE
468: IS
469: ln_code_id igs_ad_code_classes.code_id%TYPE;
470: lv_name igs_ad_code_classes.name%TYPE;
471: lv_system_status igs_ad_code_classes.system_status%TYPE;
472: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
473: BEGIN
474: lv_name := p_name;
475: lv_closed_ind := 'N';

Line 472: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;

468: IS
469: ln_code_id igs_ad_code_classes.code_id%TYPE;
470: lv_name igs_ad_code_classes.name%TYPE;
471: lv_system_status igs_ad_code_classes.system_status%TYPE;
472: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
473: BEGIN
474: lv_name := p_name;
475: lv_closed_ind := 'N';
476: RETURN (get_codeclass (p_class => p_class,

Line 488: lv_system_status igs_ad_code_classes.system_status%TYPE;

484: p_code_id IN OUT NOCOPY NUMBER,
485: p_name IN OUT NOCOPY VARCHAR2)
486: RETURN VARCHAR2 -- Returns TRUE/FALSE
487: IS
488: lv_system_status igs_ad_code_classes.system_status%TYPE;
489: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
490: BEGIN
491: lv_closed_ind := 'N';
492: RETURN (get_codeclass (p_class => p_class,

Line 489: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;

485: p_name IN OUT NOCOPY VARCHAR2)
486: RETURN VARCHAR2 -- Returns TRUE/FALSE
487: IS
488: lv_system_status igs_ad_code_classes.system_status%TYPE;
489: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
490: BEGIN
491: lv_closed_ind := 'N';
492: RETURN (get_codeclass (p_class => p_class,
493: p_code_id => p_code_id,

Line 506: ln_code_id igs_ad_code_classes.code_id%TYPE;

502: p_system_status IN VARCHAR2)
503: RETURN VARCHAR2 -- Returns TRUE/FALSE
504: IS
505: lv_ret_success VARCHAR2(5);
506: ln_code_id igs_ad_code_classes.code_id%TYPE;
507: lv_name igs_ad_code_classes.name%TYPE;
508: lv_system_status igs_ad_code_classes.system_status%TYPE;
509: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
510: ln_hash_dflt_cc_id_hashidx_idx NUMBER;

Line 507: lv_name igs_ad_code_classes.name%TYPE;

503: RETURN VARCHAR2 -- Returns TRUE/FALSE
504: IS
505: lv_ret_success VARCHAR2(5);
506: ln_code_id igs_ad_code_classes.code_id%TYPE;
507: lv_name igs_ad_code_classes.name%TYPE;
508: lv_system_status igs_ad_code_classes.system_status%TYPE;
509: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
510: ln_hash_dflt_cc_id_hashidx_idx NUMBER;
511: ln_hash_ccode_idx NUMBER;

Line 508: lv_system_status igs_ad_code_classes.system_status%TYPE;

504: IS
505: lv_ret_success VARCHAR2(5);
506: ln_code_id igs_ad_code_classes.code_id%TYPE;
507: lv_name igs_ad_code_classes.name%TYPE;
508: lv_system_status igs_ad_code_classes.system_status%TYPE;
509: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
510: ln_hash_dflt_cc_id_hashidx_idx NUMBER;
511: ln_hash_ccode_idx NUMBER;
512: BEGIN

Line 509: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;

505: lv_ret_success VARCHAR2(5);
506: ln_code_id igs_ad_code_classes.code_id%TYPE;
507: lv_name igs_ad_code_classes.name%TYPE;
508: lv_system_status igs_ad_code_classes.system_status%TYPE;
509: lv_closed_ind igs_ad_code_classes.closed_ind%TYPE;
510: ln_hash_dflt_cc_id_hashidx_idx NUMBER;
511: ln_hash_ccode_idx NUMBER;
512: BEGIN
513: -- If parameters are not valid return

Line 562: FROM igs_ad_code_classes

558:
559: CURSOR c_ccode (lv_class VARCHAR2)
560: IS
561: SELECT code_id, name, system_status, closed_ind, system_default
562: FROM igs_ad_code_classes
563: WHERE class = lv_class
564: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
565:
566: lr_fetched_ccode c_ccode%ROWTYPE;