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 481: d_sql_p := dbms_sql.open_cursor;

477:
478: Begin
479: query_range_loc( X_org_id, X_locator_lo, X_locator_hi, p_where_loc);
480: if ( p_where_loc IS NOT NULL ) then
481: d_sql_p := dbms_sql.open_cursor;
482: --Changes for Ekanban Bug 11829018
483: IF NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN
484: d_sql_stmt :=
485: 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||

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

560: PUT_LINE(' d_sql_stmt ='||substr(d_sql_stmt,1,75) );
561: PUT_LINE(' d_sql_stmt ='||d_sql_stmt );
562: PUT_LINE('Before parsing');
563:
564: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
565:
566: PUT_LINE('Parsed The statement in loc');
567:
568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

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

564: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
565:
566: PUT_LINE('Parsed The statement in loc');
567:
568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);

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

565:
566: PUT_LINE('Parsed The statement in loc');
567:
568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);

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

566: PUT_LINE('Parsed The statement in loc');
567:
568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );

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

567:
568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

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

568: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

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

569: dbms_sql.define_column(d_sql_p,2,d_org_id );
570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

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

570: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

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

571: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

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

572: dbms_sql.define_column(d_sql_p,5,d_loc_id);
573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

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

573: dbms_sql.define_column(d_sql_p,6,d_src_type);
574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);

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

574: dbms_sql.define_column(d_sql_p,7,d_supp_id );
575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

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

575: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:

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

576: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:
584: PUT_LINE('Defined the cols in locs');

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

577: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:
584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

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

578: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
579: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
580: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:
584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

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

581: dbms_sql.define_column(d_sql_p,14,d_no_cards);
582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:
584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

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

582: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
583:
584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

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

583:
584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

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

584: PUT_LINE('Defined the cols in locs');
585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

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

585: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

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

586: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
594:

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

587: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
594:
595: PUT_LINE('Bind the vars');

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

588: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
594:
595: PUT_LINE('Bind the vars');
596:

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

589: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
590: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
591: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
592: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
594:
595: PUT_LINE('Bind the vars');
596:
597: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

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

593: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
594:
595: PUT_LINE('Bind the vars');
596:
597: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
598:
599: PUT_LINE('No Rows ='||to_char(d_sql_rows_processed));
600:
601: Loop

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

598:
599: PUT_LINE('No Rows ='||to_char(d_sql_rows_processed));
600:
601: Loop
602: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
603: Rec := TRUE;
604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

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

600:
601: Loop
602: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
603: Rec := TRUE;
604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);

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

601: Loop
602: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
603: Rec := TRUE;
604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);

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

602: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
603: Rec := TRUE;
604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);

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

603: Rec := TRUE;
604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

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

604: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

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

605: dbms_sql.column_value(d_sql_p,2, d_org_id);
606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

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

606: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

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

607: dbms_sql.column_value(d_sql_p,4, d_subinv);
608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

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

608: dbms_sql.column_value(d_sql_p,5, d_loc_id);
609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

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

609: dbms_sql.column_value(d_sql_p,6, d_src_type);
610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);

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

610: dbms_sql.column_value(d_sql_p,7, d_supp_id);
611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);
618: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

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

611: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);
618: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
619:

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

612: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);
618: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
619:
620: card_check_and_create( d_pull_seq_id,

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

613: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);
618: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
619:
620: card_check_and_create( d_pull_seq_id,
621: d_org_id, d_inv_itm_id, d_subinv,

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

614: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
615: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
616: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
617: dbms_sql.column_value(d_sql_p,14, d_no_cards);
618: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
619:
620: card_check_and_create( d_pull_seq_id,
621: d_org_id, d_inv_itm_id, d_subinv,
622: d_loc_id, d_src_type,

Line 634: dbms_sql.close_cursor(d_sql_p);

630: X_CREATE_CARD_FLAG,
631: X_PLAN_CARD_FLAG);
632: else
633: -- No more rows in cursor
634: dbms_sql.close_cursor(d_sql_p);
635: Exit;
636: end if;
637: End loop;
638: current_error_code := to_char(SQLCODE);

Line 645: if dbms_sql.is_open(d_sql_p) then

641: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
642: PUT_LINE( fnd_message.get );
643: current_error_code := to_char(SQLCODE);
644: end if;
645: if dbms_sql.is_open(d_sql_p) then
646: dbms_sql.close_cursor(d_sql_p);
647: end if;
648: end if;
649: Exception

Line 646: dbms_sql.close_cursor(d_sql_p);

642: PUT_LINE( fnd_message.get );
643: current_error_code := to_char(SQLCODE);
644: end if;
645: if dbms_sql.is_open(d_sql_p) then
646: dbms_sql.close_cursor(d_sql_p);
647: end if;
648: end if;
649: Exception
650: when others then

Line 656: if dbms_sql.is_open(d_sql_p) then

652: THEN
653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
654: print_error;
655: END IF;
656: if dbms_sql.is_open(d_sql_p) then
657: dbms_sql.close_cursor(d_sql_p);
658: end if;
659: v_success := 2;
660: current_error_code := to_char(SQLCODE);

Line 657: dbms_sql.close_cursor(d_sql_p);

653: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
654: print_error;
655: END IF;
656: if dbms_sql.is_open(d_sql_p) then
657: dbms_sql.close_cursor(d_sql_p);
658: end if;
659: v_success := 2;
660: current_error_code := to_char(SQLCODE);
661: end;

Line 671: d_sql_p := dbms_sql.open_cursor;

667: query_range_itm( X_item_lo, X_item_hi, p_where_itm);
668: query_range_loc( X_org_id, X_locator_lo, X_locator_hi, p_where_loc);
669:
670: if (( p_where_itm IS NOT NULL ) AND ( p_where_loc IS NOT NULL)) then
671: d_sql_p := dbms_sql.open_cursor;
672: --Changes for Ekanban Bug 11829018
673: IF NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN
674: d_sql_stmt := 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||
675: ' mkps.subinventory_name , mkps.locator_id , mkps.source_type , mkps.supplier_id,' ||

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

764: PUT_LINE(' p_where_loc ='||p_where_loc );
765: PUT_LINE(' d_sql_stmt ='||d_sql_stmt );
766: PUT_LINE(' d_sql_stmt1 ='||d_sql_stmt1 );
767:
768: dbms_sql.parse( d_sql_p, d_sql_stmt2, dbms_sql.native );
769:
770: PUT_LINE('Parsed The statement in loc-itm');
771:
772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

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

768: dbms_sql.parse( d_sql_p, d_sql_stmt2, dbms_sql.native );
769:
770: PUT_LINE('Parsed The statement in loc-itm');
771:
772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);

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

769:
770: PUT_LINE('Parsed The statement in loc-itm');
771:
772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);

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

770: PUT_LINE('Parsed The statement in loc-itm');
771:
772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );

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

771:
772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

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

772: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

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

773: dbms_sql.define_column(d_sql_p,2,d_org_id );
774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

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

774: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

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

775: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

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

776: dbms_sql.define_column(d_sql_p,5,d_loc_id);
777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

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

777: dbms_sql.define_column(d_sql_p,6,d_src_type);
778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);

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

778: dbms_sql.define_column(d_sql_p,7,d_supp_id );
779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

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

779: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');

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

780: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');
788:

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

781: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');
788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

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

782: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
783: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
784: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');
788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);

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

785: dbms_sql.define_column(d_sql_p,14,d_no_cards);
786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');
788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

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

786: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
787: PUT_LINE('Defined the cols in loc-itm');
788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

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

787: PUT_LINE('Defined the cols in loc-itm');
788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

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

788:
789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

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

789: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

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

790: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
798:

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

791: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
798:
799: PUT_LINE('Bind the vars ');

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

792: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
798:
799: PUT_LINE('Bind the vars ');
800:

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

793: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
794: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
795: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
796: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
798:
799: PUT_LINE('Bind the vars ');
800:
801: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

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

797: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
798:
799: PUT_LINE('Bind the vars ');
800:
801: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
802:
803: PUT_LINE('No ofRows='||to_char(d_sql_rows_processed));
804:
805: Loop

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

802:
803: PUT_LINE('No ofRows='||to_char(d_sql_rows_processed));
804:
805: Loop
806: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
807: Rec := TRUE;
808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

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

804:
805: Loop
806: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
807: Rec := TRUE;
808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);

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

805: Loop
806: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
807: Rec := TRUE;
808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);

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

806: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
807: Rec := TRUE;
808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);

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

807: Rec := TRUE;
808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

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

808: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

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

809: dbms_sql.column_value(d_sql_p,2, d_org_id);
810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

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

810: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

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

811: dbms_sql.column_value(d_sql_p,4, d_subinv);
812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

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

812: dbms_sql.column_value(d_sql_p,5, d_loc_id);
813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

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

813: dbms_sql.column_value(d_sql_p,6, d_src_type);
814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);

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

814: dbms_sql.column_value(d_sql_p,7, d_supp_id);
815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);
822: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);

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

815: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);
822: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
823:

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

816: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);
822: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
823:
824: card_check_and_create( d_pull_seq_id,

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

817: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);
822: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
823:
824: card_check_and_create( d_pull_seq_id,
825: d_org_id, d_inv_itm_id, d_subinv,

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

818: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
819: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
820: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
821: dbms_sql.column_value(d_sql_p,14, d_no_cards);
822: dbms_sql.column_value(d_sql_p,15,d_release_kanban_flag);
823:
824: card_check_and_create( d_pull_seq_id,
825: d_org_id, d_inv_itm_id, d_subinv,
826: d_loc_id, d_src_type,

Line 838: dbms_sql.close_cursor(d_sql_p);

834: X_CREATE_CARD_FLAG,
835: X_PLAN_CARD_FLAG);
836: else
837: -- No more rows in cursor
838: dbms_sql.close_cursor(d_sql_p);
839: Exit;
840: end if;
841: End loop;
842: current_error_code := to_char(SQLCODE);

Line 849: if dbms_sql.is_open(d_sql_p) then

845: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
846: PUT_LINE( fnd_message.get );
847: current_error_code := to_char(SQLCODE);
848: end if;
849: if dbms_sql.is_open(d_sql_p) then
850: dbms_sql.close_cursor(d_sql_p);
851: end if;
852: end if;
853: Exception

Line 850: dbms_sql.close_cursor(d_sql_p);

846: PUT_LINE( fnd_message.get );
847: current_error_code := to_char(SQLCODE);
848: end if;
849: if dbms_sql.is_open(d_sql_p) then
850: dbms_sql.close_cursor(d_sql_p);
851: end if;
852: end if;
853: Exception
854: when others then

Line 860: if dbms_sql.is_open(d_sql_p) then

856: THEN
857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
858: print_error;
859: END IF;
860: if dbms_sql.is_open(d_sql_p) then
861: dbms_sql.close_cursor(d_sql_p);
862: end if;
863: v_success := 2;
864: current_error_code := to_char(SQLCODE);

Line 861: dbms_sql.close_cursor(d_sql_p);

857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_with_loc');
858: print_error;
859: END IF;
860: if dbms_sql.is_open(d_sql_p) then
861: dbms_sql.close_cursor(d_sql_p);
862: end if;
863: v_success := 2;
864: current_error_code := to_char(SQLCODE);
865: end;

Line 1070: d_sql_p := dbms_sql.open_cursor;

1066: Begin
1067:
1068: query_range_itm( X_item_lo, X_item_hi, p_where);
1069: if ( p_where IS NOT NULL ) then
1070: d_sql_p := dbms_sql.open_cursor;
1071: --Changes for Ekanban Bug 11829018
1072: IF NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN
1073: d_sql_stmt := 'select mkps.pull_sequence_id ,mkps.organization_id ,mkps.inventory_item_id ,' ||
1074: ' mkps.subinventory_name , mkps.locator_id , mkps.source_type , mkps.supplier_id,' ||

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

1143:
1144: PUT_LINE(' p_where ='||p_where );
1145: PUT_LINE(' d_sql_stmt ='||d_sql_stmt );
1146:
1147: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
1148:
1149: PUT_LINE('Parsed The statement in no_loc');
1150:
1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);

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

1147: dbms_sql.parse( d_sql_p, d_sql_stmt , dbms_sql.native );
1148:
1149: PUT_LINE('Parsed The statement in no_loc');
1150:
1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);

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

1148:
1149: PUT_LINE('Parsed The statement in no_loc');
1150:
1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);

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

1149: PUT_LINE('Parsed The statement in no_loc');
1150:
1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );

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

1150:
1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );

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

1151: dbms_sql.define_column(d_sql_p,1,d_pull_seq_id);
1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );

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

1152: dbms_sql.define_column(d_sql_p,2,d_org_id );
1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );

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

1153: dbms_sql.define_column(d_sql_p,3,d_inv_itm_id);
1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );

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

1154: dbms_sql.define_column(d_sql_p,4,d_subinv,10 );
1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );

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

1155: dbms_sql.define_column(d_sql_p,5,d_loc_id);
1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);

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

1156: dbms_sql.define_column(d_sql_p,6,d_src_type);
1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);

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

1157: dbms_sql.define_column(d_sql_p,7,d_supp_id );
1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);
1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);

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

1158: dbms_sql.define_column(d_sql_p,8,d_supp_site_id );
1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);
1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
1166:

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

1159: dbms_sql.define_column(d_sql_p,9,d_src_org_id );
1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);
1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
1166:
1167: PUT_LINE('Defined the cols in no_locs');

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

1160: dbms_sql.define_column(d_sql_p,10,d_src_subinv,10 );
1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);
1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
1166:
1167: PUT_LINE('Defined the cols in no_locs');
1168:

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

1161: dbms_sql.define_column(d_sql_p,11,d_src_loc_id );
1162: dbms_sql.define_column(d_sql_p,12,d_wip_line_id );
1163: dbms_sql.define_column(d_sql_p,13,d_kanban_size);
1164: dbms_sql.define_column(d_sql_p,14,d_no_cards);
1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
1166:
1167: PUT_LINE('Defined the cols in no_locs');
1168:
1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);

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

1165: dbms_sql.define_column(d_sql_p,15,d_release_kanban_flag);
1166:
1167: PUT_LINE('Defined the cols in no_locs');
1168:
1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);

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

1166:
1167: PUT_LINE('Defined the cols in no_locs');
1168:
1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);

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

1167: PUT_LINE('Defined the cols in no_locs');
1168:
1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);

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

1168:
1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);

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

1169: dbms_sql.bind_variable(d_sql_p,'org_id', X_ORG_ID);
1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);

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

1170: dbms_sql.bind_variable(d_sql_p,'subinv', X_subinv);
1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
1178:

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

1171: dbms_sql.bind_variable(d_sql_p,'source_type', X_source_type);
1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
1178:
1179: PUT_LINE('Bind the vars in no_locs');

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

1172: dbms_sql.bind_variable(d_sql_p,'supplier_id', X_supplier_id);
1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
1178:
1179: PUT_LINE('Bind the vars in no_locs');
1180:

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

1173: dbms_sql.bind_variable(d_sql_p,'supplier_site_id', X_supplier_site_id);
1174: dbms_sql.bind_variable(d_sql_p,'sourcing_org_id', X_sourcing_org_id);
1175: dbms_sql.bind_variable(d_sql_p,'sourcing_subinv', X_sourcing_subinv);
1176: dbms_sql.bind_variable(d_sql_p,'sourcing_loc_id', X_sourcing_loc_id);
1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
1178:
1179: PUT_LINE('Bind the vars in no_locs');
1180:
1181: d_sql_rows_processed := dbms_sql.execute(d_sql_p);

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

1177: dbms_sql.bind_variable(d_sql_p,'line_id', X_wip_line_id);
1178:
1179: PUT_LINE('Bind the vars in no_locs');
1180:
1181: d_sql_rows_processed := dbms_sql.execute(d_sql_p);
1182:
1183: PUT_LINE('No ofRows ='||to_char(d_sql_rows_processed));
1184:
1185: Loop

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

1182:
1183: PUT_LINE('No ofRows ='||to_char(d_sql_rows_processed));
1184:
1185: Loop
1186: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
1187: Rec := TRUE;
1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);

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

1184:
1185: Loop
1186: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
1187: Rec := TRUE;
1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);

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

1185: Loop
1186: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
1187: Rec := TRUE;
1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);

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

1186: if ( dbms_sql.fetch_rows(d_sql_p) > 0 ) then
1187: Rec := TRUE;
1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);

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

1187: Rec := TRUE;
1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);

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

1188: dbms_sql.column_value(d_sql_p,1, d_pull_seq_id);
1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);

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

1189: dbms_sql.column_value(d_sql_p,2, d_org_id);
1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);

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

1190: dbms_sql.column_value(d_sql_p,3, d_inv_itm_id);
1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);

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

1191: dbms_sql.column_value(d_sql_p,4, d_subinv);
1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);

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

1192: dbms_sql.column_value(d_sql_p,5, d_loc_id);
1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);

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

1193: dbms_sql.column_value(d_sql_p,6, d_src_type);
1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);

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

1194: dbms_sql.column_value(d_sql_p,7, d_supp_id);
1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);
1202: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);

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

1195: dbms_sql.column_value(d_sql_p,8, d_supp_site_id);
1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);
1202: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
1203:

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

1196: dbms_sql.column_value(d_sql_p,9, d_src_org_id);
1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);
1202: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
1203:
1204: card_check_and_create( d_pull_seq_id,

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

1197: dbms_sql.column_value(d_sql_p,10, d_src_subinv);
1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);
1202: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
1203:
1204: card_check_and_create( d_pull_seq_id,
1205: d_org_id, d_inv_itm_id, d_subinv,

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

1198: dbms_sql.column_value(d_sql_p,11, d_src_loc_id);
1199: dbms_sql.column_value(d_sql_p,12, d_wip_line_id);
1200: dbms_sql.column_value(d_sql_p,13, d_kanban_size);
1201: dbms_sql.column_value(d_sql_p,14, d_no_cards);
1202: dbms_sql.column_value(d_sql_p,15, d_release_kanban_flag);
1203:
1204: card_check_and_create( d_pull_seq_id,
1205: d_org_id, d_inv_itm_id, d_subinv,
1206: d_loc_id, d_src_type,

Line 1218: dbms_sql.close_cursor(d_sql_p);

1214: X_CREATE_CARD_FLAG,
1215: X_PLAN_CARD_FLAG);
1216: else
1217: -- No more rows in cursor
1218: dbms_sql.close_cursor(d_sql_p);
1219: Exit;
1220: end if;
1221: End loop;
1222: current_error_code := to_char(SQLCODE);

Line 1228: if dbms_sql.is_open(d_sql_p) then

1224: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
1225: PUT_LINE( fnd_message.get );
1226: end if;
1227: current_error_code := to_char(SQLCODE);
1228: if dbms_sql.is_open(d_sql_p) then
1229: dbms_sql.close_cursor(d_sql_p);
1230: end if;
1231: end if;
1232: Exception

Line 1229: dbms_sql.close_cursor(d_sql_p);

1225: PUT_LINE( fnd_message.get );
1226: end if;
1227: current_error_code := to_char(SQLCODE);
1228: if dbms_sql.is_open(d_sql_p) then
1229: dbms_sql.close_cursor(d_sql_p);
1230: end if;
1231: end if;
1232: Exception
1233: when others then

Line 1239: if dbms_sql.is_open(d_sql_p) then

1235: THEN
1236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1237: print_error;
1238: END IF;
1239: if dbms_sql.is_open(d_sql_p) then
1240: dbms_sql.close_cursor(d_sql_p);
1241: end if;
1242: v_success := 2;
1243: current_error_code := to_char(SQLCODE);

Line 1240: dbms_sql.close_cursor(d_sql_p);

1236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'resolve_pullseq_no_loc');
1237: print_error;
1238: END IF;
1239: if dbms_sql.is_open(d_sql_p) then
1240: dbms_sql.close_cursor(d_sql_p);
1241: end if;
1242: v_success := 2;
1243: current_error_code := to_char(SQLCODE);
1244: return v_success;

Line 1981: dsql_cur := dbms_sql.open_cursor;

1977: v_parse_str := 'select '||v_loc_str||
1978: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1979: ' and organization_id = :org_id';
1980:
1981: dsql_cur := dbms_sql.open_cursor;
1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);

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

1978: ' from mtl_item_locations where inventory_location_id = :loc_id '||
1979: ' and organization_id = :org_id';
1980:
1981: dsql_cur := dbms_sql.open_cursor;
1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);

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

1979: ' and organization_id = :org_id';
1980:
1981: dsql_cur := dbms_sql.open_cursor;
1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1987: rows_processed := dbms_sql.execute(dsql_cur);

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

1981: dsql_cur := dbms_sql.open_cursor;
1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1987: rows_processed := dbms_sql.execute(dsql_cur);
1988:
1989: Loop

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

1982: dbms_sql.parse(dsql_cur,v_parse_str,dbms_sql.native);
1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1987: rows_processed := dbms_sql.execute(dsql_cur);
1988:
1989: Loop
1990: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then

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

1983: dbms_sql.define_column(dsql_cur,1,d_data_str,800);
1984:
1985: dbms_sql.bind_variable(dsql_cur,'loc_id',X_loc_id);
1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1987: rows_processed := dbms_sql.execute(dsql_cur);
1988:
1989: Loop
1990: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1991: dbms_sql.column_value(dsql_cur,1,d_data_str);

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

1986: dbms_sql.bind_variable(dsql_cur,'org_id',X_org_id);
1987: rows_processed := dbms_sql.execute(dsql_cur);
1988:
1989: Loop
1990: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1991: dbms_sql.column_value(dsql_cur,1,d_data_str);
1992: else
1993: -- No more rows in cursor
1994: dbms_sql.close_cursor(dsql_cur);

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

1987: rows_processed := dbms_sql.execute(dsql_cur);
1988:
1989: Loop
1990: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1991: dbms_sql.column_value(dsql_cur,1,d_data_str);
1992: else
1993: -- No more rows in cursor
1994: dbms_sql.close_cursor(dsql_cur);
1995: Exit;

Line 1994: dbms_sql.close_cursor(dsql_cur);

1990: if ( dbms_sql.fetch_rows(dsql_cur) > 0 ) then
1991: dbms_sql.column_value(dsql_cur,1,d_data_str);
1992: else
1993: -- No more rows in cursor
1994: dbms_sql.close_cursor(dsql_cur);
1995: Exit;
1996: end if;
1997: End loop;
1998: if dbms_sql.is_open(dsql_cur) then

Line 1998: if dbms_sql.is_open(dsql_cur) then

1994: dbms_sql.close_cursor(dsql_cur);
1995: Exit;
1996: end if;
1997: End loop;
1998: if dbms_sql.is_open(dsql_cur) then
1999: dbms_sql.close_cursor(dsql_cur);
2000: end if;
2001: end if;
2002:

Line 1999: dbms_sql.close_cursor(dsql_cur);

1995: Exit;
1996: end if;
1997: End loop;
1998: if dbms_sql.is_open(dsql_cur) then
1999: dbms_sql.close_cursor(dsql_cur);
2000: end if;
2001: end if;
2002:
2003: if v_seg19_f and v_seg20_f then