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.OKC_TERMS_MIGRATE_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,

490:
491: l_doc_intent VARCHAR2(1);
492:
493: TYPE l_tmpl_type IS RECORD (
494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,

Line 495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,

491: l_doc_intent VARCHAR2(1);
492:
493: TYPE l_tmpl_type IS RECORD (
494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,

Line 496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,

492:
493: TYPE l_tmpl_type IS RECORD (
494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,

Line 497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,

493: TYPE l_tmpl_type IS RECORD (
494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);

Line 498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,

494: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
502:

Line 499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,

495: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
502:
503: l_tmpl_type_rec l_tmpl_type;

Line 500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,

496: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
502:
503: l_tmpl_type_rec l_tmpl_type;
504:

Line 501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);

497: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
498: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
499: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
500: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
501: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
502:
503: l_tmpl_type_rec l_tmpl_type;
504:
505:

Line 516: OKC_TERMS_TEMPLATES_ALL TMP

512: intent,
513: org_id,
514: tmpl_numbering_scheme
515: FROM
516: OKC_TERMS_TEMPLATES_ALL TMP
517: WHERE
518: TMP.template_id = p_contract_tmpl_id;
519:
520: CURSOR l_tmpl_name_validate_csr(l_org_id IN NUMBER) IS

Line 530: OKC_TERMS_TEMPLATES_ALL TMP

526: intent,
527: org_id,
528: tmpl_numbering_scheme
529: FROM
530: OKC_TERMS_TEMPLATES_ALL TMP
531: WHERE TMP.template_name = p_contract_tmpl_name
532: AND TMP.org_id = l_org_id;
533:
534:

Line 3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,

3144: l_document_type VARCHAR2(240);
3145: l_document_id NUMBER;
3146:
3147: TYPE l_tmpl_type IS RECORD (
3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,

Line 3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,

3145: l_document_id NUMBER;
3146:
3147: TYPE l_tmpl_type IS RECORD (
3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,

Line 3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,

3146:
3147: TYPE l_tmpl_type IS RECORD (
3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,

Line 3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,

3147: TYPE l_tmpl_type IS RECORD (
3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);

Line 3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,

3148: template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
3156:

Line 3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,

3149: template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
3156:
3157: l_tmpl_type_rec l_tmpl_type;

Line 3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,

3150: status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
3156:
3157: l_tmpl_type_rec l_tmpl_type;
3158:

Line 3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);

3151: start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
3152: end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
3153: intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
3154: org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE,
3155: tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE);
3156:
3157: l_tmpl_type_rec l_tmpl_type;
3158:
3159: CURSOR l_tmpl_id_validate_csr IS

Line 3169: OKC_TERMS_TEMPLATES_ALL TMP

3165: intent,
3166: org_id,
3167: tmpl_numbering_scheme
3168: FROM
3169: OKC_TERMS_TEMPLATES_ALL TMP
3170: WHERE
3171: TMP.template_id = p_contract_tmpl_id;
3172:
3173: CURSOR l_tmpl_name_validate_csr(l_org_id IN NUMBER) IS

Line 3183: OKC_TERMS_TEMPLATES_ALL TMP

3179: intent,
3180: org_id,
3181: tmpl_numbering_scheme
3182: FROM
3183: OKC_TERMS_TEMPLATES_ALL TMP
3184: WHERE TMP.template_name = p_contract_tmpl_name
3185: AND TMP.org_id = l_org_id;
3186:
3187: CURSOR l_tmpl_doc_exist_csr IS