APPS.FLM_KANBAN_PLANNING_UTIL dependencies on DBMS_SQL

Line 1710: l_cursor := dbms_sql.open_cursor;

1706: 'and nvl(plan.locator_id,-5) = nvl(prod.locator_id,-5) '||
1707: 'and prod.kanban_plan_id = -1 '||
1708: 'and plan.kanban_plan_id <> -1 ';
1709:
1710: l_cursor := dbms_sql.open_cursor;
1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);

Line 1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

1707: 'and prod.kanban_plan_id = -1 '||
1708: 'and plan.kanban_plan_id <> -1 ';
1709:
1710: l_cursor := dbms_sql.open_cursor;
1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);

Line 1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);

1709:
1710: l_cursor := dbms_sql.open_cursor;
1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);

Line 1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);

1710: l_cursor := dbms_sql.open_cursor;
1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);

Line 1715: dbms_sql.define_column(l_cursor, 3, l_card_size);

1711: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);

Line 1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);

1712:
1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);

Line 1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);

1713: dbms_sql.define_column(l_cursor, 1, l_plan_pull_seq_id);
1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);

Line 1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);

1714: dbms_sql.define_column(l_cursor, 2, l_no_of_cards);
1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);

Line 1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);

1715: dbms_sql.define_column(l_cursor, 3, l_card_size);
1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);

Line 1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);

1716: dbms_sql.define_column(l_cursor, 4, l_calc_flag);
1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);

Line 1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);

1717: dbms_sql.define_column(l_cursor, 5, l_eff_date);
1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);

Line 1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);

1718: dbms_sql.define_column(l_cursor, 6, l_no_of_temp_cards);
1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);

Line 1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);

1719: dbms_sql.define_column(l_cursor, 7, l_no_of_cycles);
1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);

Line 1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);

1720: dbms_sql.define_column(l_cursor, 8, l_temp_exp_date);
1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);

Line 1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);

1721: dbms_sql.define_column(l_cursor, 9, l_imp_plan, 10);
1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);

Line 1726: dbms_sql.define_column(l_cursor, 14,l_moq);

1722: dbms_sql.define_column(l_cursor, 10,l_plan_st_dt);
1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);

Line 1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);

1723: dbms_sql.define_column(l_cursor, 11,l_plan_end_dt);
1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);

Line 1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);

1724: dbms_sql.define_column(l_cursor, 12,l_prod_pull_seq_id);
1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);

Line 1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);

1725: dbms_sql.define_column(l_cursor, 13,l_avg_demand);
1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);

Line 1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);

1726: dbms_sql.define_column(l_cursor, 14,l_moq);
1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);

Line 1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);

1727: dbms_sql.define_column(l_cursor, 15,l_alloc_perc);
1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);

Line 1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);

1728: dbms_sql.define_column(l_cursor, 16,l_lead_time);
1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);

Line 1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);

1729: dbms_sql.define_column(l_cursor, 17,l_lot_multiplier);
1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);

Line 1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);

1730: dbms_sql.define_column(l_cursor, 18,l_safety_stock);
1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);

Line 1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);

1731: dbms_sql.define_column(l_cursor, 19, l_attr_1, 150);
1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);

Line 1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);

1732: dbms_sql.define_column(l_cursor, 20, l_attr_2, 150);
1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);

Line 1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);

1733: dbms_sql.define_column(l_cursor, 21, l_attr_3, 150);
1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);

Line 1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);

1734: dbms_sql.define_column(l_cursor, 22, l_attr_4, 150);
1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);

Line 1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);

1735: dbms_sql.define_column(l_cursor, 23, l_attr_5, 150);
1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);

Line 1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);

1736: dbms_sql.define_column(l_cursor, 24, l_attr_6, 150);
1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);

Line 1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);

1737: dbms_sql.define_column(l_cursor, 25, l_attr_7, 150);
1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);

Line 1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);

1738: dbms_sql.define_column(l_cursor, 26, l_attr_8, 150);
1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);

Line 1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);

1739: dbms_sql.define_column(l_cursor, 27, l_attr_9, 150);
1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);
1747:

Line 1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);

1740: dbms_sql.define_column(l_cursor, 28, l_attr_10, 150);
1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);
1747:
1748: l_sql_exec := dbms_sql.execute(l_cursor);

Line 1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);

1741: dbms_sql.define_column(l_cursor, 29, l_attr_11, 150);
1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);
1747:
1748: l_sql_exec := dbms_sql.execute(l_cursor);
1749:

Line 1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);

1742: dbms_sql.define_column(l_cursor, 30, l_attr_12, 150);
1743: dbms_sql.define_column(l_cursor, 31, l_attr_13, 150);
1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);
1747:
1748: l_sql_exec := dbms_sql.execute(l_cursor);
1749:
1750: loop

Line 1748: l_sql_exec := dbms_sql.execute(l_cursor);

1744: dbms_sql.define_column(l_cursor, 32, l_attr_14, 150);
1745: dbms_sql.define_column(l_cursor, 33, l_attr_15, 150);
1746: dbms_sql.define_column(l_cursor, 34, l_release_kanban_flag);
1747:
1748: l_sql_exec := dbms_sql.execute(l_cursor);
1749:
1750: loop
1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);

Line 1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;

1747:
1748: l_sql_exec := dbms_sql.execute(l_cursor);
1749:
1750: loop
1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);

Line 1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);

1748: l_sql_exec := dbms_sql.execute(l_cursor);
1749:
1750: loop
1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);

Line 1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);

1749:
1750: loop
1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);

Line 1754: dbms_sql.column_value(l_cursor, 3, l_card_size);

1750: loop
1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);

Line 1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);

1751: exit when dbms_sql.fetch_rows(l_cursor) = 0;
1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);

Line 1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);

1752: dbms_sql.column_value(l_cursor, 1, l_plan_pull_seq_id);
1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);

Line 1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);

1753: dbms_sql.column_value(l_cursor, 2, l_no_of_cards);
1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);

Line 1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);

1754: dbms_sql.column_value(l_cursor, 3, l_card_size);
1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);

Line 1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);

1755: dbms_sql.column_value(l_cursor, 4, l_calc_flag);
1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);

Line 1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);

1756: dbms_sql.column_value(l_cursor, 5, l_eff_date);
1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);

Line 1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);

1757: dbms_sql.column_value(l_cursor, 6, l_no_of_temp_cards);
1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);

Line 1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);

1758: dbms_sql.column_value(l_cursor, 7, l_no_of_cycles);
1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);

Line 1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);

1759: dbms_sql.column_value(l_cursor, 8, l_temp_exp_date);
1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);

Line 1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);

1760: dbms_sql.column_value(l_cursor, 9, l_imp_plan);
1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);

Line 1765: dbms_sql.column_value(l_cursor, 14, l_moq);

1761: dbms_sql.column_value(l_cursor, 10,l_plan_st_dt);
1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);

Line 1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);

1762: dbms_sql.column_value(l_cursor, 11,l_plan_end_dt);
1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);

Line 1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);

1763: dbms_sql.column_value(l_cursor, 12,l_prod_pull_seq_id);
1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);

Line 1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);

1764: dbms_sql.column_value(l_cursor, 13, l_avg_demand);
1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);

Line 1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);

1765: dbms_sql.column_value(l_cursor, 14, l_moq);
1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);

Line 1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);

1766: dbms_sql.column_value(l_cursor, 15, l_alloc_perc);
1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);

Line 1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);

1767: dbms_sql.column_value(l_cursor, 16,l_lead_time);
1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);

Line 1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);

1768: dbms_sql.column_value(l_cursor, 17,l_lot_multiplier);
1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);

Line 1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);

1769: dbms_sql.column_value(l_cursor, 18,l_safety_stock);
1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);

Line 1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);

1770: dbms_sql.column_value(l_cursor, 19, l_attr_1);
1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);

Line 1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);

1771: dbms_sql.column_value(l_cursor, 20, l_attr_2);
1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);

Line 1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);

1772: dbms_sql.column_value(l_cursor, 21, l_attr_3);
1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);

Line 1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);

1773: dbms_sql.column_value(l_cursor, 22, l_attr_4);
1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);

Line 1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);

1774: dbms_sql.column_value(l_cursor, 23, l_attr_5);
1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);

Line 1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);

1775: dbms_sql.column_value(l_cursor, 24, l_attr_6);
1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);

Line 1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);

1776: dbms_sql.column_value(l_cursor, 25, l_attr_7);
1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);

Line 1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);

1777: dbms_sql.column_value(l_cursor, 26, l_attr_8);
1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);
1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);

Line 1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);

1778: dbms_sql.column_value(l_cursor, 27, l_attr_9);
1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);
1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);
1786: l_eff_date := p_effective_date;

Line 1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);

1779: dbms_sql.column_value(l_cursor, 28, l_attr_10);
1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);
1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);
1786: l_eff_date := p_effective_date;
1787: l_kanban_size := l_card_size;

Line 1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);

1780: dbms_sql.column_value(l_cursor, 29, l_attr_11);
1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);
1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);
1786: l_eff_date := p_effective_date;
1787: l_kanban_size := l_card_size;
1788: if l_calc_flag = 1 then -- Calculate Size

Line 1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);

1781: dbms_sql.column_value(l_cursor, 30, l_attr_12);
1782: dbms_sql.column_value(l_cursor, 31, l_attr_13);
1783: dbms_sql.column_value(l_cursor, 32, l_attr_14);
1784: dbms_sql.column_value(l_cursor, 33, l_attr_15);
1785: dbms_sql.column_value(l_cursor, 34, l_release_kanban_flag);
1786: l_eff_date := p_effective_date;
1787: l_kanban_size := l_card_size;
1788: if l_calc_flag = 1 then -- Calculate Size
1789: l_no_of_cards := null;

Line 2155: dbms_sql.close_cursor(l_cursor);

2151: end loop;
2152: end if;
2153: end if;
2154: end loop;
2155: dbms_sql.close_cursor(l_cursor);
2156:
2157: commit;
2158: x_ret_status := 0;
2159: Exception