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

Line 444: d_sql_p := dbms_sql.open_cursor;

440:
441: Begin
442: query_range_loc( X_org_id, X_locator_lo, X_locator_hi, p_where_loc);
443: if ( p_where_loc IS NOT NULL ) then
444: d_sql_p := dbms_sql.open_cursor;
445:
446: d_sql_stmt :=
447: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
448: ' subinventory_name , locator_id , source_type , supplier_id,' ||

Line 479: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );

475: PUT_LINE(' p_where ='||p_where_loc );
476: PUT_LINE(' d_sql_stmt ='||substr(d_sql_stmt,1,75) );
477: PUT_LINE('Before parsing');
478:
479: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
480:
481: PUT_LINE('Parsed The statement in loc');
482:
483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

Line 483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

479: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
480:
481: PUT_LINE('Parsed The statement in loc');
482:
483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);

Line 484: dbms_sql.define_column(d_sql_p,2,d_org_id );

480:
481: PUT_LINE('Parsed The statement in loc');
482:
483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);

Line 485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);

481: PUT_LINE('Parsed The statement in loc');
482:
483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );

Line 486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );

482:
483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

Line 487: dbms_sql.define_column(d_sql_p,5,d_loc_id);

483: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

Line 488: dbms_sql.define_column(d_sql_p,6,d_src_type);

484: dbms_sql.define_column(d_sql_p,2,d_org_id );
485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

Line 489: dbms_sql.define_column(d_sql_p,7,d_supp_id );

485: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

Line 490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

486: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

Line 491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

487: dbms_sql.define_column(d_sql_p,5,d_loc_id);
488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

Line 492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

488: dbms_sql.define_column(d_sql_p,6,d_src_type);
489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);

Line 493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

489: dbms_sql.define_column(d_sql_p,7,d_supp_id );
490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);
497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

Line 494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

490: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);
497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
498:

Line 495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

491: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);
497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
498:
499: PUT_LINE('Defined the cols in locs');

Line 496: dbms_sql.define_column(d_sql_p,14,d_no_cards);

492: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);
497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
498:
499: PUT_LINE('Defined the cols in locs');
500:

Line 497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

493: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
494: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
495: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
496: dbms_sql.define_column(d_sql_p,14,d_no_cards);
497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
498:
499: PUT_LINE('Defined the cols in locs');
500:
501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

Line 501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

497: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
498:
499: PUT_LINE('Defined the cols in locs');
500:
501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

Line 502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

498:
499: PUT_LINE('Defined the cols in locs');
500:
501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

Line 503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);

499: PUT_LINE('Defined the cols in locs');
500:
501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

Line 504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);

500:
501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

Line 505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

501: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

Line 506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

502: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
510:

Line 507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

503: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
510:
511: PUT_LINE('Bind the vars');

Line 508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

504: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
510:
511: PUT_LINE('Bind the vars');
512:

Line 509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

505: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
506: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
507: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
508: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
510:
511: PUT_LINE('Bind the vars');
512:
513: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

Line 513: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

509: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
510:
511: PUT_LINE('Bind the vars');
512:
513: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
514:
515: PUT_LINE('No Rows ='||to_char(d_sql_rows_processed));
516:
517: Loop

Line 518: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then

514:
515: PUT_LINE('No Rows ='||to_char(d_sql_rows_processed));
516:
517: Loop
518: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
519: Rec := TRUE;
520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

Line 520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);

516:
517: Loop
518: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
519: Rec := TRUE;
520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);

Line 521: dbms_sql.column_value(d_sql_p,2, d_org_id);

517: Loop
518: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
519: Rec := TRUE;
520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);

Line 522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

518: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
519: Rec := TRUE;
520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);

Line 523: dbms_sql.column_value(d_sql_p,4, d_subinv);

519: Rec := TRUE;
520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

Line 524: dbms_sql.column_value(d_sql_p,5, d_loc_id);

520: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

Line 525: dbms_sql.column_value(d_sql_p,6, d_src_type);

521: dbms_sql.column_value(d_sql_p,2, d_org_id);
522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

Line 526: dbms_sql.column_value(d_sql_p,7, d_supp_id);

522: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

Line 527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

523: dbms_sql.column_value(d_sql_p,4, d_subinv);
524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

Line 528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

524: dbms_sql.column_value(d_sql_p,5, d_loc_id);
525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

Line 529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

525: dbms_sql.column_value(d_sql_p,6, d_src_type);
526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);

Line 530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

526: dbms_sql.column_value(d_sql_p,7, d_supp_id);
527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);
534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

Line 531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

527: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);
534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
535:

Line 532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

528: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);
534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
535:
536: card_check_and_create( d_pull_seq_id,

Line 533: dbms_sql.column_value(d_sql_p,14, d_no_cards);

529: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);
534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
535:
536: card_check_and_create( d_pull_seq_id,
537: d_org_id, d_inv_itm_id, d_subinv,

Line 534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

530: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
531: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
532: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
533: dbms_sql.column_value(d_sql_p,14, d_no_cards);
534: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
535:
536: card_check_and_create( d_pull_seq_id,
537: d_org_id, d_inv_itm_id, d_subinv,
538: d_loc_id, d_src_type,

Line 548: dbms_sql.close_cursor(d_sql_p);

544: d_release_kanban_flag,
545: V_REPORT_ID );
546: else
547: -- No more rows in cursor
548: dbms_sql.close_cursor(d_sql_p);
549: Exit;
550: end if;
551: End loop;
552: current_error_code := to_char(SQLCODE);

Line 559: if dbms_sql.is_open(d_sql_p) then

555: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
556: PUT_LINE( fnd_message.get );
557: current_error_code := to_char(SQLCODE);
558: end if;
559: if dbms_sql.is_open(d_sql_p) then
560: dbms_sql.close_cursor(d_sql_p);
561: end if;
562: end if;
563: Exception

Line 560: dbms_sql.close_cursor(d_sql_p);

556: PUT_LINE( fnd_message.get );
557: current_error_code := to_char(SQLCODE);
558: end if;
559: if dbms_sql.is_open(d_sql_p) then
560: dbms_sql.close_cursor(d_sql_p);
561: end if;
562: end if;
563: Exception
564: when others then

Line 570: if dbms_sql.is_open(d_sql_p) then

566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
568: print_error;
569: END IF;
570: if dbms_sql.is_open(d_sql_p) then
571: dbms_sql.close_cursor(d_sql_p);
572: end if;
573: v_success := 2;
574: current_error_code := to_char(SQLCODE);

Line 571: dbms_sql.close_cursor(d_sql_p);

567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
568: print_error;
569: END IF;
570: if dbms_sql.is_open(d_sql_p) then
571: dbms_sql.close_cursor(d_sql_p);
572: end if;
573: v_success := 2;
574: current_error_code := to_char(SQLCODE);
575: end;

Line 585: d_sql_p := dbms_sql.open_cursor;

581: query_range_itm( X_item_lo, X_item_hi, p_where_itm);
582: query_range_loc( X_org_id, X_locator_lo, X_locator_hi, p_where_loc);
583:
584: if (( p_where_itm IS NOT NULL ) AND ( p_where_loc IS NOT NULL)) then
585: d_sql_p := dbms_sql.open_cursor;
586: d_sql_stmt :=
587: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
588: ' subinventory_name , locator_id , source_type , supplier_id,' ||
589: ' supplier_site_id, source_organization_id, source_subinventory,' ||

Line 629: dbms_sql.parse( d_sql_p, d_sql_stmt2, dbms_sql.native );

625: PUT_LINE(' p_where_loc ='||p_where_loc );
626: PUT_LINE(' d_sql_stmt ='||d_sql_stmt );
627: PUT_LINE(' d_sql_stmt1 ='||d_sql_stmt1 );
628:
629: dbms_sql.parse( d_sql_p, d_sql_stmt2, dbms_sql.native );
630:
631: PUT_LINE('Parsed The statement in loc-itm');
632:
633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

Line 633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

629: dbms_sql.parse( d_sql_p, d_sql_stmt2, dbms_sql.native );
630:
631: PUT_LINE('Parsed The statement in loc-itm');
632:
633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);

Line 634: dbms_sql.define_column(d_sql_p,2,d_org_id );

630:
631: PUT_LINE('Parsed The statement in loc-itm');
632:
633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);

Line 635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);

631: PUT_LINE('Parsed The statement in loc-itm');
632:
633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );

Line 636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );

632:
633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

Line 637: dbms_sql.define_column(d_sql_p,5,d_loc_id);

633: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

Line 638: dbms_sql.define_column(d_sql_p,6,d_src_type);

634: dbms_sql.define_column(d_sql_p,2,d_org_id );
635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

Line 639: dbms_sql.define_column(d_sql_p,7,d_supp_id );

635: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

Line 640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

636: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

Line 641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

637: dbms_sql.define_column(d_sql_p,5,d_loc_id);
638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

Line 642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

638: dbms_sql.define_column(d_sql_p,6,d_src_type);
639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);

Line 643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

639: dbms_sql.define_column(d_sql_p,7,d_supp_id );
640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

Line 644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

640: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');

Line 645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

641: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');
649:

Line 646: dbms_sql.define_column(d_sql_p,14,d_no_cards);

642: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');
649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

Line 647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

643: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
644: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
645: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');
649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

Line 650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

646: dbms_sql.define_column(d_sql_p,14,d_no_cards);
647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');
649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

Line 651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

647: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
648: PUT_LINE('Defined the cols in loc-itm');
649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

Line 652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);

648: PUT_LINE('Defined the cols in loc-itm');
649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

Line 653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);

649:
650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

Line 654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

650: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

Line 655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

651: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
659:

Line 656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

652: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
659:
660: PUT_LINE('Bind the vars ');

Line 657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

653: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
659:
660: PUT_LINE('Bind the vars ');
661:

Line 658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

654: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
655: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
656: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
657: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
659:
660: PUT_LINE('Bind the vars ');
661:
662: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

Line 662: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

658: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
659:
660: PUT_LINE('Bind the vars ');
661:
662: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
663:
664: PUT_LINE('No ofRows='||to_char(d_sql_rows_processed));
665:
666: Loop

Line 667: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then

663:
664: PUT_LINE('No ofRows='||to_char(d_sql_rows_processed));
665:
666: Loop
667: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
668: Rec := TRUE;
669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

Line 669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);

665:
666: Loop
667: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
668: Rec := TRUE;
669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);

Line 670: dbms_sql.column_value(d_sql_p,2, d_org_id);

666: Loop
667: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
668: Rec := TRUE;
669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);

Line 671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

667: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
668: Rec := TRUE;
669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);

Line 672: dbms_sql.column_value(d_sql_p,4, d_subinv);

668: Rec := TRUE;
669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

Line 673: dbms_sql.column_value(d_sql_p,5, d_loc_id);

669: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

Line 674: dbms_sql.column_value(d_sql_p,6, d_src_type);

670: dbms_sql.column_value(d_sql_p,2, d_org_id);
671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

Line 675: dbms_sql.column_value(d_sql_p,7, d_supp_id);

671: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

Line 676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

672: dbms_sql.column_value(d_sql_p,4, d_subinv);
673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

Line 677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

673: dbms_sql.column_value(d_sql_p,5, d_loc_id);
674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

Line 678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

674: dbms_sql.column_value(d_sql_p,6, d_src_type);
675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);

Line 679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

675: dbms_sql.column_value(d_sql_p,7, d_supp_id);
676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);
683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

Line 680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

676: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);
683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
684:

Line 681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

677: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);
683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
684:
685: card_check_and_create( d_pull_seq_id,

Line 682: dbms_sql.column_value(d_sql_p,14, d_no_cards);

678: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);
683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
684:
685: card_check_and_create( d_pull_seq_id,
686: d_org_id, d_inv_itm_id, d_subinv,

Line 683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

679: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
680: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
681: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
682: dbms_sql.column_value(d_sql_p,14, d_no_cards);
683: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
684:
685: card_check_and_create( d_pull_seq_id,
686: d_org_id, d_inv_itm_id, d_subinv,
687: d_loc_id, d_src_type,

Line 697: dbms_sql.close_cursor(d_sql_p);

693: d_release_kanban_flag,
694: V_REPORT_ID );
695: else
696: -- No more rows in cursor
697: dbms_sql.close_cursor(d_sql_p);
698: Exit;
699: end if;
700: End loop;
701: current_error_code := to_char(SQLCODE);

Line 708: if dbms_sql.is_open(d_sql_p) then

704: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
705: PUT_LINE( fnd_message.get );
706: current_error_code := to_char(SQLCODE);
707: end if;
708: if dbms_sql.is_open(d_sql_p) then
709: dbms_sql.close_cursor(d_sql_p);
710: end if;
711: end if;
712: Exception

Line 709: dbms_sql.close_cursor(d_sql_p);

705: PUT_LINE( fnd_message.get );
706: current_error_code := to_char(SQLCODE);
707: end if;
708: if dbms_sql.is_open(d_sql_p) then
709: dbms_sql.close_cursor(d_sql_p);
710: end if;
711: end if;
712: Exception
713: when others then

Line 719: if dbms_sql.is_open(d_sql_p) then

715: THEN
716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
717: print_error;
718: END IF;
719: if dbms_sql.is_open(d_sql_p) then
720: dbms_sql.close_cursor(d_sql_p);
721: end if;
722: v_success := 2;
723: current_error_code := to_char(SQLCODE);

Line 720: dbms_sql.close_cursor(d_sql_p);

716: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
717: print_error;
718: END IF;
719: if dbms_sql.is_open(d_sql_p) then
720: dbms_sql.close_cursor(d_sql_p);
721: end if;
722: v_success := 2;
723: current_error_code := to_char(SQLCODE);
724: end;

Line 860: d_sql_p := dbms_sql.open_cursor;

856: Begin
857:
858: query_range_itm( X_item_lo, X_item_hi, p_where);
859: if ( p_where IS NOT NULL ) then
860: d_sql_p := dbms_sql.open_cursor;
861: d_sql_stmt :=
862: 'select pull_sequence_id ,organization_id ,inventory_item_id ,' ||
863: ' subinventory_name , locator_id , source_type , supplier_id,' ||
864: ' supplier_site_id, source_organization_id, source_subinventory,' ||

Line 892: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );

888:
889: PUT_LINE(' p_where ='||p_where );
890: PUT_LINE(' d_sql_stmt ='||d_sql_stmt );
891:
892: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
893:
894: PUT_LINE('Parsed The statement in no_loc');
895:
896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

Line 896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

892: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
893:
894: PUT_LINE('Parsed The statement in no_loc');
895:
896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);

Line 897: dbms_sql.define_column(d_sql_p,2,d_org_id );

893:
894: PUT_LINE('Parsed The statement in no_loc');
895:
896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);

Line 898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);

894: PUT_LINE('Parsed The statement in no_loc');
895:
896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );

Line 899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );

895:
896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

Line 900: dbms_sql.define_column(d_sql_p,5,d_loc_id);

896: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

Line 901: dbms_sql.define_column(d_sql_p,6,d_src_type);

897: dbms_sql.define_column(d_sql_p,2,d_org_id );
898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

Line 902: dbms_sql.define_column(d_sql_p,7,d_supp_id );

898: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

Line 903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

899: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

Line 904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

900: dbms_sql.define_column(d_sql_p,5,d_loc_id);
901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

Line 905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

901: dbms_sql.define_column(d_sql_p,6,d_src_type);
902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);

Line 906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

902: dbms_sql.define_column(d_sql_p,7,d_supp_id );
903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);
910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

Line 907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

903: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);
910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
911:

Line 908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

904: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);
910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
911:
912: PUT_LINE('Defined the cols in no_locs');

Line 909: dbms_sql.define_column(d_sql_p,14,d_no_cards);

905: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);
910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
911:
912: PUT_LINE('Defined the cols in no_locs');
913:

Line 910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

906: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
907: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
908: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
909: dbms_sql.define_column(d_sql_p,14,d_no_cards);
910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
911:
912: PUT_LINE('Defined the cols in no_locs');
913:
914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

Line 914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

910: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
911:
912: PUT_LINE('Defined the cols in no_locs');
913:
914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

Line 915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

911:
912: PUT_LINE('Defined the cols in no_locs');
913:
914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

Line 916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);

912: PUT_LINE('Defined the cols in no_locs');
913:
914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

Line 917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);

913:
914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

Line 918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

914: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

Line 919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

915: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
923:

Line 920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

916: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
923:
924: PUT_LINE('Bind the vars in no_locs');

Line 921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

917: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
923:
924: PUT_LINE('Bind the vars in no_locs');
925:

Line 922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

918: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
919: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
920: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
921: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
923:
924: PUT_LINE('Bind the vars in no_locs');
925:
926: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

Line 926: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

922: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
923:
924: PUT_LINE('Bind the vars in no_locs');
925:
926: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
927:
928: PUT_LINE('No ofRows ='||to_char(d_sql_rows_processed));
929:
930: Loop

Line 931: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then

927:
928: PUT_LINE('No ofRows ='||to_char(d_sql_rows_processed));
929:
930: Loop
931: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
932: Rec := TRUE;
933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

Line 933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);

929:
930: Loop
931: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
932: Rec := TRUE;
933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);

Line 934: dbms_sql.column_value(d_sql_p,2, d_org_id);

930: Loop
931: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
932: Rec := TRUE;
933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);

Line 935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

931: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
932: Rec := TRUE;
933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);

Line 936: dbms_sql.column_value(d_sql_p,4, d_subinv);

932: Rec := TRUE;
933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

Line 937: dbms_sql.column_value(d_sql_p,5, d_loc_id);

933: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

Line 938: dbms_sql.column_value(d_sql_p,6, d_src_type);

934: dbms_sql.column_value(d_sql_p,2, d_org_id);
935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

Line 939: dbms_sql.column_value(d_sql_p,7, d_supp_id);

935: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

Line 940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

936: dbms_sql.column_value(d_sql_p,4, d_subinv);
937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

Line 941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

937: dbms_sql.column_value(d_sql_p,5, d_loc_id);
938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

Line 942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

938: dbms_sql.column_value(d_sql_p,6, d_src_type);
939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);

Line 943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

939: dbms_sql.column_value(d_sql_p,7, d_supp_id);
940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);
947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);

Line 944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

940: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);
947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
948:

Line 945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

941: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);
947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
948:
949: card_check_and_create( d_pull_seq_id,

Line 946: dbms_sql.column_value(d_sql_p,14, d_no_cards);

942: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);
947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
948:
949: card_check_and_create( d_pull_seq_id,
950: d_org_id, d_inv_itm_id, d_subinv,

Line 947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);

943: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
944: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
945: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
946: dbms_sql.column_value(d_sql_p,14, d_no_cards);
947: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
948:
949: card_check_and_create( d_pull_seq_id,
950: d_org_id, d_inv_itm_id, d_subinv,
951: d_loc_id, d_src_type,

Line 961: dbms_sql.close_cursor(d_sql_p);

957: d_release_kanban_flag,
958: V_REPORT_ID );
959: else
960: -- No more rows in cursor
961: dbms_sql.close_cursor(d_sql_p);
962: Exit;
963: end if;
964: End loop;
965: current_error_code := to_char(SQLCODE);

Line 971: if dbms_sql.is_open(d_sql_p) then

967: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
968: PUT_LINE( fnd_message.get );
969: end if;
970: current_error_code := to_char(SQLCODE);
971: if dbms_sql.is_open(d_sql_p) then
972: dbms_sql.close_cursor(d_sql_p);
973: end if;
974: end if;
975: Exception

Line 972: dbms_sql.close_cursor(d_sql_p);

968: PUT_LINE( fnd_message.get );
969: end if;
970: current_error_code := to_char(SQLCODE);
971: if dbms_sql.is_open(d_sql_p) then
972: dbms_sql.close_cursor(d_sql_p);
973: end if;
974: end if;
975: Exception
976: when others then

Line 982: if dbms_sql.is_open(d_sql_p) then

978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
980: print_error;
981: END IF;
982: if dbms_sql.is_open(d_sql_p) then
983: dbms_sql.close_cursor(d_sql_p);
984: end if;
985: v_success := 2;
986: current_error_code := to_char(SQLCODE);

Line 983: dbms_sql.close_cursor(d_sql_p);

979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
980: print_error;
981: END IF;
982: if dbms_sql.is_open(d_sql_p) then
983: dbms_sql.close_cursor(d_sql_p);
984: end if;
985: v_success := 2;
986: current_error_code := to_char(SQLCODE);
987: return v_success;

Line 1528: dsql_cur := dbms_sql.open_cursor;

1524: v_parse_str := 'select '||v_loc_str||
1525: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1526: ' and organization_id = :org_id';
1527:
1528: dsql_cur := dbms_sql.open_cursor;
1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);

Line 1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);

1525: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1526: ' and organization_id = :org_id';
1527:
1528: dsql_cur := dbms_sql.open_cursor;
1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);

Line 1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);

1526: ' and organization_id = :org_id';
1527:
1528: dsql_cur := dbms_sql.open_cursor;
1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1534: rows_processed := dbms_sql.execute(dsql_cur);

Line 1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);

1528: dsql_cur := dbms_sql.open_cursor;
1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1534: rows_processed := dbms_sql.execute(dsql_cur);
1535:
1536: Loop

Line 1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);

1529: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1534: rows_processed := dbms_sql.execute(dsql_cur);
1535:
1536: Loop
1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then

Line 1534: rows_processed := dbms_sql.execute(dsql_cur);

1530: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1531:
1532: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1534: rows_processed := dbms_sql.execute(dsql_cur);
1535:
1536: Loop
1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1538: dbms_sql.column_value(dsql_cur,1,d_data_str);

Line 1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then

1533: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1534: rows_processed := dbms_sql.execute(dsql_cur);
1535:
1536: Loop
1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1538: dbms_sql.column_value(dsql_cur,1,d_data_str);
1539: else
1540: -- No more rows in cursor
1541: dbms_sql.close_cursor(dsql_cur);

Line 1538: dbms_sql.column_value(dsql_cur,1,d_data_str);

1534: rows_processed := dbms_sql.execute(dsql_cur);
1535:
1536: Loop
1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1538: dbms_sql.column_value(dsql_cur,1,d_data_str);
1539: else
1540: -- No more rows in cursor
1541: dbms_sql.close_cursor(dsql_cur);
1542: Exit;

Line 1541: dbms_sql.close_cursor(dsql_cur);

1537: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1538: dbms_sql.column_value(dsql_cur,1,d_data_str);
1539: else
1540: -- No more rows in cursor
1541: dbms_sql.close_cursor(dsql_cur);
1542: Exit;
1543: end if;
1544: End loop;
1545: if dbms_sql.is_open(dsql_cur) then

Line 1545: if dbms_sql.is_open(dsql_cur) then

1541: dbms_sql.close_cursor(dsql_cur);
1542: Exit;
1543: end if;
1544: End loop;
1545: if dbms_sql.is_open(dsql_cur) then
1546: dbms_sql.close_cursor(dsql_cur);
1547: end if;
1548: end if;
1549:

Line 1546: dbms_sql.close_cursor(dsql_cur);

1542: Exit;
1543: end if;
1544: End loop;
1545: if dbms_sql.is_open(dsql_cur) then
1546: dbms_sql.close_cursor(dsql_cur);
1547: end if;
1548: end if;
1549:
1550: if v_seg19_f and v_seg20_f then