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

Line 33: htp.htmlopen;

29: --
30: -----------------------------------------------------------------------------------------------
31: begin
32: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
33: htp.htmlopen;
34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 34: htp.headOpen;

30: -----------------------------------------------------------------------------------------------
31: begin
32: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
33: htp.htmlopen;
34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');

Line 35: htp.title('Missing Territory Assignments Report');

31: begin
32: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
33: htp.htmlopen;
34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );

Line 36: htp.headClose;

32: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
33: htp.htmlopen;
34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

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

33: htp.htmlopen;
34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');

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

34: htp.headOpen;
35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');

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

35: htp.title('Missing Territory Assignments Report');
36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;

Line 40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

36: htp.headClose;
37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;

Line 41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');

37: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );

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

38: htp.tableOpen('border="0" ');
39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );

Line 43: htp.tableRowClose;

39: htp.tableRowOpen( calign => 'TOP' );
40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');

Line 44: htp.tableClose;

40: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||

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

41: htp.tableData( '' || 'Missing Territory Assignments Report', cnowrap => 'TRUE');
42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

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

42: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
43: htp.tableRowClose;
44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');

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

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

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

44: htp.tableClose;
45: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;

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

46: htp.tableRowOpen( cvalign => 'top' );
47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;

Line 51: htp.Br;

47: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;

Line 52: htp.tableRowClose;

48: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;
56: htp.htmlClose;

Line 53: htp.tableClose;

49: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;
56: htp.htmlClose;
57: end;

Line 54: htp.bodyClose;

50: htp.tableData( ' ', ccolspan => '6');
51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;
56: htp.htmlClose;
57: end;
58: -----------------------------------------------------------------------------------------------

Line 55: htp.headClose;

51: htp.Br;
52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;
56: htp.htmlClose;
57: end;
58: -----------------------------------------------------------------------------------------------
59: procedure terr_miss_param is

Line 56: htp.htmlClose;

52: htp.tableRowClose;
53: htp.tableClose;
54: htp.bodyClose;
55: htp.headClose;
56: htp.htmlClose;
57: end;
58: -----------------------------------------------------------------------------------------------
59: procedure terr_miss_param is
60:

Line 81: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_ASGN_report.report_wrapper',

77: header;
78:
79: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
80: -------------------- Returns login user Id--------------------------
81: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_ASGN_report.report_wrapper',
82: cattributes => ' NAME="param"');
83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');

Line 83: htp.htmlopen;

79: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
80: -------------------- Returns login user Id--------------------------
81: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_ASGN_report.report_wrapper',
82: cattributes => ' NAME="param"');
83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 84: htp.headOpen;

80: -------------------- Returns login user Id--------------------------
81: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_ASGN_report.report_wrapper',
82: cattributes => ' NAME="param"');
83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;

Line 85: htp.title('Missing Territory Assignments Report');

81: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_MISS_ASGN_report.report_wrapper',
82: cattributes => ' NAME="param"');
83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );

Line 86: htp.headClose;

82: cattributes => ' NAME="param"');
83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');

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

83: htp.htmlopen;
84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');

Line 88: htp.tableopen;

84: htp.headOpen;
85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');

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

85: htp.title('Missing Territory Assignments Report');
86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;

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

86: htp.headClose;
87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;

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

87: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');

Line 92: htp.tableData( ' ');

88: htp.tableopen;
89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:

Line 93: htp.tableRowClose;

89: htp.tableRowOpen( cvalign => 'top' );
90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();

Line 94: htp.tableClose;

90: htp.tableData( ' ', cattributes => ' height=9');
91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();
98: htp.p('Select Output Format');

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

91: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.tableData( ' ');
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();
98: htp.p('Select Output Format');
99: htp.p('');

Line 97: htp.tableRowOpen();

93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();
98: htp.p('Select Output Format');
99: htp.p('');
100: htp.p ('');
101: htp.FormSelectOption('Excel');
102: htp.FormSelectOption('HTML',cselected => 'TRUE');

Line 99: htp.p('');

95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();
98: htp.p('Select Output Format');
99: htp.p('');
100: htp.p ('');

96:
97: htp.tableRowOpen();
98: htp.p('Select Output Format');
99: htp.p('');
100: htp.p ('');
101: htp.FormSelectOption('Excel');
102: htp.FormSelectOption('HTML',cselected => 'TRUE');
103: htp.FormSelectClose;
104: htp.tableRowClose;
105:

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

98: htp.p('Select Output Format');
99: htp.p('');
100: htp.p ('');
101: htp.FormSelectOption('Excel');
102: htp.FormSelectOption('HTML',cselected => 'TRUE');
103: htp.FormSelectClose;
104: htp.tableRowClose;
105:
106: --htp.tableRowClose;
107:

Line 104: htp.tableRowClose;

100: htp.p ('');

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

139: htp.tableOpen( calign => 'center', cattributes => ' border=0 cellspacing=2 cellpadding=2' );
140: htp.tableRowOpen;
141: htp.formOpen( curl => l_agent||'/AST_OFL_TERR_MISS_ASGN_report.report_wrapper', cmethod => 'GET',
142: cattributes => ' NAME="MyForm" TARGET="_top"');
143: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
144:
145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;

Line 145: --htp.tableData( '');

141: htp.formOpen( curl => l_agent||'/AST_OFL_TERR_MISS_ASGN_report.report_wrapper', cmethod => 'GET',
142: cattributes => ' NAME="MyForm" TARGET="_top"');
143: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
144:
145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;

Line 146: htp.tableData( '');

142: cattributes => ' NAME="MyForm" TARGET="_top"');
143: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
144:
145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;

Line 147: htp.tableRowClose;

143: htp.tableData( htf.formSubmit( cvalue => 'OK', cattributes => ' onMouseOver="window.status=''OK'';return true"'));
144:
145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;

Line 148: htp.tableClose;

144:
145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;

Line 149: htp.htmlClose;

145: --htp.tableData( '');
146: htp.tableData( '');
147: htp.tableRowClose;
148: htp.tableClose;
149: htp.htmlClose;
150: END footer;
151: END;