DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RCV_PVT dependencies on RCV_HEADERS_INTERFACE

Line 49: l_rcv_header_id rcv_headers_interface.header_interface_id%TYPE;

45: )
46: IS
47: l_api_name VARCHAR2(50) := 'process_rcv_header';
48:
49: l_rcv_header_id rcv_headers_interface.header_interface_id%TYPE;
50: l_group_id rcv_headers_interface.group_id%TYPE;
51:
52: BEGIN
53: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 50: l_group_id rcv_headers_interface.group_id%TYPE;

46: IS
47: l_api_name VARCHAR2(50) := 'process_rcv_header';
48:
49: l_rcv_header_id rcv_headers_interface.header_interface_id%TYPE;
50: l_group_id rcv_headers_interface.group_id%TYPE;
51:
52: BEGIN
53: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
54: THEN

Line 61: rcv_headers_interface_s.NEXTVAL

57: ,'procedure begin');
58: END IF;
59:
60: SELECT
61: rcv_headers_interface_s.NEXTVAL
62: , rcv_interface_groups_s.NEXTVAL
63: INTO
64: l_rcv_header_id
65: , l_group_id

Line 69: INSERT INTO RCV_HEADERS_INTERFACE

65: , l_group_id
66: FROM
67: dual;
68:
69: INSERT INTO RCV_HEADERS_INTERFACE
70: ( header_interface_id
71: , group_id
72: , processing_status_code
73: , receipt_source_code