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

Line 1216: l_cursor := dbms_sql.open_cursor;

1212: -----------------------------------------------------
1213: -----------------
1214: -- Now execute it
1215: -----------------
1216: l_cursor := dbms_sql.open_cursor;
1217:
1218: -----------------------------------------------------
1219: l_debug_info := 'parse cursor';
1220: -----------------------------------------------------

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

1217:
1218: -----------------------------------------------------
1219: l_debug_info := 'parse cursor';
1220: -----------------------------------------------------
1221: dbms_sql.parse(l_cursor, l_sqlstmt, dbms_sql.native);
1222:
1223:
1224: /* BUG 7025517 -- bind the input vars */
1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;

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

1221: dbms_sql.parse(l_cursor, l_sqlstmt, dbms_sql.native);
1222:
1223:
1224: /* BUG 7025517 -- bind the input vars */
1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;

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

1222:
1223:
1224: /* BUG 7025517 -- bind the input vars */
1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;

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

1223:
1224: /* BUG 7025517 -- bind the input vars */
1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1231: if (l_code_combination_id is not null) then

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

1224: /* BUG 7025517 -- bind the input vars */
1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1231: if (l_code_combination_id is not null) then
1232: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;

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

1225: dbms_sql.bind_variable(l_cursor,':l_report_header_id', l_report_header_id) ;
1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1231: if (l_code_combination_id is not null) then
1232: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1233: end if;

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

1226: dbms_sql.bind_variable(l_cursor,':p_report_line_id', p_report_line_id) ;
1227: dbms_sql.bind_variable(l_cursor,':l_report_distribution_id', l_report_distribution_id) ;
1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1231: if (l_code_combination_id is not null) then
1232: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1233: end if;
1234: if (l_org_id is not null) then

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

1228: dbms_sql.bind_variable(l_cursor,':l_sequence_num', l_sequence_num) ;
1229: dbms_sql.bind_variable(l_cursor,':l_last_updated_by', l_last_updated_by) ;
1230: dbms_sql.bind_variable(l_cursor,':l_created_by', l_created_by) ;
1231: if (l_code_combination_id is not null) then
1232: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1233: end if;
1234: if (l_org_id is not null) then
1235: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1236: end if;

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

1231: if (l_code_combination_id is not null) then
1232: dbms_sql.bind_variable(l_cursor,':l_code_combination_id', l_code_combination_id) ;
1233: end if;
1234: if (l_org_id is not null) then
1235: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1236: end if;
1237: if (l_amount is not null) then
1238: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1239: end if;

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

1234: if (l_org_id is not null) then
1235: dbms_sql.bind_variable(l_cursor,':l_org_id', l_org_id) ;
1236: end if;
1237: if (l_amount is not null) then
1238: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1239: end if;
1240: if (l_project_id is not null) then
1241: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1242: end if;

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

1237: if (l_amount is not null) then
1238: dbms_sql.bind_variable(l_cursor,':l_amount', l_amount) ;
1239: end if;
1240: if (l_project_id is not null) then
1241: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1242: end if;
1243: if (l_task_id is not null) then
1244: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1245: end if;

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

1240: if (l_project_id is not null) then
1241: dbms_sql.bind_variable(l_cursor,':l_project_id', l_project_id) ;
1242: end if;
1243: if (l_task_id is not null) then
1244: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1245: end if;
1246: if (l_award_id is not null) then
1247: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1248: end if;

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

1243: if (l_task_id is not null) then
1244: dbms_sql.bind_variable(l_cursor,':l_task_id', l_task_id) ;
1245: end if;
1246: if (l_award_id is not null) then
1247: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1248: end if;
1249: if (l_expenditure_organization_id is not null) then
1250: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1251: end if;

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

1246: if (l_award_id is not null) then
1247: dbms_sql.bind_variable(l_cursor,':l_award_id', l_award_id) ;
1248: end if;
1249: if (l_expenditure_organization_id is not null) then
1250: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1251: end if;
1252: if (l_cost_center is not null) then
1253: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1254: end if;

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

1249: if (l_expenditure_organization_id is not null) then
1250: dbms_sql.bind_variable(l_cursor,':l_expenditure_organization_id', l_expenditure_organization_id) ;
1251: end if;
1252: if (l_cost_center is not null) then
1253: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1254: end if;
1255:
1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;

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

1252: if (l_cost_center is not null) then
1253: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1254: end if;
1255:
1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;

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

1253: dbms_sql.bind_variable(l_cursor,':l_cost_center', l_cost_center) ;
1254: end if;
1255:
1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;

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

1254: end if;
1255:
1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;

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

1255:
1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;

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

1256: if (p_seg1 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg1', p_seg1) ; end if ;
1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;

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

1257: if (p_seg2 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg2', p_seg2) ; end if ;
1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;

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

1258: if (p_seg3 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg3', p_seg3) ; end if ;
1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;

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

1259: if (p_seg4 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg4', p_seg4) ; end if ;
1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;

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

1260: if (p_seg5 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg5', p_seg5) ; end if ;
1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;

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

1261: if (p_seg6 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg6', p_seg6) ; end if ;
1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;

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

1262: if (p_seg7 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg7', p_seg7) ; end if ;
1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;

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

1263: if (p_seg8 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg8', p_seg8) ; end if ;
1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;

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

1264: if (p_seg9 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg9', p_seg9) ; end if ;
1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;

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

1265: if (p_seg10 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg10', p_seg10) ; end if ;
1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;

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

1266: if (p_seg11 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg11', p_seg11) ; end if ;
1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;

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

1267: if (p_seg12 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg12', p_seg12) ; end if ;
1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;

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

1268: if (p_seg13 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg13', p_seg13) ; end if ;
1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;

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

1269: if (p_seg14 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg14', p_seg14) ; end if ;
1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;

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

1270: if (p_seg15 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg15', p_seg15) ; end if ;
1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;

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

1271: if (p_seg16 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg16', p_seg16) ; end if ;
1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;

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

1272: if (p_seg17 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg17', p_seg17) ; end if ;
1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;

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

1273: if (p_seg18 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg18', p_seg18) ; end if ;
1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;

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

1274: if (p_seg19 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg19', p_seg19) ; end if ;
1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;

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

1275: if (p_seg20 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg20', p_seg20) ; end if ;
1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;

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

1276: if (p_seg21 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg21', p_seg21) ; end if ;
1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;

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

1277: if (p_seg22 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg22', p_seg22) ; end if ;
1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1285: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;

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

1278: if (p_seg23 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg23', p_seg23) ; end if ;
1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1285: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1286:

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

1279: if (p_seg24 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg24', p_seg24) ; end if ;
1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1285: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1286:
1287:

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

1280: if (p_seg25 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg25', p_seg25) ; end if ;
1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1285: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1286:
1287:
1288: /* BUG 7025517 ... End */

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

1281: if (p_seg26 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg26', p_seg26) ; end if ;
1282: if (p_seg27 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg27', p_seg27) ; end if ;
1283: if (p_seg28 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg28', p_seg28) ; end if ;
1284: if (p_seg29 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg29', p_seg29) ; end if ;
1285: if (p_seg30 is not null) then dbms_sql.bind_variable(l_cursor,':p_seg30', p_seg30) ; end if ;
1286:
1287:
1288: /* BUG 7025517 ... End */
1289:

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

1290:
1291: -----------------------------------------------------
1292: l_debug_info := 'execute cursor';
1293: -----------------------------------------------------
1294: l_rows := dbms_sql.execute(l_cursor);
1295:
1296:
1297: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPDIST_PKG',
1298: 'end AddDistributionLine');