APPS.OKE_PRINT_FORM_PUB dependencies on OKE_K_FORM_HEADERS

Line 62: from oke_k_form_headers

58: , c_print_form_code varchar2
59: , c_form_header_num varchar2
60: ) is
61: select form_header_id
62: from oke_k_form_headers
63: where k_header_id = c_header_id
64: and print_form_code = c_print_form_code
65: and form_header_number = c_form_header_num;
66:

Line 229: from oke_k_form_headers

225: and lookup_code = p_header_rec.status_code;
226:
227: cursor pfhnum is
228: select count(1)
229: from oke_k_form_headers
230: where k_header_id = p_header_rec.contract_header_id
231: and print_form_code = p_header_rec.print_form_code
232: and form_header_number = p_header_rec.form_header_number;
233:

Line 236: from oke_k_form_headers

232: and form_header_number = p_header_rec.form_header_number;
233:
234: cursor pfhid is
235: select count(1)
236: from oke_k_form_headers
237: where form_header_id = p_header_rec.form_header_id;
238:
239: l_row_exists NUMBER;
240:

Line 521: SELECT oke_k_form_headers_s.nextval

517: i NUMBER;
518:
519: BEGIN
520:
521: SELECT oke_k_form_headers_s.nextval
522: INTO x_form_header_id
523: FROM dual;
524:
525: INSERT INTO oke_k_form_headers

Line 525: INSERT INTO oke_k_form_headers

521: SELECT oke_k_form_headers_s.nextval
522: INTO x_form_header_id
523: FROM dual;
524:
525: INSERT INTO oke_k_form_headers
526: ( form_header_id
527: , creation_date
528: , created_by
529: , last_update_date

Line 981: UPDATE oke_k_form_headers

977: i NUMBER;
978:
979: BEGIN
980:
981: UPDATE oke_k_form_headers
982: SET last_update_date = sysdate
983: , last_updated_by = l_user_id
984: , last_update_login = l_login_id
985: , status_code = p_header_rec.status_code