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"');
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" ');
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' );
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'));
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');
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');
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;
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;
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' );
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' );
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');
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. ') ||
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');
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');
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;
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;
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;
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;
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;
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;
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: -----------------------------------------------------------------------------------------------
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
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:
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');
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"');
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;
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' );
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');
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');
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( ' ');
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;
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;
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" ');
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:
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();
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('
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('
93: htp.tableRowClose;
94: htp.tableClose;
95: htp.tableOpen(cattributes=>'width="600" ');
96:
97: htp.tableRowOpen();
98: htp.p('