APPS.MRP_PRINT_PK dependencies on MRP_MESSAGES_TMP

Line 7: UPDATE mrp_messages_tmp

3: PROCEDURE stop_watch(arg_request_id IN NUMBER,
4: arg_transaction_id IN NUMBER,
5: arg_row_count IN NUMBER) IS
6: BEGIN
7: UPDATE mrp_messages_tmp
8: SET end_date = SYSDATE,
9: row_count = arg_row_count
10: WHERE request_id = arg_request_id
11: AND transaction_id = arg_transaction_id;

Line 47: SELECT mrp_messages_tmp_s.nextval

43: arg_token_value2 IN VARCHAR2,
44: arg_translate2 IN VARCHAR2) RETURN NUMBER IS
45: var_transaction_id NUMBER;
46: BEGIN
47: SELECT mrp_messages_tmp_s.nextval
48: INTO var_transaction_id
49: FROM dual;
50:
51: INSERT INTO mrp_messages_tmp

Line 51: INSERT INTO mrp_messages_tmp

47: SELECT mrp_messages_tmp_s.nextval
48: INTO var_transaction_id
49: FROM dual;
50:
51: INSERT INTO mrp_messages_tmp
52: (transaction_id,
53: request_id,
54: last_update_date,
55: last_updated_by,

Line 135: DELETE FROM mrp_messages_tmp

131:
132: PROCEDURE clear_messages( arg_request_id IN NUMBER) IS
133: BEGIN
134:
135: DELETE FROM mrp_messages_tmp
136: WHERE request_id = arg_request_id;
137:
138: END clear_messages;
139: