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

Line 1177: l_cursor := dbms_sql.open_cursor;

1173: -----------------------------------------------------
1174: -----------------
1175: -- Now execute it
1176: -----------------
1177: l_cursor := dbms_sql.open_cursor;
1178:
1179: -----------------------------------------------------
1180: l_debug_info := 'parse cursor';
1181: -----------------------------------------------------

Line 1182: dbms_sql.parse(l_cursor, l_sqlstmt, dbms_sql.native);

1178:
1179: -----------------------------------------------------
1180: l_debug_info := 'parse cursor';
1181: -----------------------------------------------------
1182: dbms_sql.parse(l_cursor, l_sqlstmt, dbms_sql.native);
1183:
1184:
1185: /* BUG 7025517 -- bind the input vars */
1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;

Line 1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;

1182: dbms_sql.parse(l_cursor, l_sqlstmt, dbms_sql.native);
1183:
1184:
1185: /* BUG 7025517 -- bind the input vars */
1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;

Line 1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;

1183:
1184:
1185: /* BUG 7025517 -- bind the input vars */
1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;

Line 1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;

1184:
1185: /* BUG 7025517 -- bind the input vars */
1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1192: if (l_code_combination_id is not null) then

Line 1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;

1185: /* BUG 7025517 -- bind the input vars */
1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1192: if (l_code_combination_id is not null) then
1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;

Line 1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;

1186: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1192: if (l_code_combination_id is not null) then
1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1194: end if;

Line 1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;

1187: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1188: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1192: if (l_code_combination_id is not null) then
1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1194: end if;
1195: if (l_org_id is not null) then

Line 1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;

1189: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1190: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1191: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1192: if (l_code_combination_id is not null) then
1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1194: end if;
1195: if (l_org_id is not null) then
1196: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1197: end if;

Line 1196: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;

1192: if (l_code_combination_id is not null) then
1193: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1194: end if;
1195: if (l_org_id is not null) then
1196: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1197: end if;
1198: if (l_amount is not null) then
1199: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1200: end if;

Line 1199: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;

1195: if (l_org_id is not null) then
1196: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1197: end if;
1198: if (l_amount is not null) then
1199: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1200: end if;
1201: if (l_project_id is not null) then
1202: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1203: end if;

Line 1202: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;

1198: if (l_amount is not null) then
1199: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1200: end if;
1201: if (l_project_id is not null) then
1202: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1203: end if;
1204: if (l_task_id is not null) then
1205: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1206: end if;

Line 1205: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;

1201: if (l_project_id is not null) then
1202: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1203: end if;
1204: if (l_task_id is not null) then
1205: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1206: end if;
1207: if (l_award_id is not null) then
1208: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1209: end if;

Line 1208: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;

1204: if (l_task_id is not null) then
1205: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1206: end if;
1207: if (l_award_id is not null) then
1208: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1209: end if;
1210: if (l_expenditure_organization_id is not null) then
1211: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1212: end if;

Line 1211: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;

1207: if (l_award_id is not null) then
1208: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1209: end if;
1210: if (l_expenditure_organization_id is not null) then
1211: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1212: end if;
1213: if (l_cost_center is not null) then
1214: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1215: end if;

Line 1214: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;

1210: if (l_expenditure_organization_id is not null) then
1211: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1212: end if;
1213: if (l_cost_center is not null) then
1214: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1215: end if;
1216:
1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;

Line 1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;

1213: if (l_cost_center is not null) then
1214: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1215: end if;
1216:
1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;

Line 1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;

1214: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1215: end if;
1216:
1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;

Line 1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;

1215: end if;
1216:
1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;

Line 1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;

1216:
1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;

Line 1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;

1217: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;

Line 1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;

1218: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;

Line 1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;

1219: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;

Line 1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;

1220: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;

Line 1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;

1221: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;

Line 1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;

1222: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;

Line 1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;

1223: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;

Line 1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;

1224: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;

Line 1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;

1225: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;

Line 1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;

1226: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;

Line 1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;

1227: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;

Line 1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;

1228: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;

Line 1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;

1229: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;

Line 1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;

1230: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;

Line 1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;

1231: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;

Line 1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;

1232: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;

Line 1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;

1233: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;

Line 1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;

1234: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;

Line 1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;

1235: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;

Line 1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;

1236: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;

Line 1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;

1237: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;

Line 1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;

1238: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;

Line 1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;

1239: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1247:

Line 1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;

1240: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1247:
1248:

Line 1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;

1241: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1247:
1248:
1249: /* BUG 7025517 ... End */

Line 1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;

1242: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1243: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1244: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1245: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1246: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1247:
1248:
1249: /* BUG 7025517 ... End */
1250:

Line 1255: l_rows := dbms_sql.execute(l_cursor);

1251:
1252: -----------------------------------------------------
1253: l_debug_info := 'execute cursor';
1254: -----------------------------------------------------
1255: l_rows := dbms_sql.execute(l_cursor);
1256:
1257:
1258: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1259: 'end AddDistributionLine');