953: c_outputs8 := c_outputs1;
954: c_outputs9 := c_outputs1;
955: c_outputs10 := c_outputs1;
956:
957: c_call := dbms_sql.open_cursor;
958:
959: dbms_sql.parse(c_call,'begin '||r.ICX_CUSTOM_CALL||'(:c_inputs1,:c_inputs2,:c_inputs3,:c_inputs4,:c_inputs5,:c_inputs6,:c_inputs7,:c_inputs8,:c_inputs9,:c_inputs10,
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
955: c_outputs10 := c_outputs1;
956:
957: c_call := dbms_sql.open_cursor;
958:
959: dbms_sql.parse(c_call,'begin '||r.ICX_CUSTOM_CALL||'(:c_inputs1,:c_inputs2,:c_inputs3,:c_inputs4,:c_inputs5,:c_inputs6,:c_inputs7,:c_inputs8,:c_inputs9,:c_inputs10,
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
956:
957: c_call := dbms_sql.open_cursor;
958:
959: dbms_sql.parse(c_call,'begin '||r.ICX_CUSTOM_CALL||'(:c_inputs1,:c_inputs2,:c_inputs3,:c_inputs4,:c_inputs5,:c_inputs6,:c_inputs7,:c_inputs8,:c_inputs9,:c_inputs10,
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
958:
959: dbms_sql.parse(c_call,'begin '||r.ICX_CUSTOM_CALL||'(:c_inputs1,:c_inputs2,:c_inputs3,:c_inputs4,:c_inputs5,:c_inputs6,:c_inputs7,:c_inputs8,:c_inputs9,:c_inputs10,
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
959: dbms_sql.parse(c_call,'begin '||r.ICX_CUSTOM_CALL||'(:c_inputs1,:c_inputs2,:c_inputs3,:c_inputs4,:c_inputs5,:c_inputs6,:c_inputs7,:c_inputs8,:c_inputs9,:c_inputs10,
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
960: :c_outputs1,:c_outputs2,:c_outputs3,:c_outputs4,:c_outputs5,:c_outputs6,:c_outputs7,:c_outputs8,:c_outputs9,:c_outputs10); end;',dbms_sql.native);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
961:
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
962: dbms_sql.bind_variable(c_call,'c_inputs1',c_inputs1);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
963: dbms_sql.bind_variable(c_call,'c_inputs2',c_inputs2);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
964: dbms_sql.bind_variable(c_call,'c_inputs3',c_inputs3);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
965: dbms_sql.bind_variable(c_call,'c_inputs4',c_inputs4);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
966: dbms_sql.bind_variable(c_call,'c_inputs5',c_inputs5);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
967: dbms_sql.bind_variable(c_call,'c_inputs6',c_inputs6);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
968: dbms_sql.bind_variable(c_call,'c_inputs7',c_inputs7);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
969: dbms_sql.bind_variable(c_call,'c_inputs8',c_inputs8);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
970: dbms_sql.bind_variable(c_call,'c_inputs9',c_inputs9);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
971: dbms_sql.bind_variable(c_call,'c_inputs10',c_inputs10);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
972: dbms_sql.bind_variable(c_call,'c_outputs1',c_outputs1);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
973: dbms_sql.bind_variable(c_call,'c_outputs2',c_outputs2);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
974: dbms_sql.bind_variable(c_call,'c_outputs3',c_outputs3);
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
975: dbms_sql.bind_variable(c_call,'c_outputs4',c_outputs4);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
983: c_dummy := dbms_sql.execute(c_call);
976: dbms_sql.bind_variable(c_call,'c_outputs5',c_outputs5);
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
983: c_dummy := dbms_sql.execute(c_call);
984:
977: dbms_sql.bind_variable(c_call,'c_outputs6',c_outputs6);
978: dbms_sql.bind_variable(c_call,'c_outputs7',c_outputs7);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
983: c_dummy := dbms_sql.execute(c_call);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
979: dbms_sql.bind_variable(c_call,'c_outputs8',c_outputs8);
980: dbms_sql.bind_variable(c_call,'c_outputs9',c_outputs9);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
983: c_dummy := dbms_sql.execute(c_call);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
981: dbms_sql.bind_variable(c_call,'c_outputs10',c_outputs10);
982:
983: c_dummy := dbms_sql.execute(c_call);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
982:
983: c_dummy := dbms_sql.execute(c_call);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
983: c_dummy := dbms_sql.execute(c_call);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
984:
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
985: dbms_sql.variable_value(c_call,'c_outputs1',c_outputs1);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
986: dbms_sql.variable_value(c_call,'c_outputs2',c_outputs2);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
987: dbms_sql.variable_value(c_call,'c_outputs3',c_outputs3);
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
995:
988: dbms_sql.variable_value(c_call,'c_outputs4',c_outputs4);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
995:
996: dbms_sql.close_cursor(c_call);
989: dbms_sql.variable_value(c_call,'c_outputs5',c_outputs5);
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
995:
996: dbms_sql.close_cursor(c_call);
997:
990: dbms_sql.variable_value(c_call,'c_outputs6',c_outputs6);
991: dbms_sql.variable_value(c_call,'c_outputs7',c_outputs7);
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
995:
996: dbms_sql.close_cursor(c_call);
997:
998: c_from_region_appl_id := r.REGION_APPLICATION_ID;
992: dbms_sql.variable_value(c_call,'c_outputs8',c_outputs8);
993: dbms_sql.variable_value(c_call,'c_outputs9',c_outputs9);
994: dbms_sql.variable_value(c_call,'c_outputs10',c_outputs10);
995:
996: dbms_sql.close_cursor(c_call);
997:
998: c_from_region_appl_id := r.REGION_APPLICATION_ID;
999: c_from_region_code := r.REGION_CODE;
1000: