265: ) IS
266:
267: CURSOR Get_Cont_Load (v_cont_id NUMBER, v_inv_item_id NUMBER) IS
268: SELECT max_load_quantity, container_item_id
269: FROM WSH_CONTAINER_ITEMS
270: WHERE container_item_id = NVL(v_cont_id, container_item_id)
271: AND load_item_id = v_inv_item_id
272: AND master_organization_id = p_in_record.organization_id
273: AND preferred_flag = DECODE(nvl(v_cont_id,-99),-99,'Y',preferred_flag);
1046: x_return_status OUT NOCOPY VARCHAR2) IS
1047:
1048: CURSOR Get_Cont_Load (v_cont_id NUMBER, v_inv_item_id NUMBER) IS
1049: SELECT max_load_quantity, container_item_id
1050: FROM WSH_CONTAINER_ITEMS
1051: WHERE container_item_id = NVL(v_cont_id, container_item_id)
1052: AND load_item_id = v_inv_item_id
1053: AND master_organization_id = p_organization_id
1054: AND preferred_flag = DECODE(nvl(v_cont_id,-99),-99,'Y',preferred_flag);
1714: x_return_status OUT NOCOPY VARCHAR2) IS
1715:
1716: CURSOR Get_Cont_Load (v_cont_id NUMBER, v_inv_item_id NUMBER) IS
1717: SELECT max_load_quantity, container_item_id
1718: FROM WSH_CONTAINER_ITEMS
1719: WHERE container_item_id = NVL(v_cont_id, container_item_id)
1720: AND load_item_id = v_inv_item_id
1721: AND master_organization_id = p_organization_id
1722: AND preferred_flag = DECODE(nvl(v_cont_id,-99),-99,'Y',preferred_flag);