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_NUMBER_SCHEME_GRP dependencies on OKC_NUMBER_SCHEME_DTLS

Line 73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

69: l_lvl4_concat_yn VARCHAR2(1) := NULL;
70: l_lvl5_concat_yn VARCHAR2(1) := NULL;
71:
72: --Bug 3663038 Used %type in declaration
73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

Line 74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

70: l_lvl5_concat_yn VARCHAR2(1) := NULL;
71:
72: --Bug 3663038 Used %type in declaration
73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
78:

Line 75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

71:
72: --Bug 3663038 Used %type in declaration
73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
78:
79: l_no_of_levels NUMBER := 0;

Line 76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

72: --Bug 3663038 Used %type in declaration
73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
78:
79: l_no_of_levels NUMBER := 0;
80:

Line 77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;

73: l_lvl1_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
74: l_lvl2_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
75: l_lvl3_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
76: l_lvl4_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
77: l_lvl5_end_char OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE := NULL;
78:
79: l_no_of_levels NUMBER := 0;
80:
81: l_number_article_yn VARCHAR2(1) :='Y';

Line 570: FROM OKC_NUMBER_SCHEME_DTLS

566: decode(Num_Sequence_code, G_NUMBER_SEQUENCE,'2',G_LOWERCASE_ENG_ALPHABETS,'b',G_UPPERCASE_ENG_ALPHABETS,'B',G_LOWERCASE_ROMAN_NUMBER,'ii',G_UPPERCASE_ROMAN_NUMBER,'II')label2,
567: concatenation_yn,
568: sequence_level,
569: End_character
570: FROM OKC_NUMBER_SCHEME_DTLS
571: WHERE Num_scheme_Id = p_num_scheme_id
572: order by Sequence_Level;
573:
574: l_out Varchar2(2000) :=NULL;

Line 738: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS

734: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B
735: where num_scheme_id=p_num_scheme_id;
736:
737: cursor l_get_num_scheme_dtl IS
738: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS
739: where num_scheme_id=p_num_scheme_id;
740:
741: cursor l_get_usage_rec IS
742: SELECT template_id,object_version_number from OKC_template_usages

Line 760: FROM OKC_NUMBER_SCHEME_DTLS

756: i NUMBER;
757:
758: CURSOR l_get_dtl_count IS
759: SELECT COUNT(*)
760: FROM OKC_NUMBER_SCHEME_DTLS
761: WHERE num_scheme_id=p_num_scheme_id;
762:
763: l_dtl_count NUMBER;
764:

Line 1541: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS

1537: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B
1538: where num_scheme_id=p_num_scheme_id;
1539:
1540: cursor l_get_num_scheme_dtl IS
1541: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS
1542: where num_scheme_id=p_num_scheme_id;
1543:
1544:
1545:

Line 1560: FROM OKC_NUMBER_SCHEME_DTLS

1556: i NUMBER;
1557:
1558: CURSOR l_get_dtl_count IS
1559: SELECT COUNT(*)
1560: FROM OKC_NUMBER_SCHEME_DTLS
1561: WHERE num_scheme_id=p_num_scheme_id;
1562:
1563: l_dtl_count NUMBER;
1564: