32: -- Changed for 11i AJScott
33: -- select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
34: select fnd_date.date_to_chardate(sysdate) into v_date_time from dual;
35:
36: htp.htmlopen;
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
33: -- select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
34: select fnd_date.date_to_chardate(sysdate) into v_date_time from dual;
35:
36: htp.htmlopen;
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
34: select fnd_date.date_to_chardate(sysdate) into v_date_time from dual;
35:
36: htp.htmlopen;
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
35:
36: htp.htmlopen;
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
36: htp.htmlopen;
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
37: htp.headOpen;
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
38: htp.title('Account Classification Report');
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
39: htp.headClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
40: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
41: htp.tableOpen('border="0" ');
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
42: htp.tableRowOpen( calign => 'TOP' );
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
43: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
44: htp.tableData( '' || 'Account Classification Report', cnowrap => 'TRUE');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
45: htp.tableData(htf.bold(v_date_time),calign => 'right',ccolspan => '110');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
46: htp.tableRowClose;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
47: htp.tableClose;
48: htp.tableOpen( cattributes => 'border=0 cellspacing=0 cellpadding=0 width=561' );
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
49: htp.tableRowOpen( cvalign => 'top' );
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
50: htp.tableData( ' ', ccolspan => '2', cattributes => ' height=9');
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
51: htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
59: htp.htmlClose;
52: '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
59: htp.htmlClose;
60: end;
53: htp.tableData( ' ', ccolspan => '6');
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
59: htp.htmlClose;
60: end;
61: -----------------------------------------------------------------------------------------------
54: htp.Br;
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
59: htp.htmlClose;
60: end;
61: -----------------------------------------------------------------------------------------------
62: procedure terr_acc_class_param is
55: htp.tableRowClose;
56: htp.tableClose;
57: htp.bodyClose;
58: htp.headClose;
59: htp.htmlClose;
60: end;
61: -----------------------------------------------------------------------------------------------
62: procedure terr_acc_class_param is
63:
85: header;
86:
87: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
88: -------------------- Returns login user Id--------------------------
89: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_acc_class_report.report_wrapper',
90: cattributes => ' NAME="param"');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
87: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
88: -------------------- Returns login user Id--------------------------
89: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_acc_class_report.report_wrapper',
90: cattributes => ' NAME="param"');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
88: -------------------- Returns login user Id--------------------------
89: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_acc_class_report.report_wrapper',
90: cattributes => ' NAME="param"');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
89: htp.FormOpen(owa_util.Get_Owa_Service_Path||'AST_OFL_TERR_acc_class_report.report_wrapper',
90: cattributes => ' NAME="param"');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
90: cattributes => ' NAME="param"');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
91: htp.htmlopen;
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
92: htp.headOpen;
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
93: htp.title('Account Classification Report');
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
94: htp.headClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
95: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
96: htp.tableopen;
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
104:
97: htp.tableRowOpen( cvalign => 'top' );
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
104:
105: htp.tableRowOpen();
98: htp.tableData( ' ', cattributes => ' height=9');
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
104:
105: htp.tableRowOpen();
106: htp.p('
99: htp.tableData( '' || '', calign => 'right', crowspan => '2', ccolspan => '3', cattributes => ' width=154');
100: htp.tableData( ' ');
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
104:
105: htp.tableRowOpen();
106: htp.p('
101: htp.tableRowClose;
102: htp.tableClose;
103: htp.tableOpen(cattributes=>'width="600" ');
104:
105: htp.tableRowOpen();
106: htp.p('