DBA Data[Home] [Help]

APPS.QA_RESULTS_API dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 129: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

125: -- rponnusa Mon Apr 1 22:25:49 PST 2002
126:
127: IF p_txn_header_id IS NULL THEN
128: SELECT sysdate,
129: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
130: INTO x_sysdate,
131: x_txn_header_id
132: FROM DUAL;
133: ELSE

Line 525: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

521: -- following code looks for txn_header_id and generates a new one if
522: -- not found.
523:
524: IF p_txn_header_id IS NULL THEN
525: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
526: INTO x_txn_header_id
527: FROM DUAL;
528: ELSE
529: x_txn_header_id := p_txn_header_id;