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.JTF_TERR_DEFINITION_PARAM_PVT dependencies on HTP

Line 26: htp.htmlopen;

22: --
23: -----------------------------------------------------------------------------------------------
24: begin
25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 27: htp.headOpen;

23: -----------------------------------------------------------------------------------------------
24: begin
25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');

Line 28: htp.title('Territory Defintion Report');

24: begin
25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );

Line 29: htp.headClose;

25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));

Line 30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');

Line 31: htp.tableOpen('border="0" ');

27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

Line 32: htp.tableRowOpen( calign => 'TOP' );

28: htp.title('Territory Defintion Report');
29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;

Line 33: --htp.tableData( htf.img(curl=>'terman32.gif'));

29: htp.headClose;
30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;

Line 34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');

30: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

Line 35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

31: htp.tableOpen('border="0" ');
32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );

Line 36: htp.tableRowClose;

32: htp.tableRowOpen( calign => 'TOP' );
33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 37: htp.tableClose;

33: --htp.tableData( htf.img(curl=>'terman32.gif'));
34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

Line 38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

34: htp.tableData( '' || 'Territory Definition Report', cnowrap => 'TRUE');
35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

Line 39: htp.tableRowOpen( cvalign => 'top' );

35: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');

Line 40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

36: htp.tableRowClose;
37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;

Line 41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

37: htp.tableClose;
38: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;

Line 43: htp.tableData( ' ', ccolspan => '6');

39: htp.tableRowOpen( cvalign => 'top' );
40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;

Line 44: htp.Br;

40: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;

Line 45: htp.tableRowClose;

41: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;

Line 46: htp.tableClose;

42: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: end;

Line 47: htp.bodyClose;

43: htp.tableData( ' ', ccolspan => '6');
44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: end;
51: -----------------------------------------------------------------------------------------------

Line 48: htp.headClose;

44: htp.Br;
45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: end;
51: -----------------------------------------------------------------------------------------------
52: procedure terr_definition_paramform is

Line 49: htp.htmlClose;

45: htp.tableRowClose;
46: htp.tableClose;
47: htp.bodyClose;
48: htp.headClose;
49: htp.htmlClose;
50: end;
51: -----------------------------------------------------------------------------------------------
52: procedure terr_definition_paramform is
53:

Line 91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');

87: header;
88:
89: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
90: -------------------- Returns login user Id--------------------------
91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');
92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;

Line 92: htp.htmlopen;

88:
89: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
90: -------------------- Returns login user Id--------------------------
91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');
92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 93: htp.headOpen;

89: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
90: -------------------- Returns login user Id--------------------------
91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');
92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;

Line 94: htp.title('Territory Definition Report');

90: -------------------- Returns login user Id--------------------------
91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');
92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );

Line 95: htp.headClose;

91: htp.FormOpen(owa_util.Get_Owa_Service_Path||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cattributes => ' NAME="param"');
92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');

Line 96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

92: htp.htmlopen;
93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 97: htp.tableopen;

93: htp.headOpen;
94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');

Line 98: htp.tableRowOpen( cvalign => 'top' );

94: htp.title('Territory Definition Report');
95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;

Line 99: htp.tableData( ' ', cattributes => ' height=9');

95: htp.headClose;
96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;

Line 100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

96: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');

Line 101: htp.tableData( ' ');

97: htp.tableopen;
98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */

Line 102: htp.tableRowClose;

98: htp.tableRowOpen( cvalign => 'top' );
99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */
106: htp.tableRowOpen();

Line 103: htp.tableClose;

99: htp.tableData( ' ', cattributes => ' height=9');
100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */
106: htp.tableRowOpen();
107: htp.p('Select Output Format');

Line 104: htp.tableOpen(cattributes=>'width="600" ');

100: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
101: htp.tableData( ' ');
102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */
106: htp.tableRowOpen();
107: htp.p('Select Output Format');
108: htp.p('');

Line 106: htp.tableRowOpen();

102: htp.tableRowClose;
103: htp.tableClose;
104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */
106: htp.tableRowOpen();
107: htp.p('Select Output Format');
108: htp.p('');
109: htp.p('');
110: htp.FormSelectOption('Excel');
111: htp.FormSelectOption('HTML', cselected => 'TRUE');

Line 108: htp.p('');

104: htp.tableOpen(cattributes=>'width="600" ');
105: /* Output format control */
106: htp.tableRowOpen();
107: htp.p('Select Output Format');
108: htp.p('');
109: htp.p('');

105: /* Output format control */
106: htp.tableRowOpen();
107: htp.p('Select Output Format');
108: htp.p('');
109: htp.p('');
110: htp.FormSelectOption('Excel');
111: htp.FormSelectOption('HTML', cselected => 'TRUE');
112: htp.FormSelectClose;
113: htp.tableRowClose;
114: /* Sales Rep Search Restriction */

Line 111: htp.FormSelectOption('HTML', cselected => 'TRUE');

107: htp.p('Select Output Format');
108: htp.p('');
109: htp.p('');
110: htp.FormSelectOption('Excel');
111: htp.FormSelectOption('HTML', cselected => 'TRUE');
112: htp.FormSelectClose;
113: htp.tableRowClose;
114: /* Sales Rep Search Restriction */
115: htp.tableRowOpen();
116: htp.p('Sales Rep');

Line 113: htp.tableRowClose;

109: htp.p('');
119: FOR rec_salesrep IN cur_salesrep LOOP

Line 116: htp.p('Sales Rep');

112: htp.FormSelectClose;
113: htp.tableRowClose;
114: /* Sales Rep Search Restriction */
115: htp.tableRowOpen();
116: htp.p('Sales Rep');
117: htp.p('');
118: htp.p ('');
119: FOR rec_salesrep IN cur_salesrep LOOP
120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);
121: END LOOP;

Line 118: htp.p ('');
119: FOR rec_salesrep IN cur_salesrep LOOP
120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);
121: END LOOP;
122: htp.FormSelectClose;

Line 120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);

116: htp.p('Sales Rep');
117: htp.p('');
118: htp.p ('');
119: FOR rec_salesrep IN cur_salesrep LOOP
120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);
121: END LOOP;
122: htp.FormSelectClose;
123: htp.p('');
124: htp.tableRowClose;
125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();

Line 123: htp.p('');

119: FOR rec_salesrep IN cur_salesrep LOOP
120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);
121: END LOOP;
122: htp.FormSelectClose;
123: htp.p('');
124: htp.tableRowClose;
125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();
127: htp.p('Qualifiers');

Line 124: htp.tableRowClose;

120: htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);
121: END LOOP;
122: htp.FormSelectClose;
123: htp.p('');
124: htp.tableRowClose;
125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();
127: htp.p('Qualifiers');
128: htp.p('');

Line 126: htp.tableRowOpen();

122: htp.FormSelectClose;
123: htp.p('');
124: htp.tableRowClose;
125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();
127: htp.p('Qualifiers');
128: htp.p('');
129: htp.p ('');
130: FOR rec_qual IN cur_qual LOOP
131: htp.FormSelectOption(rec_qual.seeded_qual_name, cattributes => ' value= '||rec_qual.qual_usg_id);

Line 128: htp.p('');

124: htp.tableRowClose;
125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();
127: htp.p('Qualifiers');
128: htp.p('');
129: htp.p ('');

125: /* Qualifier Search Restriction */
126: htp.tableRowOpen();
127: htp.p('Qualifiers');
128: htp.p('');
129: htp.p ('');
130: FOR rec_qual IN cur_qual LOOP
131: htp.FormSelectOption(rec_qual.seeded_qual_name, cattributes => ' value= '||rec_qual.qual_usg_id);
132: END LOOP;
133:
134: htp.FormSelectClose;
135: htp.p('');

Line 134: htp.FormSelectClose;

130: FOR rec_qual IN cur_qual LOOP
131: htp.FormSelectOption(rec_qual.seeded_qual_name, cattributes => ' value= '||rec_qual.qual_usg_id);
132: END LOOP;
133:
134: htp.FormSelectClose;
135: htp.p('');
136: htp.tableRowClose;
137:
138: htp.tableClose;

Line 135: htp.p('');

131: htp.FormSelectOption(rec_qual.seeded_qual_name, cattributes => ' value= '||rec_qual.qual_usg_id);
132: END LOOP;
133:
134: htp.FormSelectClose;
135: htp.p('');
136: htp.tableRowClose;
137:
138: htp.tableClose;
139: htp.Br;

Line 136: htp.tableRowClose;

132: END LOOP;
133:
134: htp.FormSelectClose;
135: htp.p('');
136: htp.tableRowClose;
137:
138: htp.tableClose;
139: htp.Br;
140: htp.Br;

Line 138: htp.tableClose;

134: htp.FormSelectClose;
135: htp.p('');
136: htp.tableRowClose;
137:
138: htp.tableClose;
139: htp.Br;
140: htp.Br;
141: htp.Br;
142: footer;

Line 139: htp.Br;

135: htp.p('');
136: htp.tableRowClose;
137:
138: htp.tableClose;
139: htp.Br;
140: htp.Br;
141: htp.Br;
142: footer;
143: htp.FormClose;

Line 140: htp.Br;

136: htp.tableRowClose;
137:
138: htp.tableClose;
139: htp.Br;
140: htp.Br;
141: htp.Br;
142: footer;
143: htp.FormClose;
144: htp.bodyclose;

Line 141: htp.Br;

137:
138: htp.tableClose;
139: htp.Br;
140: htp.Br;
141: htp.Br;
142: footer;
143: htp.FormClose;
144: htp.bodyclose;
145: htp.htmlclose;

Line 143: htp.FormClose;

139: htp.Br;
140: htp.Br;
141: htp.Br;
142: footer;
143: htp.FormClose;
144: htp.bodyclose;
145: htp.htmlclose;
146: else
147: htp.p('Invalid session');

Line 144: htp.bodyclose;

140: htp.Br;
141: htp.Br;
142: footer;
143: htp.FormClose;
144: htp.bodyclose;
145: htp.htmlclose;
146: else
147: htp.p('Invalid session');
148: end if;

Line 145: htp.htmlclose;

141: htp.Br;
142: footer;
143: htp.FormClose;
144: htp.bodyclose;
145: htp.htmlclose;
146: else
147: htp.p('Invalid session');
148: end if;
149: exception

Line 147: htp.p('Invalid session');

143: htp.FormClose;
144: htp.bodyclose;
145: htp.htmlclose;
146: else
147: htp.p('Invalid session');
148: end if;
149: exception
150: when others then
151: htp.p(SQLERRM);

Line 151: htp.p(SQLERRM);

147: htp.p('Invalid session');
148: end if;
149: exception
150: when others then
151: htp.p(SQLERRM);
152: END terr_definition_paramform;
153:
154:
155: procedure footer is

Line 158: htp.htmlopen;

154:
155: procedure footer is
156: BEGIN
157: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
158: htp.htmlopen;
159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );

Line 159: htp.tableRowOpen;

155: procedure footer is
156: BEGIN
157: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
158: htp.htmlopen;
159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;

Line 160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');

156: BEGIN
157: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
158: htp.htmlopen;
159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');

Line 161: htp.tableRowClose;

157: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
158: htp.htmlopen;
159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));

Line 162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );

158: htp.htmlopen;
159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');

Line 163: htp.tableRowOpen;

159: htp.tableRowOpen;
160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;

Line 164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');

160: htp.tableData( htf.hr, crowspan => '1', ccolspan => '190', cnowrap => 'TRUE');
161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;

Line 165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));

161: htp.tableRowClose;
162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;
169: htp.htmlClose;

Line 166: htp.tableData( '');

162: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;
169: htp.htmlClose;
170: END footer;

Line 167: htp.tableRowClose;

163: htp.tableRowOpen;
164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;
169: htp.htmlClose;
170: END footer;
171: END;

Line 168: htp.tableClose;

164: htp.formOpen( curl => l_agent||'JTF_TERR_DEFINITION_REPORT_PVT.report_wrapper', cmethod => 'post', cattributes => ' NAME="MyForm" TARGET="_top"');
165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;
169: htp.htmlClose;
170: END footer;
171: END;

Line 169: htp.htmlClose;

165: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
166: htp.tableData( '');
167: htp.tableRowClose;
168: htp.tableClose;
169: htp.htmlClose;
170: END footer;
171: END;