DBA Data[Home] [Help]

APPS.CN_IMP_REV_CL_PVT dependencies on CN_IMP_HEADERS

Line 77: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;

73: l_sql_stmt VARCHAR2(2000);
74: l_count NUMBER;
75: err_num NUMBER;
76: l_msg_count NUMBER := 0;
77: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
78: l_rev_class_rec cn_revenue_class_pvt.revenue_class_rec_type;
79: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
80:
81: BEGIN

Line 90: FROM cn_imp_headers

86: import_type_code
87: INTO l_imp_header.name ,l_imp_header.status_code ,
88: l_imp_header.server_flag, l_imp_header.imp_map_id,
89: l_imp_header.source_column_num,l_imp_header.import_type_code
90: FROM cn_imp_headers
91: WHERE imp_header_id = p_imp_header_id;
92:
93: -- open process audit batch
94: cn_message_pkg.begin_batch