51: e NUMBER := 0;
52: f NUMBER := 0;
53: g NUMBER := 0;
54: h NUMBER := 0;
55: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
56:
57: CURSOR c_inst (pc_txn_from_date IN DATE,
58: pc_txn_to_date IN DATE,
59: pc_source_system_name IN VARCHAR2,
2514: l_api_name VARCHAR2(255) :=
2515: 'CSI_ML_CREATE_PVT.GET_IFACE_REL_RECS';
2516:
2517: l_sql_error VARCHAR2(2000);
2518: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
2519:
2520: a NUMBER := 0;
2521:
2522: CURSOR c_rel (pc_txn_from_date IN DATE,