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.JTF_ACTIVITY_MANAGER dependencies on DBMS_SQL

Line 81: cid := DBMS_SQL.OPEN_CURSOR;

77:
78: select activity_name_id into activitynameid from jtf_act_types_tl
79: where language = userenv('LANG') and activity_name = activityname;
80:
81: cid := DBMS_SQL.OPEN_CURSOR;
82:
83: DBMS_SQL.PARSE(cid, 'insert into '|| v_tablename || '(activity_name_id, application_id ,
84: jtf_act_activity_logs_user_id, created_by, creation_date, last_updated_by,
85: last_update_date, component, column1, column2, column3, column4,column5,

Line 83: DBMS_SQL.PARSE(cid, 'insert into '|| v_tablename || '(activity_name_id, application_id ,

79: where language = userenv('LANG') and activity_name = activityname;
80:
81: cid := DBMS_SQL.OPEN_CURSOR;
82:
83: DBMS_SQL.PARSE(cid, 'insert into '|| v_tablename || '(activity_name_id, application_id ,
84: jtf_act_activity_logs_user_id, created_by, creation_date, last_updated_by,
85: last_update_date, component, column1, column2, column3, column4,column5,
86: column6, column7,column8,column9, column10, column11, column12, column13,
87: column14,column15, column16, column17,column18,column19, column20, column21,

Line 97: :column37, :column38, :column39, :column40 )', dbms_sql.v7);

93: :column8, :column9, :column10, :column11, :column12, :column13, :column14, :column15,
94: :column16, :column17, :column18, :column19, :column20, :column21, :column22,
95: :column23, :column24, :column25, :column26, :column27, :column28, :column29,
96: :column30, :column31, :column32, :column33, :column34, :column35, :column36,
97: :column37, :column38, :column39, :column40 )', dbms_sql.v7);
98:
99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);

Line 99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);

95: :column23, :column24, :column25, :column26, :column27, :column28, :column29,
96: :column30, :column31, :column32, :column33, :column34, :column35, :column36,
97: :column37, :column38, :column39, :column40 )', dbms_sql.v7);
98:
99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));

Line 100: DBMS_SQL.bind_variable(cid, ':appid', appid);

96: :column30, :column31, :column32, :column33, :column34, :column35, :column36,
97: :column37, :column38, :column39, :column40 )', dbms_sql.v7);
98:
99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));

Line 101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);

97: :column37, :column38, :column39, :column40 )', dbms_sql.v7);
98:
99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));

Line 102: DBMS_SQL.bind_variable(cid, ':component', v_component);

98:
99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));

Line 103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));

99: DBMS_SQL.bind_variable(cid, ':activitynameid', activitynameid);
100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));

Line 104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));

100: DBMS_SQL.bind_variable(cid, ':appid', appid);
101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));

Line 105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));

101: DBMS_SQL.bind_variable(cid, ':userid', v_userid);
102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));

Line 106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));

102: DBMS_SQL.bind_variable(cid, ':component', v_component);
103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));

Line 107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));

103: DBMS_SQL.bind_variable(cid, ':column1', v_columns(1));
104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));

Line 108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));

104: DBMS_SQL.bind_variable(cid, ':column2', v_columns(2));
105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));

Line 109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));

105: DBMS_SQL.bind_variable(cid, ':column3', v_columns(3));
106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));

Line 110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));

106: DBMS_SQL.bind_variable(cid, ':column4', v_columns(4));
107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));

Line 111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));

107: DBMS_SQL.bind_variable(cid, ':column5', v_columns(5));
108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));

Line 112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));

108: DBMS_SQL.bind_variable(cid, ':column6', v_columns(6));
109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));

Line 113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));

109: DBMS_SQL.bind_variable(cid, ':column7', v_columns(7));
110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));

Line 114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));

110: DBMS_SQL.bind_variable(cid, ':column8', v_columns(8));
111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));

Line 115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));

111: DBMS_SQL.bind_variable(cid, ':column9', v_columns(9));
112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));

Line 116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));

112: DBMS_SQL.bind_variable(cid, ':column10', v_columns(10));
113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));

Line 117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));

113: DBMS_SQL.bind_variable(cid, ':column11', v_columns(11));
114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));

Line 118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));

114: DBMS_SQL.bind_variable(cid, ':column12', v_columns(12));
115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));

Line 119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));

115: DBMS_SQL.bind_variable(cid, ':column13', v_columns(13));
116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));

Line 120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));

116: DBMS_SQL.bind_variable(cid, ':column14', v_columns(14));
117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));

Line 121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));

117: DBMS_SQL.bind_variable(cid, ':column15', v_columns(15));
118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));

Line 122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));

118: DBMS_SQL.bind_variable(cid, ':column16', v_columns(16));
119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));

Line 123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));

119: DBMS_SQL.bind_variable(cid, ':column17', v_columns(17));
120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));

Line 124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));

120: DBMS_SQL.bind_variable(cid, ':column18', v_columns(18));
121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));

Line 125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));

121: DBMS_SQL.bind_variable(cid, ':column19', v_columns(19));
122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));

Line 126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));

122: DBMS_SQL.bind_variable(cid, ':column20', v_columns(20));
123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));

Line 127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));

123: DBMS_SQL.bind_variable(cid, ':column21', v_columns(21));
124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));

Line 128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));

124: DBMS_SQL.bind_variable(cid, ':column22', v_columns(22));
125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));

Line 129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));

125: DBMS_SQL.bind_variable(cid, ':column23', v_columns(23));
126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));

Line 130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));

126: DBMS_SQL.bind_variable(cid, ':column24', v_columns(24));
127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));

Line 131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));

127: DBMS_SQL.bind_variable(cid, ':column25', v_columns(25));
128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));

Line 132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));

128: DBMS_SQL.bind_variable(cid, ':column26', v_columns(26));
129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));

Line 133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));

129: DBMS_SQL.bind_variable(cid, ':column27', v_columns(27));
130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));

Line 134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));

130: DBMS_SQL.bind_variable(cid, ':column28', v_columns(28));
131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));

Line 135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));

131: DBMS_SQL.bind_variable(cid, ':column29', v_columns(29));
132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));

Line 136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));

132: DBMS_SQL.bind_variable(cid, ':column30', v_columns(30));
133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));

Line 137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));

133: DBMS_SQL.bind_variable(cid, ':column31', v_columns(31));
134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));

Line 138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));

134: DBMS_SQL.bind_variable(cid, ':column32', v_columns(32));
135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));

Line 139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));

135: DBMS_SQL.bind_variable(cid, ':column33', v_columns(33));
136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);

Line 140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));

136: DBMS_SQL.bind_variable(cid, ':column34', v_columns(34));
137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);
144: DBMS_SQL.CLOSE_CURSOR(cid);

Line 141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));

137: DBMS_SQL.bind_variable(cid, ':column35', v_columns(35));
138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);
144: DBMS_SQL.CLOSE_CURSOR(cid);
145: EXCEPTION

Line 142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));

138: DBMS_SQL.bind_variable(cid, ':column36', v_columns(36));
139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);
144: DBMS_SQL.CLOSE_CURSOR(cid);
145: EXCEPTION
146: when NO_DATA_FOUND then

Line 143: ignore := DBMS_SQL.EXECUTE(cid);

139: DBMS_SQL.bind_variable(cid, ':column37', v_columns(37));
140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);
144: DBMS_SQL.CLOSE_CURSOR(cid);
145: EXCEPTION
146: when NO_DATA_FOUND then
147: RAISE;

Line 144: DBMS_SQL.CLOSE_CURSOR(cid);

140: DBMS_SQL.bind_variable(cid, ':column38', v_columns(38));
141: DBMS_SQL.bind_variable(cid, ':column39', v_columns(39));
142: DBMS_SQL.bind_variable(cid, ':column40', v_columns(40));
143: ignore := DBMS_SQL.EXECUTE(cid);
144: DBMS_SQL.CLOSE_CURSOR(cid);
145: EXCEPTION
146: when NO_DATA_FOUND then
147: RAISE;
148: when others then

Line 149: DBMS_SQL.CLOSE_CURSOR(cid);

145: EXCEPTION
146: when NO_DATA_FOUND then
147: RAISE;
148: when others then
149: DBMS_SQL.CLOSE_CURSOR(cid);
150: RAISE;
151:
152: end write;
153: