Line 51: CURSOR c1 IS SELECT QA_COLLECTION_ID_S.NEXTVAL FROM DUAL;
47:
48:
49: FUNCTION get_collection_id RETURN NUMBER IS
50: 51: CURSOR c1 IS SELECT QA_COLLECTION_ID_S.NEXTVAL FROM DUAL; 52: l_collection_id NUMBER;
53:
54: BEGIN
55:
Line 67: CURSOR c2 IS SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL;
63:
64: FUNCTION get_txn_header_id RETURN NUMBER IS
65:
66: l_txn_header_id NUMBER; 67: CURSOR c2 IS SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL; 68:
69: BEGIN
70:
71: OPEN C2;